The Docs segment will focus on extending a PLC online (with collaboration, shared assessments, and data collection/analysis), and using Forms for custom teacher observations or online referrals (even on a mobile device).
The Crib Sheet:
Interactive Overview (with Links to Help Pages):
Overview Presentation (From Google For Educators - Google Docs)
Demo Presentation (Join me in the chat room!)Activity 1: Who are we?
Complete this demo survey.
View the results.
Demonstration: Create and publish a chart.
Demonstration: Self Grading Quiz (Your answer to the last question on the survey will be graded!)
Sample Forms (and Spreadsheets) Used By Administrators:
Activity 2: How can Google Docs be used to extend your PLC online?
In a small group, create a document, presentation, or spreadsheet to illustrate your answer.
Example answers include:
One group member should create the file and add the others as collaborators.
Publish the file and add the lead learner as a collaborator. Links to the files will be added below.
One member of each small group will present the file to the large group.
Activity 3: Forms for Teacher Observation or Data Collection
Create a form for collecting data.
This will be a "proof-of-concept" to illustrate something you might actually implement.
Example topics include:
Publish the file and add the lead learner as a collaborator. Links to the forms will be added below.
One member of each small group will present the form to the large group.
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.
Demonstration: Using Google Docs and Forms on a Mobile Device
Accessing your Google Docs on a Mobile Device
Completing a Google Form on a Mobile Device
Additional Resources (from GCT Erica Hartman and other GCTs):
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
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
A District Administrator Talk About Google Docs and the impact it has had on the classic research paperAdditional GCT Resources for Administrators:
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).
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