Bragto U: Self Grading Quiz Part II

Bragto University
Class: DOCS 401 Self Grading Quiz Part II

I see more and more online test and quiz software being promulgated in schools nowadays, and charging lots of money.  Using Google Docs, you can create your own online assessment.  Using formulas in Google Spreadsheets, you can have it graded and scored automatically.

Objective:  You will be able to create an online form to collect answers from a quiz or test and use formulas to grade and score it.

Prerequsites:

1. Bragto U: Using Forms Part 1


2. Bragto U: Using Forms Part 2


3. Bragto U: Self Grading Quiz Part 1

Materials:

• Google Docs Account

Procedure:

• In the previous post, we setup:
  
  
  
  • A form to be used as a test or quiz.
  
  
  • Spreadsheet is made from the form to collect results.
  
  
  • A formula to check if an answer was correct.
  
  
  
  


• With that being done, you now have a spreadsheet with the individual scores from individual answers.  To total the scores, we need another simple formula.
  
  
  
  • Select the next available cell.
  
  
  • Type =sum( and select the cells that you would like to total.  Use the mouse as a "lasso".
  
  
  • Formula Usage: =sum(cell1:cell2)
  
  
  • Once you hit enter, the points will be totaled.
  
  
  
  


• Now that we have the total points scored, now we should find out their grade.
  
  
  
  • Select the next available cell.
  
  
  • Usage: =(total points score cell/amount of points on the test)*100
  
  
  • [gallery link="file" columns="2"]
  
  
  • Done!
  
  
  
  


• Now with all that done, every time a student submits their test all you have to do is:
  
  
  
  • Select all the formula cells.  Put your mouse at the corner of the cells, so you get a '+' cursor.
  
  
  • Drag the cursor down to tabulate the newly submitted answers.
  
  
  
  


• Complete! Take a peak at the finished product.