Google Docs

The Tool

Overview (with Links to Help Pages)

Screencast Video Tutorials (via Kathy Schrock)

Group Activity
  1. Who are we? Enter Information on this
  2. How do we see the data? Click here to see our data
  3. What can we do with the data?
Individual Activity
  1. Create a document or presentation.
  2. Share the document with a neighbor and/or with me (so I can show it).
  3. Take a look at the Insert Menu. What are some of the things you put in your document?
  4. What are two ways you might use a Google Doc for at your school?
  5. Name and Save your document. Create a collection and put your document in the collection. Share the collection with your neighbor.
  6. Color your collection folder.
  7. Browse the Template Gallery
Useful Templates for Administrators
In Docs, File - New from Template - Search for Youssef Elias

Create a self-grading quiz!
  1. Take the self grading quiz
  2. Take a look at how it's set up
  3. In a small group, create a three question quiz using a Google Form.
  4. Solicit sample answers from other participants.
  5. Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column.)
  6. Fill Down so that the IF formulas you've written can "grade" all the responses at once!
  7. 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!
  8. Time Permitting: Share your quiz with the lead learner. Links to the quizes will be added below.
  9. Help: How to Create a Self Grading Quiz Using Google Forms
  10. Another video on how to create a Self Grading Quiz by Ben Johnson
  11. Better yet, use the Flubaroo script!
Help and Tutorials
Classroom Resources

Google Docs Overview

Teachers and Principals on Google Docs

Teachers and Principals Talk about Google Docs (external link)

Google Docs in Plain English

Google Docs in Plain English (external link)

How Google Saved a School

How Google Saved a School (external link)

Using Google Forms to Create an Online Quiz

(YouTube Video - Not Viewable Inside the Firewall)