We all have a roster of students now what can we do with that list of students? My new Add-on Roster Extras sponsored by Schoolytics. This Add-on for Google Sheets collects no user data and no PII. Use with any Google Sheets spreadsheet. Turn your roster into a Google Slides or create custom Google Docs reports per student.
Spreadsheet With Your Roster
What you need is a spreadsheet with your student roster in column B. This will work with any Google Sheets spreadsheet, however you can use your free teacher account at Schoolytics to export your roster to Google Sheets.
Extensions Menu
The Add-on can be located in any Google Sheets by going to the Extensions menu. If you have already installed Roster Extras by Schoolytics you will be able to find it and show the sidebar.
Format Sheet
The first step when you have a spreadsheet is to freeze the first row. While this is relatively simple in a Google Sheets spreadsheet, if you know how, why not automate it! Show the sidebar for “Roster Extras by Schoolytics” and select “Format Sheet.” This will freeze the first row and freeze the first 2 columns.
Roster to Slides
This is a very popular feature! Taking your roster and assigning a slide to each student in the same Google Slides is Roster to Slides. (A favorite of Jennifer Scott, the creator of Slides Yearbook.)
If your roster is in column B and click on “Create Slides” in the sidebar, a new Google Slides will be created. A slide per student will be added. The students name will be automatically added to the slide.
Notice in this example that each slide has the students name in the bottom left hand corner. I have changed the background of slides, using Canva, to make them prettier.
Randomize Student List
Call on students randomly with Roster Extras! Click the buttons in the sidebar to randomize the roster. Virtual popsicle sticks!! Choose to sort randomly, sort alphabetically, or if you have used the checkboxes after calling on students select “Randomize Checked Roster.”
Send to Docs
I think this feature is very exciting. The Send to Docs feature in Roster Extras allows you to create custom reports per student.
Add your own columns.
In the blank columns, starting with column D, create your own column headers. What information do you want to track about each student? Perhaps attendance, student behavior, mastery of learning objectives, parent contacts… whatever you want!
Custom Reports
Click on “Create Docs” in the sidebar to create a Google Doc per student. If email addresses are in column C the doc is automatically shared with the student. Students have view access of their document. Links to the newly created documents are in the spreadsheet. The links are live hyperlinks.
The documents are created in Google Drive. They are not created in a folder. Manually organize the newly created documents in your Google Drive.
