While I’m not a big fan of multiple-choice assessment, it can still serve a function in quick, low-level, formative assessment and sadly some teachers are still required to use it.
I previously wrote about using Google Forms for online assessment. Now I’ll walk you through the easiest way to grade student responses in less than a minute with Flubaroo. Flubaroo is a free add-on for Google Sheets. You can download it at http://www.flubaroo.com/.
Grading with Flubaroo
After you have downloaded Flubaroo, and students have completed an assessment Google Forms, you’ll need to view their responses in Google Sheets. It sounds like a lot of steps, but it’s really as simple as the two shown below.
Once in Google Sheets, enable Flubaroo
Grade the Assignment
Select Question Options and Points
Choose an Answer Key
Analyze the Results
View the average score per student and per question. Commonly missed questions are highlighted in orange.
Teachers are given the option to email grades with or without answer keys, and to include an optional message.
Students Receive Grades via Email
More Than Multiple Choice
Flubaroo has a few features that enable it to be used for more than just multiple-choice questions. One of my favorites is the ability to accept numerical answers that fall within a range (i.e. 20-24). You can also choose to grade questions manually (i.e. short-answer, open-ended) and assign any point value you would like.
Flubaroo is a great tool to make grading easier for teachers using Google Forms for assessment.