As I do every year, I am taking this week to relax, recharge, and ski with friends. While I’m away I will be re-running the most popular posts of the year. This was one of the most popular posts in February, 2015.
This afternoon I was asked if I could put together a list of my favorite Google Docs, Sheets, and Forms Add-ons. In the past I had put together lists of Sheets scripts, but most of those lists are outdated as Add-ons have mostly replaced scripts. Here’s my updated list of my favorite Google Docs, Sheets and Forms Add-ons.
Google Docs Add-ons:
The Tag Cloud Generator Add-on will create a word cloud in the right-hand margin of any of your Google Documents that contain more than one hundred words.
One of the most useful Add-ons for Google Documents is the EasyBib Bibliography Creator. The EasyBib Bibliography Creator makes it easy to properly cite resources and format a bibliography in APA, MLA, or Chicago style.
Knowing the right keyboard shortcuts to type the accents and characters is one of the challenges that students face when learning and trying to type in a new language. Easy Accents is a Google Docs Add-on that can eliminate that challenge. Easy Accents provides a virtual keyboard that enables students to quickly insert the letters and accents found in French, German, Spanish, Māori, and Sámi.
g(Math) is an Add-on for Google Docs that enables you to easily insert graphs and equations into your Google Documents. The Add-on opens in the right side of your document and from there you can insert the parameters of your graph and or generate equations.
Google Sheets Add-ons:
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.
Save As Doc is a free Google Spreadsheets Add-on that enables you to select a series of adjacent cells and turn them into an easy to read Google Document. The Save As Doc Add-on takes just a minute to install. Once installed select the Add-on from your “Add-on’s” drop-down menu and click “start.” After clicking “start” you can choose a set of cells or all cells to be converted into a Google Document. The document will appear in your Google Drive dashboard (it might take a minute or two to appear if you have selected a large set of cells) where you can then view it, edit it, or download it as a PDF.
Flubaroo is a popular Google Sheets Add-on that enables teachers to grade all at once all of their students’ responses to a quiz created in Google Forms. Flubaroo offers automatic grading and emailing of grades. 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.
Google Forms Add-ons:
FormLimiter is one of my favorite Forms Add-ons. FormLimiter allows you to set a time for a form to automatically stop accepting responses. You can also use FormLimiter to set a limit on number of responses a form will accept.
g(Math) is a also available as a Google Forms Add-on that allows you to insert graphs and mathematical expressions into your Google Forms. To insert graphs and equations into your Form select g(Math) from your Add-ons menu and follow the directions that pop-up on the right side of the screen.
Form Notifications allows you to create triggers for emails to be sent to you when submissions are made through one of your forms. You can set the Add-on to send you an email alert after a specified number of responses are received or after every submission. The Add-on also allows you to have an email sent to Form respondents after they have completed your Form.