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.

CSV Template Anatomy

Upon opening the CSV template for bulk uploading subjects,courses, 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 subjects:courses:

Template Header	Description	Required?	Case-Sensitive?	Acceptable Values	Sample Values
SubjectClass name

NO YES YES SubjectCourse name EnglishG7Mag-AP for7
G7Ila-SCI Academic7
G7Ila-FIL and Professional Purposes
Research Project
Fundamentals of ABM 2
Principles of Marketing
Applied Economics 27 Subject short name
  YES YES Subject short name FIL 101
ENG 101
MATH 101
ENTREP 101
FIL 7
III 101
EsP 9
EsP 8 SubjectSchedule display nameDay   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 SubjectHH:MM:SS display nameP Health9:00:00 8
Health 9
Physical Education 8
Physical Education 9AM SubjectSchedule displayTime short nameEnd
  NO NA SubjectHH:MM:SS displayP short12:00:00 PM Building name
  NO NO Building name HV Lab SubjectRoom UnitsName or Credit CountNumber
  NO YES Room number in the provided building 401 Class slot total   YES NA maxCourse precisionslot 3 scale 2number 1.0100
0.25
150
250
350
12 SubjectFaculty descriptionemail
  YES Faculty email juandelacruz@school.edu.ph Class starting AY year   NO NA SubjectFour descriptiondigit year
2022 SubjectClass amountterm
NO NA max precision 10 scale 4 1234567891.1234
1250.0 Transmutation table name
YES NO Transmutation name deped transmutation Department name
NO NO Department name Senior High School
Secondary Education
Elementary Education Subject grade item count
NO NA whole number 0
2
4 Is shs
YES if year level is not provided YES if “true”
NO if “yes”

user can only input ["true"
but "yes" can be inputted as "Yes"1st", "yEs", "YES", "yeS", ... [“true”, “yes”] true
yes
YES
Yes
yEs
yeS Is k10
YES if year level is not provided YES if “true”
NO if “yes”


user can only input "true"
but "yes" can be inputted as "Yes", "yEs", "YES", "yeS", ... [“true”, “yes”] true
yes
YES
Yes
yEs
yeS Subject Year Level

NO NA ["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"first", "1"]
["2nd year"2nd", "2ndyear", "second year"second", "2"]
["3rd year"3rd", "3rdyear", "third year"three", "3"]
["4thyear year"long", "4thyear"yearlong", "fourthyear_long", "long year"]
["summer", "midsem", "summer/midsem", "midsem/summer", "4"]
["5th year", "5thyear", "fifth year", "5"]
["6th year", "6thyear", "sixth year", "6"] GradeFirst
Year 1
Grade 7
Grade 11
Third Yearlong