The Crib Sheet: 

The Tool: (Brief Demo)

Getting Help: 

  1. Complete this survey or go to
  2. View the results.
  3. Demonstration: Create and publish a chart.
  4. Demonstration: Self Grading Quiz (Your answer to the last question on the survey will be graded!)
Activity 2: How might Google Docs be valuable for mobile learning?

In a small group, create a document, presentation, spreadsheet, or form to illustrate your answer.
Publish the file and add the lead learner as a collaborator. Links to the files will be added below.
One member of each small group will present the file to the large group.

Activity 3: Create a self-grading quiz! (Time permitting)

  • In a small group, create a three question quiz using a Google Form.
  • Solicit sample answers from other participants.
  • Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column.)
  • Fill Down so that the IF formulas you've written can "grade" all the responses at once!
  • Advanced: Create a SUM formula to total up the total score for each person that took the quiz. Then create another formula to calculate the percentage. Finally, create a nested IF formula to convert the percentages to letter grades!
  • Time Permitting: Share your quiz with the lead learner. Links to the quizes will be added below.

Google Docs Overview by Chris Bell

Google Docs Chicago Erica Hartman

Helpful Tips

Link Library:

3 Getting Started Guides for Beginners
NEW! Educational Spreadsheet Gadgets
How to Make a Self Calculating Survey - Collete Cassinelli
A Great Comparison of all Google Docs components
Official Google  Docs Blog
Google Docs for Educators
Using Google Docs in the Classroom
Google Docs Templates
Digital Toolbox: Google Docs
Read any web document in Google Docs -This extension (download link) lets you read online documents directly in your Google Docs account with a simple right click.
10 Google Forms Ideas for the classroom - provides template copies for each form by Tom Barrett
Using Google Docs in the Classroom: Tips and Tricks
20 Ways To Use Google Docs in the Classroom
Snag a Table of Contents, Dictionary or Thesaurus for your Google Doc
Google Apps Docs Interactive Tutorial
Google Docs Classroom Ideas Wiki
Teach Collaborative Revision with Google Docs
Educator's Guide- Teaching Revision with Google Docs
Esther Wojciki's Docs and Spreadsheets in the Classroom
Google Docs Blog
Google Docs Keyboard Shortcuts
Insert Footnotes
Google Wants YOUR Docs Ideas- click here to submit and see examples.
How to Create a Self Grading Quiz Using Google Forms
New! Drawing Tools
Create Children's Books Using Sites and Drawing Tools Example 1     Example 2
Research Projects- Putting it all together



Google Docs in Plain English

YouTube Video

Using Google Forms to Create a Quiz

Using Google Forms to Create a Quiz

Using Charts in Google Spreadsheets

Using Charts in Google Spreadsheets

National Writing Project - How To Use and Set Up Templates for Students

YouTube Video