EN
SC
WA
NI
CA
AU
NZ
ALL
How to upload multiple classes
Select which option you would like to find out more about:
How to prepare your spreadsheet for upload
It’s best to have your spreadsheet of student details ready prior to undertaking the upload. You can download your students’ data from your school’s information system, input it into a spreadsheet and delete the unwanted columns.
Do not include any headings in the spreadsheet as this can confuse the system. Ensure that the first row of the spreadsheet contains student data you want to upload.
It is important to ensure that the names in your spreadsheet match the names already in the system for any existing students, otherwise duplicate accounts will be created. For example: If a student’s existing account uses another spelling of their name, or includes a middle-name or different last name from that which you’re trying to upload, the system will take these as separate user accounts and create a new account for the student.
Basic Details: This example shows how a spreadsheet should look if only including the mandatory information for creating or modifying a class.
Column A: Student’s first name
Column B: Student’s last name
Column C: Student’s grade
Column D: Name of the class the student should be placed in
Basic details + username & password (optional): This example shows how to include a username and password for your students alongside the mandatory information. This can be used to modify your students’ login details or create custom usernames and passwords.
Follow the same structure for columns A-D as noted in Example 1, but adding the optional columns:
Column E: Student’s username
Column F: Student’s password
How to create new classes using a spreadsheet of student details
These instructions will explain how to create a new class or classes by uploading a spreadsheet of student details. These instructions can also be used to modify your students’ login details.
The following instructions show how to upload the spreadsheet:
Click on ‘Settings’ at the top of the teacher dashboard
Click ‘Manage’ in the ‘Manage students’ box
Click ‘Upload student data’ near the top right of the page
You can either paste the data (‘Paste Students’) or upload a spreadsheet (‘Import Students’).
If you select ‘Paste Students’ you will need to paste the data from the spreadsheet into the box, separating each field with a comma. The remaining steps will be the same as if you were uploading the spreadsheet.
If you select ‘Import Students’ you will need to select a file to upload from your computer. To confirm the file click ‘Open’ after you have selected it from your computer
After selecting your spreadsheet you need to confirm what you would like to do with the data.
To create or rearrange classes, choose the second option.
To change student login details and create or rearrange classes, choose the third option.
Click ‘Next’
If applicable, the next page will query if you wish to remove any students’ accounts. If you are uncertain, click ‘No, do not delete any students’.
You can always remove students at a later point if they leave the school.
Click ‘Next’
On this page you will be asked to confirm the data in each column. Click on the drop-down bar at the top of each column to confirm which data type is shown in each field.
Click ‘Next’.
Note: If you see any error messages during the upload, you can find more information here
*Optional* If there is more than one student with the same name in the spreadsheet or system, you need to confirm which account in the system the student belongs to (if any).
Example: Two students have been uploaded with the same name from a spreadsheet. The system queries which existing account belongs to the student.
If both students are new, select ‘New student’ from the drop-down list for both of them.
If one of the students has an existing account, select the matching account from the drop-down list.
Click ‘Next’
You will now be shown a preview of the upload, which accounts will be created, and which accounts will be changed.
Click ‘Save students’ if everything looks correct
The final page will show you a summary of how many accounts have been created and how many existing students were moved to a new class.
Click ‘Done’. Your classes have now been created/reorganized