Wednesday, March 6, 2019

My Five Favorite Google Sheets Add-ons

Last week and through the beginning of this week I have been featuring my favorite Google Docs, Slides, and Forms add-ons. Today, it is time to share my favorite Google Sheets add-ons. These aren't necessarily the most popular add-ons, but they are the ones that I think of first whenever I'm asked for recommendations for Sheets add-ons to try.

Flippity provides teachers with twenty 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.

Flubaroo is not as popular as it once was, but it is still a great Google Sheets add-on. Flubaroo you grade all at once all of your students' responses to a quiz created in Google Forms. You're probably saying to yourself, "Google Forms does that too." You're right Google Forms does do that, but Flubaroo lets you do more than just grade quizzes. You can use it do things to print score sheets for your students, give students digital badges, and give partial credit for answers. Take a look at this video for an overview of ten things you can do with Flubaroo.

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.

If you're the person in charge of scheduling conference room, computer lab, library, or science lab use, Lab Scheduler is the Add-on for you. This little Add-on will give your Google Sheet an easy-to-follow template for coordinating room use without the need to make a zillion entries in a Google Calendar. Share the Sheet with your staff as view-only so they can see who has reserved a lab.