Using Google Forms to Simplify Marking with Rubrics

By taking a few minutes to set up a Google form, you can drop your highlighter and pen and click away to get your marking done. All your results are saved in a spreadsheet for easy reference later.

Once you're comfortable with that, add on a script and have students receive their results by email once you've marked their work!

This will be covered in our Tuesday Tech-in-20 session on January 21st (12:10-12:30) if you are interested.

Step 1: Set Up the Form

This strategy is very effective when you re-use the same rubric over and over throughout the year. We developed this example rubric for assessing problem solving in math - the problems change throughout the year, but the rubric does not. A similar rubric has been created for evaluating oral presentations in French.

 

If you need help with creating a Google form, just let me know. 

Once the basic form has been created, you will want to:

• replace email addresses with students you will be marking repeatedly using this rubric (suggestion: put yourself in this list too so that you can use yourself for testing that it all works)
• set response destination (click the button to set the spreadsheet where the results will be saved)
  
  

Step 2: Try it out!

Go to the live form and enter some data. What assignment is it? Choose yourself as the student, and then assess your work.

Now check the response spreadsheet - you will see the summary of all the results you have recorded. As you use the form to record assessments over time, these results can be sorted to examine trends.

Step 3: Email students their results (entirely optional)

Your next step is to communicate the results to the students. If you want to conference with each of them, you have your marks handy in the spreadsheet, but it is even easier to click a few buttons and have the boys receive a copy of their assessment in their Gmail inbox!

Chad Kafka has a very thorough explanation on how to add the Form Emailer script to the spreadsheet and then configure it so that your students receive an email each time you hit submit on the form. I have also compiled a video tutorial showing you how to walk through this process. For example, a student might receive this message:

If you're interested in making this work for you, let me know.

Here's a 12-minute video tutorial showing you how it all works:

- Sarah