Excel File Support

19 September 2024 16:38

The student data contains three sections that you need to fill out. We have the Student's Information, the Teacher's details, and lastly, the School's Information.  

Student's Information

The first two columns are the Unique and Alternate IDs. These fields are both optional. If your district or school is keeping track of the student's ID information, these rows could be populated.

Unique ID (Required): is a permanent unique identifier for each child that does not change from year to year (e.g. Student Number that will stay with the child for their entire academic career). This is usually the provincial education ID number of the student.

Alternate ID (Optional): this is the school ID and is issued at the school level. 

Student’s Name - Please do not use any special characters when entering the children’s name. 

• Last Name (Required): Student’s surname
• First Name (Required): Student's given name.
• Middle Name (Optional): Student's middle name(s).

Gender (Required): this refers to the student's gender (e.g., M, F or Male, Female). 

Date of Birth (Required): Please ensure that the day and month are placed in the appropriate column, the format is (dd/mm/yyyy).

Grade (Required): enter the student's current grade level in this column.

The next section is the Teacher's Information. When the file is uploaded to the system, teachers are automatically added to their designated classrooms.

 

This section is for data regarding the teacher(s) and class(es). 

• Last Name (Required): Teacher's Surname. 
• First Name (Required): Teacher's given name. 
• Email (Required): This is simply the Teacher's district email address. 

Please ensure that the spelling within the provided email address is correct, otherwise, users will not receive their login information once the session is opened.

Classroom Name (Required): The name of the classroom (e.g., K3, AM/PM). Please ensure that the classroom names are unique within each school in the jurisdiction.

 

This section is for data regarding the school and jurisdiction(s). 

• School Name (Required): We highly recommend adding the school’s full name and not the abbreviation. This ensures all naming conventions are consistent on a year-over-year basis, as well as making it easier to support teachers/evaluators. 
• Jurisdiction Name (Required): The name of the district/division/council/network/etc. that the school(s) belong to.

Please note that the school name entered here needs to match the name we already have in the application, if applicable. We highly recommend addressing the school by its full name and not an abbreviation.

 

First Name, Last Name, and Email Address (Required): Please fill out the additional tab at the bottom of the file, this will need to be filled out with any Additional Personnel that will require access to school reports, as well as allow them to enter assessment data where applicable. Please add the names and email addresses of the additional users (Principals, Vice Principals, Learning Specialists, Data coordinators, and consultants) that would require them to have access to and monitor the progress of their school. 

Please note that we require this to be filled out for every new session.

Level of Access Information

• School Names (Required): Please indicate the name of the school that this user would require to have access to.

  Please note that the school's name must not be abbeviated.. 

   

  • Role (Optional): Please indicate the person's job title or role in this section.
  • Enter Scores (Required):  Please indicate here whether they will be assisting in entering student scores or not. The answers are (Yes/No).

  Please note that you do not need to include the names of the classroom teacher(s) as their access has already been indicated in the Student Data File. Only add additional teachers here if they require access to the school's report.