Create Student Data Files
Build the student data files by following the format indicated below.
We recommend uploading an updated student .csv file on a termly basis.
This file identifies all the schools.
|Name||char(250)||Full school name.|
LINC|Lincoln Secondary School|1
JOHNS|Johns Middle School|2
This file identifies all enrolled students that will use Xello in years 7-13. It must include the CurrentSchoolCode.
|UPN ID||char(15)||The student's unique pupil number that identifies each pupil in the local-authority-maintained school system.|
|FirstName||char(100)||Student's first name.|
|LastName||char(100)||Student's last name.|
|Gender||char(1)||M = Male, F = Female, N = Not Specified.|
|DateOfBirth||Date||Student's birth date. Format dd-mm-yyyy. Note: Ensure the format is entered correctly. Do not spell out the date.|
|CurrentYear||Int||The year the student is in. Note: Ensure the format is only the numerical value. Do not include the word "Year".|
|CurrentSchoolCode||char(15)||The SchoolCode of the student's current school.|
|Username||char(100)||UPN ID cannot be used as username. Email addresses or any username used by the school can be provided as their Xello username.|
|char(100)||Student's email address.|
|Password||char(10)||Suggested password for the student.|
|ULN ID||char(15)||A student's unique learner number is used alongside and to access the Personal Learning Record of anyone over the age of 13 involved in UK education or training.|