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:
Then return to the Google Form’s answers spreadsheet:
Now it is time to install the Flubaroo add-on for Google Sheets. This is what makes grading the Google Form so easy:
Now that it is installed, use it to grade the answers by taking these steps:
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:
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.
Tom Mullaney 
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?
LikeLike
Sabrina, I have never had that issue. You can now share feedback through Google Drive so you could try that. Here’s Alice Keller’s post about it: http://www.alicekeeler.com/teachertech/2015/12/03/flubaroo-send-student-feedback-to-google-drive/
If you’re on Twitter, you could tweet at @flubaroo and see what they say. If you do, please include me, @edtechtom, as I’m curious about why you’re having this problem.
LikeLike
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!
LikeLike
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.
LikeLike