Today we created a self grading online quiz. It was very simple to do. We just create an =If statement. If statements determine whether a condition is met or not. If you are a geek and want to know more...Click Here Here is an easy tutorial I used to double check what I was doing. I wanted to point out to my fans (Mom and Jenn) than an even easier way to do this(bypassing the IF statement) is to use Flubaroo. Flubaroo is an add-on that you can attach to a Google sheet. It asks you a couple of questions and Viola, your quiz is corrrected. It also alerts you to students that received a low grade and also questions that you asked but your students did poorly on. IE: maybe it was a teacher error.
For my project, I made a simple quiz of Microsoft shortcuts. I highly recommend you make a multiple choice test or some kind of test where they have to choose an answer. I purposely did not do this for this test and you can see that if a student did not answer exactly as you told the program to do it is marked incorrect. Which means you need to go check your spreadsheet and fix any grades. You can see a couple of kids got the question correct but were marked wrong
Below is a sample with the same quiz but using Flubaroo. First you install Flubaroo then click Add-ons --> Flubaroo--> Grade Assignment....EZ PZ
Here is what the Flubaroo spreadsheet looks like:
Here is my cool Quiz. If you don't get a 100% you need to take my computer course















