Online College Courses for Credit

How to setup an auto-correcting google form spreadsheet

How to setup an auto-correcting google form spreadsheet

Author: Paul Hannan
See More
Fast, Free College Credit

Developing Effective Teams

Let's Ride
*No strings attached. This college course is 100% free and is worth 1 semester credit.

26 Sophia partners guarantee credit transfer.

308 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 27 of Sophia’s online courses. Many different colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.


An Auto-Correcting Spreadsheet

Notes on "An auto-correcting google form spreadsheet"


0:00-0:35 Introduction
​0:36-1:59​ Overview of how Google Forms works
2:00-3:41 Seting up an answer key
3:40-5:37 Auto correct formula arrayformula(sum(2A:2Z=3A:3Z))       2A:2Z=answer key range 3A:3Z= row being graded
5:38-6:57 Step by step formula use

6:58-8:18 Showing percentage correct and color coding students scores
8:19-9:16 Classwide feedback and summary responses
9:17-9:47 Conclusion and contact information

I made this tutorial on how to setup an auto-correcting Google Form spreadsheet in spring 2012 but it still works great. If you've started using Google Forms for some of your more traditional testing needs this auto-correcting trick is a real time saver. Since this combinations of Google Forms and auto-correctly handles pure content well, it allows teachers to spend more time grading relevant projects, writing assessments, and open ended "big" questions.