Collaboration in Real Time: Docs, Forms, Spreadsheets & Presentations

The Crib Sheet:

Google Docs Overview for Educators

The Tool:

What's New?

Activity 1:  Who are we? 

How could forms be useful to students and teachers?
  1. Complete this survey.
  2. View the results.
  3. Demonstration: Self-grading Quiz (Your answer to the last question on the survey will be graded!)
  4. Demonstration: Create and publish a chart. Spreadsheet Sample

Activity 2: Google Docs in Action

    How might Google Docs be valuable to an educator?

  1. In a small group, create a DocumentPresentation, Spreadsheet, or Form to illustrate your answer.Teams have 10 minutes to collaboratively complete the task.
  2. Make sure you share the doc with everyone on your team,
  3. Publish the file and add as a collaborator. 
  4. One member of each small group will present the file to the large group in 2 min or less.

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

  1. In a small group, create a three question quiz using a Google Form.
  2. Solicit sample answers from other participants.
  3. Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column.)
  4. Fill Down so that the IF formulas you've written can "grade" all the responses at once!
  5. 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!
  6. Time Permitting: Share your quiz with the lead learner. Links to the quizes will be added below.

Getting Help:

Additional Resources (from GCT Erica Hartman and other GCTs):

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
Storyboard Template
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



Why Use Google Docs?

YouTube Video

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