Note: If you are a Schoolzilla Enterprise customer with your own data warehouse, roster information added via the method below will be overwritten by data from your SIS during the nightly refresh. Please contact Support for more information.
At Schoolzilla, we are able to personalize reports for teachers (show teachers reports that just include their students) based on roster data you provide via the Schoolzilla Roster Template.
Creating your Teacher Roster File
You can download the Roster Template here: Schoolzilla_RosterTemplate.xls
** IMPORTANT ** Do not remove or rename any columns or tabs from this file! Removing columns (even if unused) will cause an upload to fail.
In the Roster Template you will see an "Instructions" tab for how to use the template:
On the "Data" tab, we recommend completing:
- Teacher Email (required)
- State Student ID AND System Student ID (required) – if you don’t know the State Student ID for a student, please put their System Student ID in this column instead
- Teacher First Name (highly recommended)
- Teacher Last Name (highly recommended)
There should be one row per student-teacher combination.
The "Examples" tab gives an example of the types of data that would be appropriate for each column.
Uploading your Teacher Roster File
Clicking "edit connection information" will load the My Data form where you can submit your roster file.
Select .csv or .xls as the file format depending on how your file is saved on your machine.
Click "Choose File" and find your completed roster file and "upload". Permissions for the users in the roster file will be updated after your nightly refresh.
Note: You can delete rosters from this UI, but, if the roster you delete is our sole source of information about those teachers and students (i.e., they weren't previously added via our automatic SIS sync or via another roster) doing so will permanently delete the record of those students and staff members from our web app, which could orphan the records.