Have Google Grade Your Papers

One of the most valuable but under used Google Apps has to be the Forms feature of Google Spreadsheets. I have started giving my students quizzes using Forms. Forms is a tool that lets you create survey questions with multiply choice, short answer or long answer responses. Using the above IF STATEMENT a teacher can program the Google Form to grade itself. I then filter the grades into my gradebook spreadsheet. The above statement checks if the student's answer matches the correct answer of -21 in cell M1. If the answer is correct the student gets 100, if the answer is incorrect the student gets a 0.