Many people have talked about using Google Forms in your classroom as a way of assessment. This is especially helpful if you are going for a paperless classroom or you have a 1:1 deployment with i-Pads or mobile computers. The best part of creating your assessments in Google Forms is the ability to have the spreadsheet do all of the work for you. Lets take a look at how to have Flubaroo a script for Google spreadsheets grade your assesments for you!

The first thing we have to do is create our assessment in Google Forms. We do this by logging into our Google Docs account (if you do not have Google apps or a Gmail account you can sign up for one here) and clicking on

“Create New” and then “Form”

Go through and setup your questions. Having troubles setting up the form? You can find a full tutorial here. Now you should have a form that looks similar to this:

Now take the test your self with the correct answers. This is creating your digital “Answer Key”.

Assign your test to your students via email or other means. When you are ready to grade your assessment, open up the spreadsheet in your Google docs account (it will have a green square next to it).

When you open it you will see your answers that you submitted earlier:

In the toolbar click on “Insert” and than click on “Script”

When you click on script you will be presented with a dialog box. On the left hand side click “Education” and than find Flubaroo and click install.

You may get a bright red box warning you that the script is potentially harmful. Feel free to click “Authorize”

You will now notice a new toolbar item for Flubaroo

When you are ready to grade the assignment click “Flubaroo” and than click “Grade Assignment”. Flubaroo will start working and you will see a box show up that allows you to enter weights for the different questions as well as an option to skip certain questions and identify the student if you have a name field.

i.e. Extended response questions that you will go back and grade.

The next screen that shows up will be a place where you can select which responses are the answer key.

Choose the answers that you inserted earlier.

Flubaroo will work some more and you will get a confirmation that everything has been graded. When Flubaroo is complete you will see another sheet has been placed on your workbook called “Grades”. The grades sheet will have all of your students grades as well as the questions they missed.

BUT WAIT THERES MORE!

If you navigate to the top toolbar where Flubaroo was earlier and there is now other features that are available:

If you are a Google Apps school you can *email the grades to the student.

*Note if you want to email grades to students you have to have a place on the form where the student enters their email address.

You also have the option to “Re-grade” the assignment if someone turns it in late or you mess up (we don’t do that right )

The last feature is the ability to see a visual breakdown of the assessment results: