Google Docs

Webinar Recording
View
 
https://my.dimdim.com/view/all/markdwagner/default/8b4bdcca-ba42-479d-8d26-db152c84de09
 
https://my.dimdim.com/chat/all/markdwagner/default/8b4bdcca-ba42-479d-8d26-db152c84de09
 
Download
 
https://my.dimdim.com/content/recording/flv/saas/dimdim/all/markdwagner/default/8b4bdcca-ba42-479d-8d26-db152c84de09?mode=save
 
https://my.dimdim.com/content/recording/chat/saas/dimdim/all/markdwagner/default/8b4bdcca-ba42-479d-8d26-db152c84de09?mode=save



The Crib Sheet: 




Overview

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 https://docs.google.com 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.



Resources


  • 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

    Videos:

    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
    https://sites.google.com/site/edtoolstrade/

    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 (lvnitsche@gmail.com).
    • 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: https://spreadsheets.google.com/viewform?formkey=dHNKMTIyaDRyb1dvaGpVQ1J0NnBfNVE6MQ  Great use of mathematical formulas!
    Susquehana River Basin: https://spreadsheets.google.com/viewform?formkey=dGlFbWt5S1BaSnlvbVNZTWJIc1VNd1E6MQ
    Erie, PA Quiz:  https://spreadsheets.google.com/viewform?formkey=dHhUa2FEVUZZdjN6NWNKTnRqbHp4Zmc6MQ
    Internet Safety:  https://spreadsheets.google.com/viewform?formkey=dFkwaWtmUkVtNk5nQVZtaWFWekhScmc6MQ
    Volcanoes of Hawaii:  https://spreadsheets.google.com/viewform?hl=en&formkey=dFBPaE9FVFRXakF1S05zdjJ3LU9QQXc6MQ#gid=0
    Resources for 21st Century Teaching:  https://spreadsheets.google.com/viewform?hl=en&formkey=dDBMT0lGZVgzWm9tVWZ5X003V0ZXRkE6MQ#gid=0
    Oil City, PA's Oil Heritage Festival:  https://spreadsheets.google.com/viewform?formkey=dG5aTlVPQnRBLWJkcTNXY1hxVXczRnc6MQ
    Computer Quiz:  https://spreadsheets.google.com/viewform?formkey=dGpKX25vUm8xd1hQa1VrRFpjT2JkNkE6MQ
    Presque Isle State Park:  https://spreadsheets.google.com/viewform?hl=en&formkey=dHhUa2FEVUZZdjN6NWNKTnRqbHp4Zmc6MQ#gid=0
    Self Grading Quiz Hixson
    Computer Quiz:  https://spreadsheets.google.com/viewform?hl=en&pli=1&formkey=dGpKX25vUm8xd1hQa1VrRFpjT2JkNkE6MQ#gid=0
    Rehearsal Quiz: 

    Next Week...GeoApps
    Comments