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:

Template Header	Description	Required?	Case-Sensitive?	Acceptable Values	Sample Values
Student email	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.12 123456
weight unit		NO	NO	["kg", "kilogram", "kilos"] ["lb", "pound"] ["g", "gram"]	Kg pound gram
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"]	m inches centimetre
nationality		NO	N/A	Nationality	Filipino
Address house number		NO	N/A	House number	#224
Address barangay		NO	N/A	Barangay	Brgy. 134 San Jose
Address City or Municipality		NO	N/A	Municipality	Mabalacat City Angeles City
Address Street		NO	N/A	Street	Freesia st. Cabuco st.
Address province		NO	N/A	Province	Pampanga Bulacan
Address region		NO	N/A	Region	Region 3 Region III CALABARZON NCR
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.