You can create new classes and rearrange existing classes at the same time by uploading a spreadsheet. These instructions can also be used to change students' login details.
Note: It is important to ensure that the names in your spreadsheet exactly match the names already in the system for any existing students. Otherwise, the system will take these as separate user accounts and create a duplicate account for the student.
Prepare your spreadsheet for upload
- The spreadsheet must include at least four columns:
- 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
- In addition to the information above, you can include additional columns to modify your students' login details or to create custom usernames and passwords. Follow the same structure as for columns A-D, but add the optional columns:
- Column E: Student's username
- Column F: Student's password
Note: Do not include any headings in the spreadsheet, Ensure that the first row of the spreadsheet contains student data you wish to upload.
How to create, rearrange, and/or edit classes using your 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 date ('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. The remaining steps will be 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.
- After pasting or 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 there are students in your school who have never signed in and whose accounts were created over six months ago, the next page will ask if you wish to remove those accounts. If you are uncertain, click 'No, do not delete any students'. Click 'next'
- On this page, you will be asked to confirm the data in each column. Click on the dropdown menu at the top of each column to confirm which date type is shown in each field. Click 'next'
- 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 asks which existing account belongs to the student.
If both students are new, select ‘new student’ from the dropdown menu for both of them. If one of the students has an existing account, select the matching account from the dropdown list.
- Example: Two students have been uploaded with the same name from a spreadsheet. The system asks which existing account belongs to the student.
- Click ‘next’
- You will now be shown a preview of the upload so you can see which accounts will be created and which accounts will be changed. If everything looks correct, click 'save students'
- 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'.
Tip: If your spreadsheet has a large number of students/classes, we recommend uploading only a few classes at a time