EdTech, education

8 Google Sheets Add-Ons For Educators

Below is a collection of Google Sheets add-ons that I believe every teacher and educator should at least be aware of. These are tools that provide you with tons of functionality hacks to enhance your productivity and facilitate your workflow. Some of the things you can do with these add-ons include: creating forms of various types (e.g., quizzes, assignments, surveys, etc), generate PDFs and documents from Sheets’ data, grade and analyze digital assignments, create a class website from spreadsheets, and many more.

FormsCreator

An easy way to generate Google Forms to use for various educational purposes including for surveys, quizzes, assignments, feedback, etc.

Doctopus

Enhances teachers workflow by providing teachers with the ability to “mass-copy, share, monitor student progress, and manage grading and feedback for student projects in Google Drive”.

Autocrat

“Flexible, easy to use document merge tool that creates PDF or shared Documents from spreadsheet data”.

Wikipedia and Wikidata tools

This add-on is great for mining data for your classes. You can use Wikipedia and Wikidata tools to do a ton of information gathering, instantly. The add-on provides you with a host of custom lookups such as WIKITRANSLATE and WIKIGEOCOORDINATES. These functions pull live data straight from Wikipedia into a spreadsheet, enabling teachers to compile an up-to-date and accurate database of facts.

Flubaroo

A Google Spreadsheets Add-on that helps educators quickly grade and analyze online assignments and assessments, as well as share scores with students!”

Sheet2Site

Allows you to create a website for your class using Google Sheets.

Form Publisher

Allows you to generate documents (e.g., Docs, PDF, Sheets, Slides, Word, Excel, and PowerPoint) from data on Google Forms and Google Sheets.

Flippity

Originally, Flippity was designed to help you create online flashcards from Google Sheets, but the range of templates now includes everything from quiz shows and crossword puzzles to spelling and typing tests. The add-on has recently been discontinued but all the same great templates are available directly via the Flippity website.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s