Skip to main content

Bulk Uploading Courses

This article provides specific details on bulk uploading courses (or classes) using the powerful bulk upload feature.

The Bulk Upload article provides common general instruction on how to bulk upload various information into Grado. The focus here is on the crucial aspects of the CSV template for courses. We will explore the required fields, clarify what information is essential, outline validation requirements, and show the correct format for a successful upload.

Prerequisites

Needs at least one subject existing in the system.

Bulk Uploading Courses

Please follow the instructions here.

In order to associate multiple classes or courses to a single section within the CSV template, users should provide the necessary details for each class or course on separate rows. Each row should correspond to a specific class or course, containing the relevant information such as Class/Course Name, Section Name, Section starting academic year, Section term, and other pertinent fields. By specifying each class per row in the template, users can accurately establish the connections between classes or courses and the corresponding section, ensuring proper organization and management of the data during the bulk upload process.

CSV Template Anatomy

Upon opening the CSV template for bulk uploading courses, you will see the following headers:

image-1683882710023.png

The table below outlines what each header mean as well acceptable values and validations for successful bulk upload of courses:

Template Header Description Required? Unique? Case-Sensitive? Acceptable Values Sample Values
Class name   NO
YES Course name G7Mag-AP 7
G7Ila-SCI 7
G7Ila-FIL 7
Section name
NO
NO Section name Gr9-Uranus
Gr9-Mercury
Gr8-Gmelina
Gr8-Molave"
Subject short name   YES
YES Subject short name FIL 101
ENG 101
MATH 101
Schedule Day   NO
NO ["m", "mon", "monday"]
["tu", "tue", "tuesday"]
["w", "wed", "wednesday"]
["th", "thu", "thursday"]
["f", "fri", "friday"]
["sa", "sat", "saturday"]
["su", "sun", "sunday"]		 Monday
tu
wed
Schedule Time Start   NO
NA HH:MM:SS P 9:00:00 AM
Schedule Time End   NO
NA HH:MM:SS P 12:00:00 PM
Building name   NO
NO Building name HV Lab
Room Name or Number   NO
YES Room number in the provided building 401
Class slot total   YES
NA Course slot number 100
25
150
250
350
12
Faculty email  
YES if course provided does not exist yet
YES Faculty email juandelacruz@school.edu.ph
Faculty employee number
NO.
 YES YES Faculty employee number "2017-E051
E055"
Class starting AY year   NO
NA Four digit year 2022
Class term   NO
NO ["1st", "first", "1"]
["2nd", "second", "2"]
["3rd", "three", "3"]
["year long", "yearlong", "year_long", "long year"]
["summer", "midsem", "summer/midsem", "midsem/summer", "4"]		 First
Year long
Grade book assessment count
NO
N/A blank, 1-10 1-10
Notes
  • For class name, if provided course is not found in scope of provided subject and term, a new course will be created handled by the provided faculty email. Else course will be updated. If not provided, it will be auto generated.
  • The following columns are required to create course schedule. If one column is not provided, a schedule will not be created:
    • Schedule Day
    • Schedule Time Start
    • Schedule Time End
    • Building name
    • Room Name or Number
  • Class starting AY year: Will default to school's current academic year if not provided.
  • Grade book assessment count: Cannot be updated via bulk upload.
Back to top