The 5 Best Google Forms & Sheets Add-ons for Teachers

11/5/2015 12:10:00 AM
  
Add-ons. The little extra that makes Google Apps shine. Add-ons provide the little bonus that you often need to really take advantage of the Google Apps for Education platform for free, and with purpose and efficiency.
While most Google Apps have add-ons, for my money sheets and forms have those game changers that can really impact workflow, make your jobs more efficient, and transform your work. Below, find some of my favorite add-ons with brief explanations and applications. If you have one to add to the list, reach out on Twitter or in the comments!
Most Google Apps have an Add-ons menu on the top toolbar. Click Add-ons → Get Add-ons to start exploring!

The Best of the Best


Choice Eliminator, as the title suggests, removes an option from a multiple choice question after it has been selected, depending on your preferences. Each question can be customized depending on your intended quantity of responses.

I use Choice Eliminator to have students select groups and topics for projects. I share the responses sheet with them, and the add-on is used to keep all of that management seamless and electronic.



Form Mule is a mail merge utility. It combines the data across the rows of a spreadsheet into a template you create, and e-mails it to whoever you decide.
 
Use it to send form results to a user, e-mail students comments from a forms rubric, or to notify yourself when students submit form or sign up for appointments. Find much more on Form Mule on the first episode of the Schoencast here.



Autocrat is a document merge tool. It works similarly to Form Mule, in that it combines and merges data from a sheet or form. However, the power of Autocrat is that is can create .pdf or Google Docs that can be attached to an e-mail, fitting a .doc template you create.
 
Use Autocrat to send PD certificates or quiz results when participants complete a form. Many conferences do this to automate the certificate process. Or use it to merge those ugly rows of data into a nice, clean document from a student survey that you might not have really looked at since the first week of school. One day, I’ll write about my self-paced, automated quizzes that are based on Autocrat.



Copy Down copies formulas in a Google Sheet down a column.

Use Copy Down to automatically apply custom formulas to form results. For example, create a basic sum formula to total grades from a form quiz. Then, use Copy Down to fill that data when the form is submitted each time. Combine it with Form Mule to automate the return of the feedback. Since each new Google Form response actually inserts a new row, Copy Down is essential if you plan to use any formulas and accept new responses.



Flubaroo automatically grades a Google Form multiple choice quiz.

Use it to grade quizzes (duh!). The add-on compares your results of a submission as the key with student submissions, grades them, and provides some basic analytics on the data. It highlights problematic questions, low scoring questions, and can even e-mail scores and /or answer keys to students. Additionally, Flubaroo can be set to run automatically upon submission, and can now even be used for scoring open ended responses, too.

Bonus Round: 

Doctopus is an incredible Google Sheets add-on used to distribute templates. When paired with the extension Goobric, it’s incredibly useful for using rubrics to grade writing through Google Drive and Classroom. It deserves it’s own post, though, so while it’s incredible, I’ll keep it brief this time.

The More the Merrier

One of the great things about Google Apps is that new updates, products, extensions, and add-ons are coming all the time. The screenshots below show some of the ones I use in addition to my top 5. Number 6-10 could easily be a post on it’s own, too. Explore the Chrome store and make your life easier and teaching better with the power of the Forms and Sheets add-ons.


cross posted at www.aschoenbart.com

Adam Schoenbart is a high school English teacher, Google Education Trainer, and EdD candidate in Educational Leadership. He teaches grades 10-12 in a 1:1 Chromebook classroom at Ossining High School in Westchester County, NY and received the 2014 LHRIC Teacher Pioneer Award for innovative uses of technology that change teaching and learning. Read more at The SchoenBlog and connect on Twitter @MrSchoenbart.

comments powered by Disqus

IO Education Earns Two BESSIE Awards from ComputED Gazette

ATLANTA – April 24, 2017 – IO Education, a market leader i...

Fuel Education Reimagines Credit Recovery Curriculum to Motivate Students to Stay on Course

Designed for the “at-promise” student who needs to earn cr...

myON Named Best Digital and Media Literacy Solution by the Association of American Publishers

The personalized literacy solution was selected as a 2017 REVERE Award...

Schoology Adds New Enhanced Question Types to Assessments

NEW YORK (April 19, 2017) - Education technology is accelerating how w...

A New App for Helping Young Children Learn Mandarin Launches in the U.S.

“Miao Mi” App Features Award-Winning Children’s Prog...

T&L Partner Post
Tweets
Photo GalleriesView All Galleries >
Acer C720-2844 Chromebook

(www.acer.com) The Acer C720-2844 Chromebook model delivers speedy performance, a quick boot time of seven seconds, and a matte anti-glare display tha...

Britannica ImageQuest

(www.britannica.com) Britannica Digital Learning has upgraded ImageQuest, a resource for schools and libraries that provides nearly three million rig...

ClassFlow

(www.classflow.com) Promethean has released ClassFlow, a free, all-in-one, cloud-based teaching tool that lets teachers create and deliver interactive...

Adobe Voice

(www.adobe.com) Adobe has released Adobe Voice, an animated video app for the iPad that lets users create and share video stories. The app incorporate...

DeskBoard

(www.boxlight.com) The BOXLIGHT DeskBoard mobile cart adjusts both height and tilt for the P8 ultra short throw interactive projector on a white surfa...

Core 36M

(www.bretford.com) Bretford has introduced Core 36M, a 36-unit charging cart that is optimized for Chromebooks but which also supports most tablets, l...

Edmentum Sensei

(www.edmentum.com) Edmentum Sensei is a mobile optimized solution that helps administrators visualize and track overall school, teacher, and student p...

HMH Player

(www.hmhco.com) HMH has released HMH Player, a new native app for iOS and Google Chrome that streamlines the learning experience for improved digital ...

Juice Power System

(www.bretford.com) Bretford has unveiled an easy-to-use modular power system with exchangeable power components. The Juice Power System uses unique &#...

LightSail

(www.lightsailed.com) LightSail Education has announced a literacy accelerator that combines books with in-text embedded assessments and real-time dat...

myON

(www.myon.com) myON has expanded its digital library to include a set of literacy tools to further personalize the reading experience for students whi...

Nervanix Clarity

(www.nervanix.com) Nervanix has released Clarity, an application that monitors student attention levels as they study and guides them to revisit conce...

MathBall

(www.robotslab.com) RobotsLAB has introduced MathBall, a smart sensor basketball and tablet system that offers curricula in algebra, pre-calculus, phy...

MobileAsset.EDU

(www.waspbarcode.com) Wasp Barcode’s MobileAsset.EDU solutions include everything administrators need to account for their assets, from software...

OpenEd Assessment Creation Tool

(www.opened.io) OpenEd has announced a free tool that lets teachers easily create assessments with the question types required by Common Core standard...

Panasonic TH-80LFB70U

(www.panasonic.com) Panasonic’s TH-80LFB70U interactive LED display features high-speed, multi-touch, interactive capabilities to promote partic...

penveu interactive display system

(www.penveu.com) The penveu interactive display system is a handheld device that turns projectors and large screen displays into interactive whiteboar...

PresentationPro

(www.califone.com) Califone has updated its PresentationPro speaker. The PA310 readily connects with computers, LCD projectors, mobile devices, intera...

PowerSync+ Mobile Companion App

(www.bretford.com) Bretford Manufacturing, Inc. has announced the availability of the companion app for its PowerSync+ enabled charge and sync produc...

PureCharge Carts and Stations for iPad

(www.bretford.com) Bretford Manufacturing, Inc. has debuted the PureCharge family of iPad and iPad mini charging carts and stations. By offering pre-i...

ProQuest Research Companion

(www.proquest.com) ProQuest’s new information literacy product, Research Companion, offers videos that guide users through the research process,...

Sphere2 & Class Send Student Engagement Software Platform

(www.averusa.com) AVer Information has developed a Student Engagement platform, providing teachers and students with the tools to transmit document ca...

TabChargeCT2

(www.averusa.com) AVer has released the TabChargeCT2 charge cart solution, which can hold up to 40 Chromebooks, iPads, Android or Windows tablets, lap...

VoiceLift with Instant Alert and Emergency Video Monitoring

(www.extron.com) The Instant Alert function of the Extron VoiceLift Microphone, combined with a PoleVault, WallVault, or PlenumVault classroom AV sys...

SMART Board 6065

(www.smarttech.com) The SMART Board 6065 is an ultra HD, 4K interactive flat panel that offers collaborative capabilities while ensuring lessons run s...

Gaggle Unity Partner Program

(www.gaggle.net) The new Gaggle Unity Partner Program provides free data integration services for all educational technology vendors. Through the Gagg...

Waterford Early Learning, Reading, Math & Science

(www.waterford.org) Waterford Early Learning Cloud can be used at home or to supplement lessons in classrooms. It can also be used for individual adap...

NetSupport School

(www.netsupportschool.com) The latest version of NetSupport School allows teachers to monitor and collaborate with any mix of technology. An enhanced ...

Camtasia

(www.techsmith.com/camtasia) TechSmith’s Camtasia gives teachers the tools to record lessons, create videos, and engage their audiences. Educato...

Panasonic 3E

(www.panasonic.com) Intel has teamed up with Panasonic to announce the Panasonic 3E, which uses the Intel Education 2-in-1 reference design. Designed ...