Thursday, October 8, 2015

My 5 Favorite Google Sheets Add-ons & How to Use Them

The addition of Add-ons to Google Sheets has made it easier than ever before to take advantage of the flexibility of spreadsheets. Even people, like me, who have struggled with spreadsheets in the past can accomplish a lot with the help of Google Sheets Add-ons. The following are my favorite Google Sheets Add-ons.

Flubaroo is a popular Google Sheets Add-on that enables me to grade all at once all of my students' responses to a quiz created in Google Forms. The autograde option in Flubaroo allows you to have students automatically receive their scores after submitting their responses to a quiz you created in Google Forms. The autograde feature will send students an email with their scores and the answer key (you can exclude the answer key). With autograding enabled students do not have to wait for you to run the grading process or wait for you to send emails. You can also print grades from Flubaroo and or save them as a PDF.

Add Reminders is a Google Sheets Add-on that will set-up your spreadsheet so that you simply enter reminder messages and email addresses then specify a date on which you want your reminders sent. The Add Reminders Add-on allows you to send the same reminder to everyone in your email list or you can send individualized reminders to everyone in your email list. Watch the video below to learn how to use the Add Reminders Add-on.

Online Rubric is a Google Spreadsheets Add-on that enables to you create rubrics, enter scores, and email scores to students all from one place. Online Rubric provides very clear instructions for each step of the processes of creating a roster sheet, creating a rubric, and emailing grades to students. The video below provides a demonstration of how to use the Online Rubric Add-on.

Doctopus is a Google Spreadsheet Add-on that can help teachers manage the flow of shared work in in their Google Drive accounts. The basic concept behind the Add-on is to enable teachers to quickly share documents with all of the students on a roster, monitor usage of shared documents, and give students feedback within that roster spreadsheet. When Google launched Google Classroom it seemed that Doctopus might become redundant, but that has not exactly become the case as Justin Brink demonstrates in the videos embedded below.

Lab Scheduler is a neat Google Sheets Add-on that enables you to easily create and maintain a lab or room reservation system for your school. It is designed for schools that use a labeled block schedule (for example, the high school in my district uses "period 1" through "period 8" even though there are only four periods in a given day). Once you have added Lab Scheduler to your Google Spreadsheet it will walk you through the process of creating blocks of time and lab/room space in your spreadsheet. You can set your Lab Scheduler to maintain a preview of as many dates as you like. The preview is what people will see when they want to make a reservation. Share the spreadsheet with your staff and they can reserve a block of time in it.