Flubaroo

Google Forms are a special extension of Google Sheets. With Forms, users can create a form document to publish to the web that will accept data and populate a spreadsheet behind the scenes. Teachers can easily use a Google Form to create a a quiz.

Flubaroo is a Google Sheet Add-on which helps you quickly grade and analyze online assignments and assessments, as well as email scores to students.

Quick Steps for Creating Graded Quizzes with Google Forms & Flubaroo

Step 1. Use Google Forms to create a quiz

Step 2. Go back to the live form and create an answer key

Peggy's Hint: Enter the following for your answers,

  • First Name: The
  • Last Name: Answers
  • Email Address: your email address

Step 3. Share your form with your students

Step 4. You will need the Flubaroo Add-on installed in your Google Sheets

Step 5. Grade Assignment

Grading Step 1 - 1-5 points, Identify students and skip grading

Grading Step 2 - Which submission is correct?

Step 6. Email Students their Grades

Go back to the add-on, Flubaroo and View the report

Activity:

1. Make a copy of this spreadsheet provided by the Flubaroo website: https://docs.google.com/spreadsheets/d/1MTCEyaz6ycwtn4-LsUilIioOWB_JuHRzP_XUWAeF4Jk/edit#gid=0

2. Install the Flubaroo Add-on

3. Grade the results using Flubaroo