Skip to main content

Bulk Uploading Sections

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.

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? Case-Sensitive? Acceptable Values Sample Values
Class name
NO YES Course name G7Mag-AP 7
G7Ila-SCI 7
G7Ila-FIL 7
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
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

Back to top