#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.

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