Google How-To‎ > ‎

Forms

The Tool
Overview (with Links to Help Pages)

Group Activity
  1. Who are we? Enter Information on this form
  2. How do we see the data? Click here to see our data
  3. What can we do with the data?
Help and Tutorials
Classroom Resources

Create a self-grading quiz! 
  1. Take the self grading quiz
  2. Take a look at how it's set up
  3. In a small group, create a three question quiz using a Google Form.
  4. Solicit sample answers from other participants.
  5. Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column.)
  6. Fill Down so that the IF formulas you've written can "grade" all the responses at once!
  7. Advanced: Create a SUM formula to total up the total score for each person that took the quiz. Then create another formula to calculate the percentage. Finally, create a nested IF formula to convert the percentages to letter grades!
  8. Time Permitting: Share your quiz with the lead learner. Links to the quizes will be added below.
  9. Help: How to Create a Self Grading Quiz Using Google Forms