Bulk Uploading Student Information

Summary: Summary: This article provides instructionsspecific details on bulk uploading basic student information using the powerful bulk upload feature.

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

The bulk upload feature allows users to efficiently upload large amount of basic student information.

Prerequisites

Bulk uploading student information requires theat followingleast dataone todegree existprogram existing in the systemsystem. first:For K10, Elementary (elem) and Junior High school (hs) programs already exists in the system.

• Bulk Uploading Degree Programs

  or

  Please Tracks

follow

K-10the studentinstructions information does not require creating programs first.here.

CSV Template Anatomy

TheUpon opening the CSV template for bulk uploaduploading studentdegree informationprograms, can be downloaded by clicking Download Template under the Student Information section of the Bulk Upload page.

Upon clicking the link, a CSV file named students.csvyou will be downloaded in your local folder.

The template consists ofsee the following headers:

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

Template Header	Description	Acceptable Values	Sample Values	Case-Sensitive?
Batch Name	Student batch. Optional	School batch name	J-2022	NO
Student email	Optional depending on school settings. Auto-generated if left blank.	Student email	juandelacruz@school.edu.ph	NA
Student first name	Required.	Student first name	Juan	NA
Student middle name	Not Required.	Student middle name	Carlos	NA
Student last name	Required.	Student last name	Dela Cruz	NA
Student suffix	Not Required.	Student suffix	Jr	NA
Student number	If left blank, system will auto-generate. See Student Number Generation.	Student number	2018-00624	NA
LRN	Student Learner Number. Issued to DepEd K12 students. Not Required.	Student LRN	108847120106	NA
Educ Program short name	Program shortened name. Required.	Degree program short name given on the the schools degree programs	Academic – HUMSS Elem HS	NO
School specialization name	Student's program specialization. Not required.	School specialization name	STEM Office Administration	NO
Standing year level	Current study level of the student. Required.	["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	NO
Standing term	Current term of the student if applicable. Required.	["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	NO
Year of entry	Year the student entered the school. Required.	Four digit year	2018 2014	NA
Year Level on Entry	Student's study level upon school entry. Required.	["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	NO
Curriculum Authority Number		Curriculum’s authority number	Acad-HUMSS HS	YES

Bulk Uploading Student Information

1. Download the CSV template for student information.

2. Populate the CSV file with the relevant student information, making sure to follow the acceptable values as described in the above section.

Double check information to be uploaded. Of particular note is the LRN, which some spreadsheet programs convert to scientific notation. If saved as a CSV file and closed, the format will be retained and cannot be reconverted back to the proper format.

3. In the Bulk Upload page, click the Choose file area under the Student information section, and select the populated CSV file.

4. Click the Upload link. A notification on the top will indicate the upload is in progress.

5. Check progress going to the Bulk Upload History page.