Google Docs

Webinar Recording

The Crib Sheet: 


What is Google Docs?

                   Don't forget to turn on the new featuresLearn More.

What's New?

Google Docs Overview for Educators

Activity 1: Accessing/Editing a Shared Document Demo Document
    1. Click here to access and edit a shared Google Document, which we will use to organize ourselves for the On Your Own Activity during the week.
    2. Select a color of text to something not used previously. Then enter your 
  • name
  • email address
  • your district name
  • what you teach 
  • any ideas for using Google Docs
      3.  Discussion: observe a) simultaneous edits b) chat c) active editors listed at bottom d) revisions e) simplicity of editing interface. Opinions? Implications?

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

  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 3: 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.

Make Google Docs More Secure

Http is an insecure protocol. Https is secure. Be sure to always use https when accessing Google Docs on a public network (or any network for additional security

Method 1 - Simply type an "s" at the end of "http" when you connect to Google Docs to force a secure connection. You can then bookmark for future secure access

Method 2 - For users of Gmail, go to Settings, look for Browser Connection, and select "Always use https" - then always launch Docs from the link at the top of the Gmail page. This will force Docs to open using https as well

Method 3 - For administrators of a Google Apps: Education Edition domain, you can require all users in the domain to use https by Enabling SSL for your domain.


  • How to Make a Self Calculating Survey
  • Google Docs Templates
  • Read any web document in Google Docs
  •  Firefox Extension (download link)
  • 10 Google Forms Ideas for the classroom Description and Templates
  • 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
  • Educator's Guide- Teaching Revision with Google Docs
  • Google Docs Keyboard Shortcuts
  • How to Make a Self Calculating Survey
  • How to Create a Self Grading Quiz Using Google Forms
  • Insert Footnotes
  • Educational Spreadsheet Gadgets
  • Google Docs Templates
  • A Great Comparison of all Google Docs components
  • 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.

  • Articles


    Introducing a New Google Docs

    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

    Post Your Questions on Google Moderator

    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.
    • To receive Act 48 credit, please submit your Google Doc URL through the Google Form below:

    How Google Docs Will Be Valuable to You in Your Role as an Educator

    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.
    • To receive Act 48 credit, please submit your Google Form / Self-Grading Quiz URL through the Google Form below:

    Google Form / Self-Grading Quiz

    Quiz Links:
    Pre Calculus Pre Test:  Great use of mathematical formulas!
    Susquehana River Basin:
    Erie, PA Quiz:
    Internet Safety:
    Volcanoes of Hawaii:
    Resources for 21st Century Teaching:
    Oil City, PA's Oil Heritage Festival:
    Computer Quiz:
    Presque Isle State Park:
    Self Grading Quiz Hixson
    Computer Quiz:
    Rehearsal Quiz: 

    Next Week...GeoApps