Rostering with Reading Assistant using Google Sheet Manual Rostering

Owned by Forrest Rose
Sep 10, 2024
5 min read
EPS Reading Assistant_Logo_Primary (1).png
Reading Assistant Homepage

My District doesn't use Clever or Classlink. Is there another option? Yes! Reading Assistant now has a manual rostering option that uses a private Google Sheet specific to your district. This article will outline the steps and directions for using this process. We do not recommend this option for large Districts.

 

Once your district/school has purchased Reading Assistant, you’ll get a reach out from your CSM for a leader planning meeting. In this meeting, they’ll review your goals and desires and how best to implement Reading Assistant for your team and students. Important information will also be gathered in this meeting for rostering, such as who your rostering/IT contact is, the schools you will be using, etc. 

With this information, your CSM will open a case to request that our rostering team roster your district. If necessary, we’ll meet with you to review the requirements, questions, and data being shared. 

Manual Rostering Specific Information

  • Each customer who uses this method will have their own Google sheet to enter information. Only Roster and Implementation leads will have access to this document outside of the Reading Assistant team. You can share the spreadsheet with others in the District at your leisure.

  • Each customer will also have their login URL, which can be bookmarked and will be linked in their Google Sheet.

  • All Fields are required except for LASID (You can enter any unique ID you'd like in this field if needed. Ex, Student ID

  • Usernames must be unique per user within your District and cannot contain accent characters.

  • School names and Class Names must be unique.

  • Any column highlighted in Blue should NOT be filled in. This is for Reading Assistant use only.

  • Usernames & Passwords are case-sensitive.

 

Manual Direct: We will provide a Google sheet shared only with your Rostering and District leaders. This is specific to your district and something your team will need to complete. The spreadsheet will include directions and tabs for you to fill out. You’ll need to let us know when you’ve completed your Google sheet, and the Reading Assistant rostering team will make the connection. You will also receive a specific login URL for your District.

 

Below is a view of those directions for each tab you must fill out. The Reading Assistant team will help walk you through this process and be available for questions.

 

 

image-20240910-183620.png

 

 Schools

On the Schools tab, please list all the schools you want to show in Reading Assistant. Ignore the "PID" column; this is a Reading Assistant-only column.

 

 

 

District Administrator

District admins will have access to administrative tools for all schools and classes within Reading Assistant. Enter in First name, Last name, Username, and Password.

 

 

 

School Administrator

School Admins will have access to admin tools and classes for their assigned school/s. 

School name determines which school each school admin belongs to. **IF admins need access to multiple schools, please list them on multiple lines with the school name on each line they need access to. Fill in School name, First name, Last Name, Username, and Password.

 

 

 

Classes

List each Class name and the school it belongs to. **Reminder Class Names must be unique throughout the whole District. Schools cannot have the same class names.

 

 

 

Teachers

School name determines which school each belongs to. **IF teachers need access to multiple schools please list them on multiple lines with the school name on each line they need access to.

School name, First name, Last Name, Username, and Password must be filled in.

 

 

 

Students

School name determines which school each student belongs to.

School name, First name, Last Name, Username, Password and Grade must be filled in.

 

 

 

Teacher Classes

Select the Class Name, and Teacher that needs to be assigned to that class. **IF there are multiple teachers for a class, list the class on multiple lines with each teacher.

 

 

 

Student Classes

Select the Class Name, and student that needs to be assigned to that class.

 

 

 

Once your spreadsheet is completed, let your rostering partner with Reading Assistant know. We'll validate the data looks accurate and nothing is missing, then make the connection and URL. This can take up to 3 business days. Once your rostering setup is complete, you'll receive your District specific URL.

 

If at any point you need to update your rosters, such as adding or removing users, simply come into your Google Sheet and make the necessary updates. It will sync overnight and you'll see the changes the next day in Reading Assistant. 

 

This is what your login site will look like

 

Support