I often create short quiz for people to take before and after my workshop. I want to be able to quickly give them their score. Flubaroo is a script that runs on Google spreadsheet that simplifies the task of auto marking multiple choice quiz.
Here are the steps that will help you create your own Flubaroo powered quiz.
Step 1: Create a Google form
Create a Google Form. You can do it from docs.google.com

Step 2: Create the individual items in your form
Your form will have some identifying fields. Name, Email etc. You will also have the questions that you want to ask. Multiple choice works best.
Zoom
Step 3: Add multiple choice questions
You can keep adding more questions via the “Add Item” button above.

Step 4: Find the URL for your quiz.
You can find the Quiz URL at the bottom. Click on this URL to see the live quiz.
Zoom
Step 5: Indicate the correct answers
We will fill in the correct answers here and submit.

Step 6: Attach a script
Go back to your form and select Script gallery from the Tools option on top.

Step 7: Install Flubaroo
Search for Flubaroo. Once you find Flubaroo, click on Install.
Zoom
Step 8: Make sure that Flubaroo is installed
Once installed Flubaroo shows up on the menu
Zoom
Step 9: Send the quiz to your students
Now you can give the URL of your quiz to your students. My suggestion is to use Bit.ly or Goo.gl to shorten the URL of the quiz. Here is a screen shot of a student taking the test. As they keep submitting the test, their reponse populates your spreadsheet.
Zoom
Step 10: Permit Flubaroo to run
A permission screen will pop up. Give it permission to run and click on the OK button at the bottom.
Zoom
Step 11: Run Flubaroo
Click on the Flubaroo menu again.

Step 12: Grading options
This time Flubaroo menu will open up. Select the grading option. On this screen you will specify which fields contain identifying informaion and which fields are graded.

Step 13: Indicate the correct answer set
Also, you select the response that contains all the right answers. It is usually the first response because that is where we posted the correct answers. Flubaroo will compare this set with other resposes and grade the respondents according to this set.
Zoom
Step 14: Email grades to students
Flubaroo can also email the students with their scores.

Step 15: Indicate the email field and email options
Just specifiy wich field contains the email address.

Step 16: Congrats. Flubaroo is setup.
This is how the email looks like to your students.
