Google Docs

The Tool:
The Crib Sheet: Google Docs
Webinar Recording:


Activity 1: Making a Doc

Over the course of today's session, there may be a number of tools you want to learn more about, or ideas that you will want to explore with others later.  Your personal doc will be your space for notes, links, and anything else you decide to put there.
    1. Log into your Google Account.
    2. Select Documents.
    3. Click on New -> Document
    4. Immediately type in a few words at the top which can serve as the title.  When the system does its first save, what is there will be the default name of the doc.
    5. Use this document to jot down a few notes on what you are learning, with any ideas on how you could try with your students.
    6. EXTRA: If you would like to make this a conversation, invite someone to share your document with you, deciding how to build it together (as is, each of you using different colored text - whatever you wish to try). Not sure how? No worries, we will get to this in Activity 2.

Google Docs

Links to Help Pages

Activity 2: Accessing/Editing a Shared Document Demo Document
    1. Click here to access and edit a shared Google Document.  Then enter your name, email address and your district name, what you teach and change the color of the text to something not used previously. We'll use this to organize ourselves.
    2. Discussion: observe a) simultaneous edits b) lag in updates c) active editors listed at bottom d) revisions e) simplicity of editing interface. Opinions? Implications?

Activity 3: Who are we?
Demo Spreadsheet with a Form

  1. Complete this survey.
  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 4: Join me in the chat room! Demo Presentations

  1. Join this Demo Presentation
  2. Click on View Together to view the chat window.
  3. Click on view presentation with others to join the chat.


NEW!    Lesson Plans Using Google Docs

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



Why Use Google Docs?

YouTube Video

Google Docs in Plain English

YouTube Video

Helpful Tips

Helpful Tips

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

Example of how you might set up a Google Docs Step-by-Step for your Teachers or students

And a Bonus from the Google Blog - Holiday Templates to Keep You Organized
Another Bonus: Collective Spreadsheet Art

Activities for the Week

1. Collaborative Activity: How will Google Docs be valuable to you in your role as an educator?

  • In a team of 3 to 5 participants, create a doc, spreadsheet, or presentation to illustrate your answer.
  • Share the file with everyone on the team as a collaborator.
  • Publish the file and share the url with the lead learner (
  • Links to the files will be added below.
Docs Links

2. Create a self-grading quiz!

  • Create a three question quiz using a Google Form.
  • Solicit sample answers from other participants, family members or others.
  • 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!
  • EXTRA:  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.
Quiz Links

Next Week...Google Blogger and Sites