Flubaroo: Automated Google Docs Self-Grading Quizzes

A truly remarkable teaching tool is one that can collect information to evaluate student performance and provide students and teachers with immediate feedback for modification, reteaching and challenge.

Until now, the best tool I’ve shared has been Using Google Docs Self-Grading Quiz as an Exit Ticket. This post has claimed the position of runner up in popularity of posts on this blog because many teachers recognize the need for quick and efficient ways to collect and use data to maximize and fine-tune instruction.

Great news! 

Flubaroo is a free and user friendly script that automates the steps of manually creating the self-grading quiz and adds additional functionality to the process. 

Flubaroo is easy to set up, it’s reliable and it’s far more efficient than the manual method I used to use and support.

What is Flubaroo?

Flubaroo is a free script you can easily add to the Google Docs Form to help you quickly grade multiple-choice or fill-in-blank assignments. Just follow the steps in the user’s guide to install Flubaroo and you will get access to a Flubaroo menu. This menu replaces the need to add functions manually to columns in a spreadsheet and it automates email results.

Watch Demo

Start Using Flubaroo

Flubaroo was designed by an awesome teacher. There is a complete, illustrated walk through to help users get up and running with the tool in a matter of minutes. It is very well done! 

Visit the Flubaroo website and follow the steps in the user’s guide.

Benefits of Use

Provide Immediate Feedback
Flubaroo will email results to students. For students without email you can easily publish the GoogleDocs Spreadsheet results and take advantage of student codes or pen names in place of actual names to protect student identities.

Modify and Fine-Tune Instruction
Quickly gauge student understanding and adjust instruction to provide for the reteaching, support and challenge indicated by the results of the quiz. Use the time you saved not grading to fine tune your instruction.

Explore Additional Ways to Use the Google Docs Form

If you haven’t used a Google Docs Form with students yet, this experience might open the doors to a variety of additional uses for collecting information from students via an exit ticket to provide students with opportunities to voice their opinions, express concerns, reflect and collaborate in the 24/7 classroom.

Use GoogleDocs Self-Grading Quiz as an Exit Ticket

Update 3.3.13:

Try Flubaroo to automate and add functionality to the GoogleDocs Self-Grading Quiz.

View new post on this blog


The GoogleDocs Form is an efficient way for teachers to collect small pieces of information because it automatically displays the information in a spreadsheet. Teachers can add formulas to those spreadsheets to create  multiple-choice quizzes that grade themselves. Since a form can be linked or embedded into a website, wiki or blog, students do not need email accounts to take a quiz. The form works well on any portable computing device or full-blown computer which makes it perfect for use as an Exit Ticket at the end of a lesson. One simple 3-5 question Exit Ticket Quiz has at least three great uses.

  1. Provide students with immediate feedback to increase motivationGive students a quick self-grading quiz at the end of a lesson, spend less than 5 minutes collecting the grades for an unlimited number of students, then publish the spreadsheet of results. Teach students how to use The Find Tool (control + f) to quickly find their score and significantly raise the stakes to increase student motivation. Please note: To avoid public humiliation and hard feelings I suggest you require students to sign in with some sort of unique identifier, in addition to their name. Before you publish the results, always remember to hide the name column.
  2. Gauge student understanding and the effectiveness of your lesson                 Results collected using the same self-grading quiz can be used for planning,reteaching, modifying and providing students with enrichment from both a big-picture and a detailed point of view. To look at the big picture, choose Form > Show Summary of Responses from the menu bar and view the results in the form of a graph for each question. To examine specific student results, sort the spreadsheet by question to identify the students who have mastered each question. If you are using video tutorials or digital resources to reteach, you can even link those resources right to each question on the spreadsheet to provide students with easy access to support.
  3. Give students a chance to voice their opinions, concerns, and questions. Although an open-ended question won’t grade itself, you can provide an optional “paragraph” style question l at the end of the Exit Ticket to give students a voice and opportunity to communicate with you about their learning. Since the self-grading quiz has provided you with freedom from grading papers, you can use the extra time to listen to collect personal feedback and respond appropriately. Copy and paste student questions into a follow up document and make note of repeated questions to identify common concerns.
Take a closer look:

Take Sample Quiz  
View Sample Results 
View Summary of Responses
Learn how:
If you don’t know how to create a Google Doc Self-Grading Quiz, you can learn how by using this awesome video tutorial, created by jspevack. A good tip for this type of learning is to set up your screen with two windows, side-by-side, and actually try to create the quiz as you go through the tutorial. Remember to use the pause button to learn at your own pace.

Tutorial: Create a Google Docs Self-Grading Quiz