### Docs

The Crib Sheet:

The Tool:

Interactive Overview (with Links to Help Pages):

Demo Presentation (Join me in the chat room!)

Activity #1
• View and discuss the results: summary and spreadsheet try this link to the spreadsheet if that one doesn't work
• Demonstration: Publish results on a chart

Activity #2
: Let's apply what we have covered so far (also try to use some of what Ken shared with you to accomplish this)
• Doc: Write a story about Pennsylvania (write it as a travel pitch or vacation pitch, try to include at least one image)
• Presentation:  Create a brief presentation about Pennsylvania (try to include at least one image and one type of multimedia)
• Spreadsheet:  Create a spreadsheet outlining important or useful data about 5 different topics on Pennsylvania (population changes, weather, etc. Publish your results in a graph or chart.)

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 Staff or Community Survey
• A PLC Team Meeting Form
• Attendance
• Team Smart Goal
• Strategies and Action Steps
• Responsibilities
• Timeline
• Evidence of Effectiveness
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.
One member from a few groups will present the form to the larger 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!

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

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.

The Doc Blog

#### Copy of GWE The Dalles - Docs

Interviews:

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):