1. Home
  2. School Administrators
  3. Uploading, Adding, Updating and Validating of Student Information

Uploading, Adding, Updating and Validating of Student Information

How do I import students?

School boards are responsible for uploading the initial student data into your classes and lists. However, some schools may need to add students. The import feature can be used to add multiple students at a time. 

1. After logging into your account, select the Students tab.

This image has an empty alt attribute; its file name is image.png

2. Select the assessment for which you would like to import students: either Grade 9 Mathematics or OSSLT.

This image has an empty alt attribute; its file name is image-1.png

3. Then select the Import button found on the top-right corner of the page.

This image has an empty alt attribute; its file name is image-2.png

4. To import data into the system, first click Template to download a sample Excel spreadsheet to input student data. For assistance determining the appropriate values for each column in the template, click the Student Import Data Definitions button; this will download a spreadsheet containing data definitions for the values in the template.

This image has an empty alt attribute; its file name is image-3.png

5. Once you have filled out the template student data, save the file and then select Import. Please note that you can only import a maximum of 60 records at once.

This image has an empty alt attribute; its file name is image-4.png

6. A preview of the data will appear in the window. If the information is accurate, select OK. If you have selected the incorrect file or would like to edit the information again before uploading, click Cancel to close the window. Once you have finished editing the file, you can select Import again to upload the modified file.

This image has an empty alt attribute; its file name is image-5.png

If there is missing or invalid information in the student data to be imported, an error message will appear identifying the items with validation errors; this will prevent the student data from being uploaded. You will need to edit the document to include the appropriate information and then import the file again.

This image has an empty alt attribute; its file name is image-6.png

7. Once the import is complete, the student data will appear in the Students table.

How do I validate student information?

1. A warning icon on the Students tab of your dashboard indicates that there is student data to be validated. Select the Students tab to start validating student data.

This image has an empty alt attribute; its file name is image-8.png

2. A message will appear at the top of the Students page indicating that you need to review the student data for the assessment type that you currently have selected.

This image has an empty alt attribute; its file name is image-9.png

3. A warning icon will appear next to the OEN number of any student with missing information or where there is a conflict due to data provided in a board upload. Click the student’s OEN or name to review the student data and correct the error; alternatively, select the student and then click Edit Student Info.

This image has an empty alt attribute; its file name is image-10.png

4. To only view students who have errors associated with their information, click Show Flagged Items Only.

This image has an empty alt attribute; its file name is image-11.png

To return to the list of all students, click Show All Students.

This image has an empty alt attribute; its file name is image-12.png

5. Once all of the students have been reviewed and their data has been validated, the flags will be removed from their accounts. You can now select Confirm that all student data has been validated.

This image has an empty alt attribute; its file name is image-13.png

6. After you have confirmed that the data is validated, a green message will appear at the top of the Students page confirming the validation.

This image has an empty alt attribute; its file name is image-14.png

Please note that the validation process should be completed prior to the administration period and will be required prior to the release of student reports.