Google Forms and Flubaroo - Fantastic Formative Assessment

This term I have been using Google Forms as a way to formatively assess student learning and help form next steps for learning.  For those of you unfamiliar with Google forms it is essentially an online survey that you can edit, adapt and craft into almost any form you like.  The results are then collated in a Google Sheet (spreadsheet).

I had been playing around with conditional formatting to help highlight areas of need and next steps for learning.  It worked but was time consuming and fiddly.  Then I discovered Flubaroo.  This awesome little add-on for Google Sheets will automatically mark, grade and analyse student responses for you.  There are times where you may need to adjust student spelling for their answers to register as being correct but this is simple to do and doesn't take much time.  Flubaroo also identifies questions that the class as a whole didn't do well on giving you easy next steps.

Sample of a 'Grades' sheet after Flubaroo has worked its magic. 

Flubaroo also allows you to weight questions, with more important questions getting more points than support questions.

So if you are using Google forms for quizzes or low stake assessments then give Flubaroo a go.  It's a handy little tool that just might make your life a little easier.