Bulk Uploading Sections

This article provides specific details on bulk uploading sections 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 sections. 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 degree program and at least one Course/Class existing in the system.

Bulk Uploading Sections

Please follow the instructions here.

CSV Template Anatomy

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

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
Section starting AY year	The academic year in which a class/course section commences.	YES	NA	Four digit year	2020 2017
Section term	The term or semester during which a class or course section is scheduled to take place.	YES	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
Section year level	The grade/study level to which a class or course section is assigned.	YES	NO	["kinder", "-12"] ["grade 1", "grade1", "grade one", "-11"] ["grade 2", "grade2", "grade two", "-10"] ["grade 3", "grade3", "grade three", "-9"] ["grade 4", "grade4", "grade four", "-8"] ["grade 5", "grade5", "grade five", "-7"] ["grade 6", "grade6", "grade six", "-6"] ["grade 7", "grade7", "grade seven", "-5"] ["grade 8", "grade8", "grade eight", "-4"] ["grade 9", "grade9", "grade nine", "-3"] ["grade 10", "grade10", "grade ten", "-2"] ["grade 11", "grade11", "grade eleven", "-1"] ["grade 12", "grade12", "grade twelve", "0"] ["1st year", "1styear", "first year", "1"] ["2nd year", "2ndyear", "second year", "2"] ["3rd year", "3rdyear", "third year", "3"] ["4th year", "4thyear", "fourth year", "4"] ["5th year", "5thyear", "fifth year", "5"] ["6th year", "6thyear", "sixth year", "6"]	Grade 1 Grade 7 Grade 11 Third Year
Section name	Unique identifier or label assigned to a specific class or course section.	YES	NA	Section name	Gr9-Uranus Gr9-Mercury Gr8-Gmelina Gr8-Molave
Educ Program short name	Shortened name of the educational/degree program.	YES	YES	Degree program short name	HS Elem Academic - ABM Academic – HUMSS
Class name	Name assigned to the class/course to be associated with the section.	NO	YES	Course name	G7Mag-AP 7 G7Ila-SCI 7 G7Ila-FIL 7 G7Ila-EsP 7 G7Ila-TLE 7

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.