Preparing a Spreadsheet Rostering Template or OneRoster File for Zearn

To set up rostering through the Spreadsheet Rostering Template, districts will receive a CSV roster template from Zearn. This file must be completed before submitting roster information for processing.

Complete the following tabs in the template:

• School
• Classrooms
• Staff
• Students

Ensure that any administrators who need access to Zearn are included in the Staff tab.

If your district previously used Zearn Math School Accounts, you can download current student login information from your Zearn account before completing the template.

Once the template is completed, submit the file to Zearn for processing.

Rostering Staff vs. Staff and Students

When filling out the Spreadsheet Rostering Template, districts will decide whether to roster only staff members, or both staff members and students:

  • Roster staff and students: This option creates new accounts for all staff and students. Any students that had a Zearn Math School Account the previous year will have their progress preserved and their credentials updated based on a match of the SIS ID provided in the previous year’s template.
  • Roster staff only: This option creates new accounts for staff only. Students can use any existing accounts to join the correct classroom using a class code, and staff members can create new student accounts through their Zearn account.

Using OneRoster

Zearn is OneRoster certified. You can submit a OneRoster file instead of completing the Zearn CSV template. The same rostering rules apply: classes should reflect specific math classrooms, grade-level assignments determine initial Digital Lesson placement, and administrators and co-teachers should be included with the correct roles.

Once your file is submitted, Zearn’s Deployment Team will process it and set up your accounts. After initial setup, all ongoing roster changes are made directly in Zearn. Contact support@zearn.org with questions.

Using Google SSO

Zearn supports Google SSO for both staff and student accounts. To allow users to access their Zearn accounts through Google SSO, districts must enter the individual’s Google account email address in the username column of the Spreadsheet Rostering Template.