Google+Quiz

=**SELF-GRADING GOOGLE DOCS**= Alan November often speaks of the difference between automative and transformative uses of technology. However The benefits of using a self-grading form are two fold. First google provides a unique feedback feature that allows you tin instantly share results with students. This instantaneous feedback loop is important in the learning curve. The second potential benefit is allowing more time in terms of planning instruction. Time not spent grading is time spent planning which can be very effective.

Steps to Creating a Self Grading Quiz

1. Use Google Forms and select and create the multiple choice question format.


 * Require separate lines for first name, last name, and student ID number in the intro




 * Require students to make a selection by clicking the required box.



2. Create Questions

3. Complete Quiz yourself and note the answers by filling in KEY for Name and ID.

4. Learn the Magic Formula

=IF(E2=$E$2,1,0)

$E$2 provides a constant formula This is a classic excel IF - THEN formula or programming
 * E corresponds to the first answer (provided you've used three lines for identification)

5. Learn Sum Formula for Totals

To the right of your last scored column add a column SUM(RANGE:RANGE) EXAMPLE SUM (AB2:AY2)Drag formula down vertically.

6. Display Instantaneous Results by Clicking on Show Summary