This is Part Two of a three part series on making quizzes with Google Forms. Part One focused on how to make the quiz. Part Two (this one) focuses on how to set up automatic grading using Google Spreadsheets. Part three will focus on distribution of the quiz.
If you just want a good automated add on to Sheets, try Flubaroo. However, if you like the DIY approach, read on.
Setting up automatic grading
The simplest way to set up automatic grading for your quiz, is to first take the quiz yourself putting in all the correct answers, and then doing a little work with the Google Spreadsheet where your quiz results are going to be stored. If you have a “name” input option for your student quiz, you can type “Answer Key” to identify your answers later.
After answering the questions correctly, return to your Google Form, and select “View responses” from the menu bar.