Google
 

Friday, June 3, 2016

When a Spreadsheet is Better Than a Form

Earlier this week a participant in one of my online courses asked a good question about using Google Forms as an assessment tool. Here's the paraphrased question:

I have created a great rubric for some year end projects. Rather than going straight to the spreadsheet, I complete the form as students present. However, i cannot for the life of me figure out the easiest way for me to take the responses and return them to students. It seems that when I open Flubaroo- things get super confusing.

This is one of the times when a Google Form might not be necessary. In fact, my suggestion was to skip the Form and just enter grades and comments into a Google Spreadsheet that has the Online Rubric Add-on enabled. Online Rubric helps you create a rubric within a Google Spreadsheet. The template will let you include email addresses so that you can quickly send to your students their grades and your comments. The video embedded below demonstrates how to use the Online Rubric Add-on for Google Sheets.