Google Forms Tip D - Forms Add Ons

With the 3 previous tips under your belt you are have the know-how to create effective forms in your classroom.  But, with the power of Add Ons for forms and sheets you can do some amazing things. 

Add-ons are scripts or little programs that people have written to add functionality to either a Form or a Spreadsheet. So an add-on to a form would change how the form behaves based on data, etc. An add-on that is added to a sheet will manipulate the data once it has already been collected or work with a form. This is how you would create a self grading test. Tomorrow's tip will be a complete walk through of how to create a Self grading test. It will be easier than you think.

It is very easy to add and Add on to a sheet or form. Just note that when you do a search looking for an add on, if in forms only form Add Ons show up and in sheets, only sheets.The video below will show you how to add an add-on and where to find them.

How to add an Add On to a Google Form or Sheet (very short)

 Look below for a listing of some of the more popular add-ons for Google Forms and Google Sheets that teachers use. Most have websites that give you instructions on how to use them with Google Docs. If not, use the name of the add on in a Youtube search and I bet you will find something that you can use.


Add-ons for Forms

FormLimiter - automatically sets Google Forms to stop accepting responses after a maximum number of responses, at a specific date and time, or when a spreadsheet cell contains a specified value.Great for time-bound assignments, event registrations with limited seats, or other first-come, first-served signup scenarios.

gMath - Create graphs (including plotting points), statistical displays, and write complex math directly in your Form! Create graphs and complex math directly in the sidebar and insert them as Form items. You can also deploy a Form to allow responders to craft responses using g(Math) tools! Works in Docs as Well.

Form Notifications - This add-on allows users to create and configure email notifications that are sent when a Form receives submissions. Users can have emails sent to the creator of the Form and/or send short, customized reply emails to the Form submitter.

Choice Eliminator -  This will eliminate options from a multiple-choice, list, or checkbox type of question. Great for signing up for time slots or having students choose topics without doubling up such as for Research papers. This one is very cool.

Add On for Sheets

Self Grading Test - Well, that is not the name - I will share that in Tomorrow'sTip with a complete walk through from start to finish. Hey, it is ratings week!

AutoCrat - he autoCrat Add-on for Google Sheets enables you to automate the creation of personalized documents and emails from the cloud. autoCrat is a multi-purpose document merge tool that allows you to take any row-based spreadsheet data and create, save, attach to email, and share templated documents.  Use <<Your own tags>> to build a template in a Google Doc or Spreadsheet, than let autoCrat mass-generate these docs, with tags and collaborators populated from data in your Sheet!

Copydown - The copyDown Add-on makes it possible to automate formula calculations in the same spreadsheet rows as your Google Form submissions.  No more manually copying and pasting or writing ugly arrayformulas... Great for tasks like looking up an email address in another sheet based on a name field in your form, or evaluating correct and incorrect student answers on Forms-based assessments and generating personalized feedback

formMule - formMule sends targeted, personalized emails from a Google Sheet.  Run as either a manual email merge or -- more powerfully -- as a triggered merge that runs automatically on form submit. Just think of it as mail merge.