Docs

The Crib Sheet: 


The Tool: 


What is Google Docs?


Interactive Overview (with Links to Help Pages): 

        

Activity #1
  • Please complete this survey
  • View and discuss the results: summary and spreadsheet try this link to the spreadsheet if that one doesn't work
  • Demonstration: Self Grading Quiz (your answers to the Google Questions will be graded)
  • Demonstration: Publish results on a chart

Activity #2
: Let's apply what we have covered so far (feel free to invite Rushton or me to your project) for more information about Pasadena, CA click here
  • Doc: Write a brief story/description about one of your classes or a travel pitch about Pasadena (include at least one image or utilize the drawing tools in docs)
  • Presentation:  Create a brief presentation about one of your classes or a travel pitch about Pasadena  (try to include at least one image and one type of multimedia)
  • Form:  Create a spreadsheet form/quiz on interesting facts about Pasadena (for ease a fact sheet is attached at the bottom of this page)


Activity #3: Forms for Teacher Observation or Data Collection (time permitting)

Create a form for collecting data. Examples include:
  • A Teacher (or Student) Observation Form
  • A WASC Data Collection Form
  • An Awards Nomination Form
  • A Professional Development Evaluation
  • A formative/summative assessment for your students
  • A Staff or Community Survey
  • A PLC Team Meeting Form
    • Attendance
    • Team Smart Goal
    • Strategies and Action Steps
    • Responsibilities
    • Timeline
    • Evidence of Effectiveness
  • Advanced: A Self-Grading Quiz
Mock up a "proof-of-concept" to illustrate something you might actually implement.
Send the "live form" link to colleagues so they can fill out your form.
Share the results with colleagues or publish them as a web page.
Optional: Create (and publish) charts of the results.
Add the lead learner as a collaborator.



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

In a small group, create a three question quiz using a Google Form.
Solicit sample answers from other participants.
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!
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!
Time Permitting: Share your quiz with the lead learner. Links to the quizes will be added below.

More Sample Uses of Google Docs Forms (for Administrators)

Sample Forms (and Spreadsheets) Used By Administrators:
Resources for Administrators Using Google Forms (from GCT Jason Borgen at Portical.org):
Additional GCT Resources for Administrators:
Even More Ideas...

Import and Export Google Docs 

Google Docs Mass Uploader - Upload multiple documents at once!
Google Docs Download - Download (and backup) your Google Docs! (Firefox Add-on)
DownThemAll - Use with Google Docs Download to make downloading Google Docs easy. (Firefox Add-on)


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.


Google Docs in Plain English




The Doc Blog


Blog

Google Docs @ GTADC



Google Docs by Erica Hartman



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

Interviews: 

A District Administrator Talk About Google Docs and the impact it has had on the classic research paper
Interview with Special Educator on using Google Docs
Sample Permission Slip for Google Apps for Education (includes Docs and other Web 2.0 tools)
Bronx, NY Middle School, CIS 339 Uses Google Apps as "glue" for school. Check out how they use Google Docs

Resources for Administrators Using Google Forms (from GCT Jason Borgen at Portical.org):


An 8-minute tutorial on Google Forms for administrators
A template that principals can use to gather data on mastery of the NETS for teachers -- it automatically aggregates the data for them. 
A Google Spreadsheet template which principals can share with their teachers for paperless lesson plan collection (includes tutorial).
Additional GCT Resources for Administrators:

A Sample Teacher Observation Form (Click on the "entry" tab.) - From GCT Kern Kelley
Staff Book of The Month Club Using Google Docs - From GCT Melanie Holtsman's Principal
A Blog Post About Using Forms For A Mid-Year Principals' Survey - From GCT Melanie Holtsman's Principal



Ċ
CUEtoYOU PD,
Jun 23, 2010, 12:19 AM
Comments