Skip to main content
guest
Join

Help

Sign In
gettingoogley
Home
guest

Join

Help

Sign In
Wiki Home
Recent Changes
Pages and Files
Members
Gettin' Googley Home
Custom Search: What I'm Lookin' For
 about
the U2 Quiz
 about
the SelfCorrecting Quiz
Docs: Nyaah, What's Up Docs?
 about
creative commons
 about
Presentation Tennis
Maps: Where Do You Want To Go?
Calendar: Remember When ... ?
Blogger: If Only We Had Time!
The Sandbox
Feedback
The Amazing Google List
Contact
This work is licensed under a
Creative Commons Licence
.
SelfCorrecting Google Quiz
Edit
0
1
…
0
Tags
No tags
Notify
RSS
Backlinks
Source
Print
Export (PDF)
To Make Your Quiz SelfCorrecting ...
The Copy&Paste 10 Questions Edition
Step 1:
Take the quiz yourself. Enter the exact right answers.
Step 2:
Access the form as a spreadsheet. In cell
M3
enter the number 10; the maximum perfect score for this quiz.
Step 3:
Copy the formula below (including the "=") and paste it into cell
N3
.
=(IF(C3=$C$2,1,0)+IF(D3=$D$2,1,0)+IF(E3=$E$2,1,0)+IF(F3=$F$2,1,0)+IF(G3=$G$2,1,0)+IF(H3=$H$2,1,0)+IF(I3=$I$2,1,0)+IF(J3=$J$2,1,0)+IF(K3=$K$2,1,0)+IF(L3=$L$2,1,0))
Step 4:
Copy the formula below (including the "=") and paste it into cell
O3
.
=ROUND((N3)/(COUNTA($C$2:$L$2))%,0)
Step 5:
Test it out by taking the quiz again and entering some right & some wrong answers.
Javascript Required
You need to enable Javascript in your browser to edit pages.
help on how to format text
Turn off "Getting Started"
Home
...
Loading...
To Make Your Quiz SelfCorrecting ...
The Copy&Paste 10 Questions Edition
Step 1: Take the quiz yourself. Enter the exact right answers.Step 2: Access the form as a spreadsheet. In cell M3 enter the number 10; the maximum perfect score for this quiz.
Step 3: Copy the formula below (including the "=") and paste it into cell N3.
=(IF(C3=$C$2,1,0)+IF(D3=$D$2,1,0)+IF(E3=$E$2,1,0)+IF(F3=$F$2,1,0)+IF(G3=$G$2,1,0)+IF(H3=$H$2,1,0)+IF(I3=$I$2,1,0)+IF(J3=$J$2,1,0)+IF(K3=$K$2,1,0)+IF(L3=$L$2,1,0))
Step 4: Copy the formula below (including the "=") and paste it into cell O3.
=ROUND((N3)/(COUNTA($C$2:$L$2))%,0)
Step 5: Test it out by taking the quiz again and entering some right & some wrong answers.