Make Paperless Assessment with Google Forms – Part 2 of 2: Grading with Flubaroo

In part 1 of this post, I showed you how to create a Google Form, import questions from a Google Doc or Word Doc and collect answers. Now it is time to grade your Google Form and give students quick, helpful feedback.

Start by going to the Google Form assessment you shared with your students:

Screenshot 2015-05-13 at 9.19.58 AM

Then return to the Google Form’s answers spreadsheet:

Screenshot 2015-05-13 at 9.21.48 AM

Now it is time to install the Flubaroo add-on for Google Sheets. This is what makes grading the Google Form so easy:

Screenshot 2015-05-13 at 9.23.20 AM

Screenshot 2015-05-13 at 9.25.03 AM

Screenshot 2015-05-13 at 9.26.20 AM

Now that it is installed, use it to grade the answers by taking these steps:

Screenshot 2015-05-13 at 9.27.36 AM

Screenshot 2015-05-13 at 9.29.07 AM

Screenshot 2015-05-13 at 9.29.59 AM

Screenshot 2015-05-13 at 9.32.24 AM

Flubaroo is very valuable to teachers. It highlights students who struggled and questions many students answered incorrectly. It has one other great feature: the ability to quickly give students detailed feedback. To e-mail students their results:

Screenshot 2015-05-13 at 9.33.10 AM

Screenshot 2015-05-13 at 9.37.39 AM

Some teachers might not be comfortable e-mailing the answer key. I prefer total transparency when assessing students. The nice thing about Flubaroo is that it gives you options for how much you share with students.

If you would like to know more about creating assessments in Google Forms, take a loot at part 1 of this post. If you would like to ask me any questions about making paperless assessment in Google Forms, comment below or send me a tweet at @edtechtom.

Advertisement

9 Comments

  1. I’m having an issue e-mailing grades to my students. I’ve gotten the error: Exceeded maximum execution time” twice already. Has this happened to you or do you know a way around it?

    Like

      1. Thanks for the quick response. I still haven’t figured out the problem yet but was wondering how you tackle make-up assessments with regards to the timeline of students receiving feedback & prevent sharing of answer keys once you’ve sent results. Thanks again!

        Like

  2. Sabrina, good question. My best suggestion is to make a copy of the form and then tinker with the questions somewhat. You can always hold off on sending the results e-mail until make-ups are complete though that is not great when we want to give rapid feedback.

    Like

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 )

Connecting to %s