Home » Google » Roster Extras Add-on by Alice Keeler

Roster Extras Add-on by Alice Keeler

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.

Export Roster from Schoolytics

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.

Extensions menu in Google Sheets. Locate Roster Extras by Schoolytics

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.”

Randomize student list buttons. Randomize roster. Sort alpha. 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!

Send To docs menu in the sidebar. Attendance columns added for each student.

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.

Google Document created for Lupe Levenson. Contains her name. The column header and the data about her that was on the spreadsheet.

The documents are created in Google Drive. They are not created in a folder. Manually organize the newly created documents in your Google Drive.

Turn Your Docs into Forms and Slides

How to turn a Google Doc into a Form. Use Document Outline by Schoolytics Add-on to quickly turn your Google Docs into Forms, Slides, or Sheets.

Canva Jamboard Background

Try designing your backgrounds for Google Jamboard in Canva. Canva Jamboard Backgrounds are easy and make your Jams really Jam!

9 Google Forms Formative Assessment Tips

Want to use Google Forms as a formative assessment quiz? Check out these 9 tips. Google Forms Formative Assessment

Google Forms: STOP Students From Going to Previous Section

In Google Forms with Sections, how do you stop a student from going to a previous section they already completed?

How to Use Quiz Helper for Google Forms™

Use Google Forms as a quiz. Get your settings right. Provide students feedback in Google Docs. Allow students to finish their quiz later.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.