Flubaroo: A Method to Use Google Forms for Assessment

Over the last few years, I have seen a more widespread use of Google Forms occur. It seems to be the go to method for professional development evaluations. I have also incorporated its use in my classroom for exit tickets on occasion. I have just under 60 students and have found the task of individually scoring students using Google Forms to be a daunting one when percentage scores are needed. In the past, I manually tallied student responses or used the summary of responses feature to get an overall picture of classroom understanding. To individually score 50+ assessments was time-consuming, especially if more than five assessment questions were used.

The grid below shows typical data for a four question assessment taken by 10 students.

spreadsheet of 10 student responses generated by Google Forms
Spreadsheet of ten student responses generated by Google Forms
If I were to use Google Forms to assess more students, with more questions, the task of analyzing the data could become much more tedious and overwhelming. Due to that limitation, I did not use Google Forms for assessment very often this year.

Tonight in class, I learned of a much easier method of gathering data using Google Forms and the prospect of implementing it is promising.  I was so impressed by the Google add-on, Flubaroo, that I feel it warrants sharing with all of you. Flubaroo allows you to score assessments and mine data from the responses with ease.  It allows the program to “grade” for you! Please watch the short video below (created by Lisa Stamper) for a tutorial on how you can use Flubaroo for your own data needs.

When I applied the Flubaroo add-on to the data from the spreadsheet above I was pleasantly surprised by the ease of use.

After downloading the add-on as illustrated in the video, I clicked on “Flubaroo” in the pull down menu and chose my grading options.

Selecting the point values in the Flubaroo window
Selecting my grading option
Then, I chose the answer key I created by completing the Google Form myself and putting in all the correct answers (I called it “Teacher Answer Key.”

Choosing my answer key from the menu of responses
Choosing my answer key
Finally, I clicked on the “grades” tab at the bottom of the sheet and received my students’ scores!

Spreadsheet with percentile scores generated using the Flubaroo add-on for Google Forms
Scores generated by the Flubaroo add-on for Google Forms
Goodbye tedious individual grading, hello efficiency! Within 5 minutes of finishing the assessment, I can have student scores at my fingertips. Anything that makes our jobs easier is worth taking a look at. While this method will not work for student essay responses, there is an option not to score those portions of assessments using Flubaroo (so that they can be individually evaluated). Still, the benefits of using Flubaroo, in my opinion, outweigh the drawbacks. Try it for yourself, and share your opinions. If you come up with an innovative way to use Flubaroo, be sure to share that too!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s