Self Grading Quizzes using Google Forms

Self Grading Quizzes using Google Forms



1. Create a new Google Form

For sorting purposes create separate questions for the first and last names

You can use as many questions in the Form as you’d like as long as there is one correct answer

Use only "Multiple Choice", "Choose from a List" and "Checkboxes"


2. Go to the live Form and complete it with the correct answers

3. Go back to Google Docs and open the Spreadsheet view of your Form.

Copy and paste the correct answers into the blank columns in Row 1

4. Label the last Column “Student Average”

5. To write the formula, you need to use an IF/THEN statement, so if you are looking at the data collected in Column D to match the data you input in Column F, your formula would look like this:

=if(D3=F1,100,0)

things to think about

if it = F1 = 100 --> they got the answer correct

if it ≠ F1 = 0 --> they got the answer wrong

this example is for Row 3

6. Since you will want the formula to repeat for every student that completes the Form, you need to add the “$” in front of the F1 to keep that cell a constant

=if(D3=$F$1,100,0)

7. To calculate your Student Average you will enter the following formula:

=average(F3:G3)

= to --> so adjust the cells as needed

You can then sort by class average

Note: You must hit the ESC (Escape) button to leave a cell rather than clicking on another cell like you would in Excel.

8. If you would like to set your spreadsheet so that each cell that contains a correct answer will turn GREEN and each cell with a wrong answer will turn RED, simple right-click on each column you want to set and select "change color with rules".

If the text = 100 then the background is Green

If the text = 0 then the background in Red

Notes from group:

Double click on a cell to see the formula in that cell.
Use the ESC button to leave a cell.