Sharing What I Find

Instructional Design and Technology in Education

Auto-Graded Google Form

I think Google Forms are a great course room tool for collecting information. I’ve written about them before in a Teaching Tip called Collecting Information with Google Forms and on iTeachU in the Grow Skills section. Here is a video that shows how to set up your form for auto-grading. When you create a Google form, the respondent’s answers are collected in a spreadsheet. The process for auto-grading those responses uses the “=IF” statement, a common function available in spreadsheets.

The blog post: Quick and Easy IF Formulas for Grading Google Forms explains it all.

Of course, auto-grading really depends on the kind of answers you expect to receive. You have to take into account capitalization and spelling. “january” isn’t the same as “January” or “jan.”   And word order also matters:   “peanut butter and jelly” isn’t the same as “jelly and peanut butter.”




Author: Heidi Olson

Heidi enjoys working with content experts in developing eCampus courses to provide alternatives for students. Her other interests include faculty training in best practices for eCampus and researching eCampus tools to help fulfill learning outcomes. Having worked in the distance education arena for over 20 years, she has a wide range of experiences in supporting students and faculty as technology and pedagogy evolve.

Comments are closed.