Bulk Uploading Student Eligibility
Summary: This article provides specific details on bulk uploading student eligibility information 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.
Prerequisites
Bulk uploading student eligibility requires that basic student information is already in the system. Some information may overlap (such as student names), in which case the data in the student profiles CSV will overwrite the existing one in the system.
Bulk Uploading Student Eligibility
Please follow the instructions here.
CSV Template Anatomy
Upon opening the CSV template for bulk uploading student profile,eligibilities, 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 student profile:eligibilities:
Student's school-provided or personal email address
YES If no name, student number, or LRN provided
N/A
Student email
juandelacruz@school.edu.ph
Student first name
First name/s.
YES
ifIf no
email, student
numbernumber, or LRN provided
YES
Student first name
Juan
Student middle name
Middle name or middle initial/s.
YES
ifIf no
email, student
numbernumber, or LRN provided
YES
Student middle name
Carlos
Student last name
Last name or surname.
YES
ifIf no
email, student
numbernumber, or LRN provided
YES
Student last name
Dela Cruz
Student
suffix
No
N/A
Student suffix
Jr
Student Number
School issues student number.
YES
ifIf no
LRNemail, name, or
student nameLRN provided
YES
Student number
2018-00624
LRN
Student Learner Number. Issued to DepEd K12 students.
YES
ifIf no
studentemail, numbername, or student
namenumber provided
YES
Student LRN
108847120106
SexStudent is Eligible
Boolean indicator if student is eligible
NOYES
NO
["male"yes", "m"y", "true", "t", "eligible"]
["female"no", "n", "false", "f","ineligible"]
Maleyes
F
Student contact no
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 have max precision of 6 and max scale of 2.
1234.12123456
weight unit
NO
NO
["kg", "kilogram", "kilos"]["lb", "pound"]["g", "gram"]
Kgpoundgram
height number
NO
N/A
Number should have max precision of 3 and max scale of 2.
1.23
123
12.3
height unit
NO
NO
["m", "meter", "metre"]["in", "inches", "inch"]["cm", "centimeter", "centimetre"]
minchescentimetre
nationality
NO
N/A
Nationality
Filipino
Address house number
NO
N/A
House number
#224
Address barangay
NO
N/A
Barangay
Brgy. 134San 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
9992214852Ineligible
Double check information to be uploaded. Of particular note areis the 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.
