Making Online Quizzes with Google Docs – Part 3 – Grading Quizzes

For teachers, grading quiz results for papers manually is definitely a hard job. Google Docs provides a good way for teachers to create online quizzes for teaching and learning, you can view the last posts about creating quizzes and sharing quizzes with Google Docs. But teachers, do you know how to grade the quizzes automatically? If you don’t know, this tutorial will give you the details.

Google Docs supports 7 question types: Text, Paragraph text, Multiple choice, Checkboxes, Choose from a list, Scale and Grid. Only multiple choice questions created by Google Docs can be graded automatically. This tutorial will show you the steps to grade the multiple-choice quiz with Google Docs.

Step 1 – Enter answer key

To simplify the grading work, take the quiz yourself before any students take the quiz. Enter the right answers for the quiz and then click Submit.

Step 2 – Invite learners to take the quiz

To simplify the grading work, take the quiz yourself before any students take the quiz. Enter the right answers for the quiz and then click Submit.

Step 3 – Using Formula to grade the quiz

1. Now go back to your Google Docs. You will see your quiz as one of your saved documents. Click on it and you’ll find all responses in a spreadsheet.

Column A shows the date and time of each response, you can view when the quiz-takers take the quiz. Column B shows the student ID which identifies the unique student and all of your questions in subsequent column C, D, E.

quiz respones overview Making Online Quizzes with Google Docs   Part 3   Grading Quizzes

2. Grade each question with IF formula

  • The IF formula is similar with Excel, the syntax for the IF function is:=IF ( test, then_value, otherwise_value ) test – a value or expression that is tested to see if it is true or false.

    then_value – the value that is displayed if then_value is true.

  • otherwise_value – the value that is displayed if then_value is false.

  • Input question 1, 2 and 3 by sequence to column F, G and H to store the score for question 1, 2 and 3.
  • In cell F3, enter “=if($C3=$C$2,100,0)”, and then select and drag the cell to the end of the question column7. You will see the score of question 1 for each student is graded automatically.forumal Making Online Quizzes with Google Docs   Part 3   Grading Quizzes
  • Then, enter “=if($D3=$D$2,100,0)” and “=if($E3=$E$2,100,0)” to G3 and H3, and do the same steps as F3. After these, you will view the score of each question for each student.drag cell score Making Online Quizzes with Google Docs   Part 3   Grading Quizzes

3. Summary the score for each student

Input Total Score to column I to store the total score for each student.

In cell I3, enter “=sum(F3,G3,H3)” to calculate the total score for each student, and then select and drag I3 to I7. Each student’s score for taking the quiz is shown on column I. You saved all that time for grading the quiz with the Formula!

Step 4 – Export the quiz score

Google Docs lets you download the quiz score spreadsheet as CSV, HTML, Text, Excel, OpenOffice and PDF format. By clicking File -> Download as, you will get the score report with ease.

export quiz score Making Online Quizzes with Google Docs   Part 3   Grading Quizzes

You also can view the summary with graphs charting. Particularly for knowing how much knowledge students master, the summary response is great – especially since you can always click “see complete responses” and have them available to you immediately.

Google Docs is really a useful tool for teaching and learning at the aspect of creating quizzes for assessment. Besides Google Docs, You can create Flash quizzes with QuizCreator and track the quiz results with its QuizCreator Online.

share save 171 16 Making Online Quizzes with Google Docs   Part 3   Grading Quizzes

Tags: , , , , ,

7 Responses to “Making Online Quizzes with Google Docs – Part 3 – Grading Quizzes”

  1. [...] Creaza Teste Online Cu Google Docs Google Docs este o unealta gratuita (free) cu ajutorul caruia pot fi create teste online multiple choice precum si surveys. With it, you can create a multiple choice test, invite others to take the test and then grade the test automatically with its formula. Furthermore, it can generate insightful graph analysis for each question with which you get know the extent of understanding for specified knowledge. Guide to make online test with Google Docs Guide to share the online test created by Google Docs Guide to grade the Google Docs quiz automatically [...]

  2. Anna says:

    Thanks so much for this guide, it is so useful. I teach online via Skype to students all over the world. I was researching flash quizes and came here. This is actually even better for me, I can’t believe how awesome this is. I have already created one please visit http://www.skype-englishschool.com/blog

    I am hoping to make some more real soon.

  3. [...] Google Docs tilbyder gratis en facilitet, som kan bruges til at generere test/multiple choice/evalueringer/dataindsamling. Output-formatet er ikke specielt er formateret til iPhone, men det er bestemt brugbart. Applikationen kræver at den, der opretter  materialet, har en Google-konto. Se en vejledning her. [...]

  4. Ray says:

    Like Anna I run a service that offers English and Spanish classes online via Skype and I have been working on the same topic. Thanks a lot. Take a look at the one I created at http://www.online-english-lessos.com

  5. [...] do you know how to grade the quizzes automatically? If you don’t know, this tutorial about how to grade the quizzes automatically will give you [...]

  6. [...] Create online test with Google Docs Google Docs is a totally free online tool to conduct online multiple choice test and surveys. With it, you can create a multiple choice test, invite others to take the test and then grade the test automatically with its formula. Furthermore, it can generate insightful graph analysis for each question with which you get know the extent of understanding for specified knowledge. Guide to make online test with Google Docs Guide to share the online test created by Google Docs Guide to grade the Google Docs quiz automaticallly [...]

  7. amumu guide says:

    amumu guide…

    [...]Making Online Quizzes with Google Docs – Grading Quizzes | Training & E-Learning Zone for Quizzes[...]…

Leave a Reply