How To Create A Test That Grades Itself Using Google Forms

, , 5 Comments

google-forms

How To Create Self Grading Assessments With Google Forms

Google Forms isn’t the first thing you think of when you think of assessment.

It’s not especially elegant, it won’t wow students, and the learning curve isn’t as mild as it might be. But with a little bit of work on the front-end, Google Forms can return the favor in spades on the back-end in the form of self-grading assessments. While there isn’t an app (yet) that can uncover the true nuance of understanding, if you’re using multiple-choice assessments–even just as pre and summative assessments–this trick can save you time, allowing the real potential of assessment to shine through in consistently extracting data to revise planned instruction.

Mike Reading from Google Apps For Edu gives the following itemized rundown on how to use Google Forms to accomplish exactly that in the video below.

“0:15 – What you need to get started

0:55 – How to create your self grading assessment

1:15 – Where to type your question

1:30 – How to add answers

1:45 – What does ‘required question’ mean?

2:00 – How to use the duplicate questions to save time

2:46 – How to add more questions to your self grading assessment

3:00 – A reminder – it is not just about the technology – it is about student engagement through feedback

3:15 – How to add a theme to your self grading assessment

3:45 – How to embed your self grading assessment into a class blog etc

4:40 – The link between a form and a spreadsheet

5:15 – Inserting the script (Flubaroo) into your spreadsheet

5:50 – How to grade the self grading assessment

6:30 – How to read the results”

Also, note on Mike’s page (towards the bottom of his post) how software updates to Flubaroo have improved the way Google Forms responds to student answers.

  • Rudy Heijnen

    Great tip, thank you! But could not find the FLABAROOS you mentioned…

    Geetings,

    Rudy H.
    the Netherlands

  • caddyteach

    like it. thanks

  • S Sisulu

    Quick and easy! The best thing about it is that it sends pupil feedback as well! I would like to know If I can trust it to not collect meta data on students – to put my mind at ease.

  • Luis Oliverio

    Thanks!

  • http://www.newlearner.com Art Lightstone

    Hello, I’m wondering how you might reconcile the time it takes to draw data from the google spreadsheet (where the marks are collected from the Google Form) and then transfer that data to your grades manager? Given that each quiz that is set up using the approach you outline above will generate its own spreadsheet, and each time a student retakes the quiz will drop in a new line of data into the spreadsheet, then a teacher would have to manually inspect each spreadsheet every day, reformat the data so that it somehow shows only the most recent results for each student, and then update only the newest marks into their grades manager. This would have to be done every day, for every single quiz.

    If a teacher taught 100 students across just three different courses, but each of those courses had 50 quizzes in total, and if those quizzes were unlimited mastery quizzes (allowing students to take them as many times as they wish), then, by my calculations, you would need to hire a full time assistant somewhere around the halfway point of the school year just to keep the marks from these spreadsheets updated in the teacher’s grades manager. By the time we get closer to the end of the school year, I believe two full-time assistants would need to be hired solely for this purpose.

    It seems to me that Google Forms are a solution for a few “one-off” quizzes, but not for complete (ie. full curriculum), unlimited mastery learning. If I’m missing something obvious, please do let me know.