Bulk Uploading Student Eligibility

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 eligibility. 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 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 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 If no email, student number, or LRN provided YES Student first name Juan Student middle name Middle name or middle initial/s. YES If no email, student number, or LRN provided YES Student middle name Carlos Student last name Last name or surname. YES If no email, student number, or LRN provided YES Student last name Dela Cruz Student Number School issues student number. YES If no email, name, or LRN provided YES Student number 2018-00624 LRN Student Learner Number. Issued to DepEd K12 students. YES If no email, name, or student number provided YES Student LRN 108847120106 Student is Eligible Boolean indicator if student is eligible YES NO ["yes", "y", "true", "t", "eligible"]
["no", "n", "false", "f","ineligible"] yes
Ineligible

Double check information to be uploaded. Of particular note is 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.