Google Sheets Add-ons make it possible for those of us who would otherwise struggle with spreadsheet scripting to get a lot of utility out of Google Sheets. From things like sending personalized emails to a list of students to creating rubrics to tracking attendance, the following five Google Sheets Add-ons can streamline processes for almost every teacher.
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. I have a complete set of Flubaroo tutorial videos embedded below.
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.
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.
Attendance Sorter is a Google Sheets Add-on that will take your messy attendance data collected through Google Forms and make it easy to sort in meaningful ways. The video provides a short overview of what Attendance Sorter can do for you.
Flippity provides teachers with handy Google Sheets templates for creating things like quiz games, audio flashcards, and progress trackers. Flippity’s Google Sheets Add-on that makes all of their templates available with just a couple of clicks in any of your Google Sheets. In the video embedded below I demonstrate how to install and use Flippity’s Google Sheets Add-on.