Bulk Uploading Student Profile
Summary: Summary: This article provides specific details on bulk uploading student profile - meant to supplement basic student information as well to update student information in the system - 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 student profile. 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 atthat leastbasic onestudent degreeinformation programis existingalready in the system. ForSome K10,information Elementarymay overlap (elem)such andas Juniorstudent Highnames), schoolin (hs)which programscase alreadythe existsdata in the student profiles CSV will overwrite the existing one in the system.
Bulk Uploading Degree Programs
Please follow the instructions here.
CSV Template Anatomy
Upon opening the CSV template for bulk uploading degreestudent programs,profile, 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 basic student information:profile:
Student batch name.
No.
NO
School batch name
J-2022
Student email
Student's school-provided or personal email address.
Optional depending on school settings. Auto-generated if left blank.
N/A
Student email
juandelacruz@school.edu.ph
Student first name
First name/s.
Yes.YES if no student number or LRN provided
N/AYES
Student first name
Juan
Student middle name
Middle name
YES if no student number or
middleLRN initial/s.provided
No.
N/AYES
Student middle name
Carlos
Student last name
Last name
YES if no student number or
surname.LRN provided
Yes.
N/AYES
Student last name
Dela Cruz
Student suffix
Name suffixes such as Jr., III etc.
No.No
N/A
Student suffix
Jr
Student
numberNumber
School issues
YES if no LRN or student
number.name provided
If left blank, system will auto-generate. See Student Number Generation.
N/AYES
Student number
2018-00624
LRN
Student Learner Number. Issued to DepEd K12 students.
No.YES if no student number or student name provided
N/AYES
StudentStuden LRN
108847120106
Educ Program short nameSex
Program shortened name.
Yes,
NO
Degree program short name given on the the schools degree programs
Academic – HUMSSElemHS
School specialization name
Student's program specialization (e.g. major)
No.
NO
School specialization name
STEMOffice Administration
Standing year level
Current study level of the student.
Yes.
NO
["
kinder"male", "
-12"m"]
["
grade 1"female", "
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"f"]
Grade 1MaleGrade 7Grade 11Third YearF
StandingStudent termcontact no
Current term
NO
N/A
11 digit contact no
9992214852
birth date
NO
N/A
MM/DD/YYY
10/25/1999
weight number
NO
N/A
Number should be have max precision of
the6 studentand ifmax applicable.scale of 2.
Yes.1234.12123456
weight unit
NO
NO
["
1st"kg", "
first"kilogram", "
1"kilos"]
["
2nd"lb", "
second", "2"pound"]
["
3rd"g", "
three", "3"]["year long", "yearlong", "year_long", "long year"]["summer", "midsem", "summer/midsem", "midsem/summer", "4"gram"]
FirstKgYear longpoundgram
Yearheight of entrynumber
Year the student entered the school.
Yes.NO
N/A
FourNumber digitshould yearbe have max precision of 3 and max scale of 2.
20182014
1.23
123
12.3
Yearheight Level on Entryunit
Student's study level upon school entry.
Yes.NO
NO
["m", "meter", "metre"]["in", "inches", "inch"]["cm", "centimeter", "centimetre"]
minchescentimetre
nationality
NO
N/A
["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"]Nationality
Grade 1Grade 7Grade 11Third YearFilipino
CurriculumAddress Authorityhouse Numbernumber
NO
N/A
House number
#224
Address barangay
No.NO
YESN/A
Curriculum’s authority numberBarangay
Acad-HUMSSBrgy. 134HSSan Jose
Address City or Municipality
NO
N/A
Municipality
Mabalacat CityAngeles City
Address Street
NO
N/A
Street
Freesia st.Cabuco st.
Address province
NO
N/A
Province
PampangaBulacan
Address region
NO
N/A
Region
Region 3Region IIICALABARZONNCR
father last name
NO
N/A
Last name
Dela Cruz
father first name
NO
N/A
First name
Juanito
father middle name
NO
N/A
Middle name
Cabrera
mother last name
NO
N/A
Last name
Dela Cruz
mother first name
NO
N/A
First name
Maria
mother middle name
NO
N/A
Middle name
Gonzales
mother maiden name
NO
N/A
Mother’s maiden name
Maria Gonzales Carlos
guardian first name
NO
N/A
First name
Leonor
guardian last name
NO
N/A
Last name
Carlos
guardian relationship
NO
N/A
Relationship to guardian
Uncle
father contact no
NO
N/A
11 digit contact no
9374332635
mother contact no
NO
N/A
11 digit contact no
9756623811
guardian contact no
NO
N/A
11 digit contact no
9992214852
Double check information to be uploaded. Of particular note isare the LRN,LRN and contact numbers, 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.
