Flubaroo to Grade a Google Form

#edtech #web20 #edchat #google  #elearning

A few weeks ago,  we posted about using Google Forms.  Google Forms are a great way to collect information without the need for paper.  Teachers can use Google Forms to give students formative or summative assessments.  The benefit is that the information is automatically organized into a spreadsheet.  Another added benefit to Google Forms are “Scripts”.  One such script, called Flubaroo, will automatically grade a spreadsheet form for you with only a few simple inputs.

To get Flubaroo, head to a Google Form spreadsheet that’s open and navigate to Insert>Script.

insert script

Next, you’ll want to do a search for “Flubaroo” in the search bar and click “install”

searchflubarooOnce installed, you will notice that “Flubaroo” is now a menu item.

flubmenu

For Flubaroo to work, it needs a reference row or a “key”.  This can be one of the    rows in your spreadsheet.  Teachers will often take their own test so that it populates the first row of the test.  From that point forward, they have an easy way to grade the test/quiz.

After the quiz is graded, there will be a new tab at the bottom (similar to Microsoft Excel) called “Grades”.  Flubaroo automatically creates a spreadsheet with total correct/incorrect, % out of 100, and many other useful pieces of information.  If the teacher has the student input their email address as one of the row items, the teacher can immediately send the student their grade and feedback.

With a little work up front, using Google Forms with Flubaroo can save a lot of time for teachers.

Be sure to check out www.flubaroo.com for more information.