forumdocs

=Using Google Docs to Support Your PLC= [|Mark Wagner, Ph.D.]

Google Docs is an online office suite that allows you to create, edit, share, and publish documents, including spreadsheets and presentations. Because everything is stored and even modified on the web, Google Docs makes it easy to collaborate with colleagues - and even to edit the same document from multiple computers simultaneously. This session will focus on the use of Google Docs to promote and support collaboration within a PLC, including strategies for creating common assessments, sharing best practices, and capturing the conversation - even between meetings. This one tool can revolutionize the way your PLC collaborates. And it’s free.

=Agenda=


 * Welcome Activity**


 * What is Google Docs?**
 * Your best answer?
 * [|Google Docs Homepage]
 * [|Google Docs Crib Sheet]
 * [|Google Docs for Educators]
 * [|Overview for Educators (presentation)]
 * [|Google Docs: The Basics]
 * [|Google Docs: Tips and Tricks]
 * [|Google Docs in Plain English (video)]


 * Interactive Overview (with Links to Help Pages):**
 * [|Documents] (A few volunteers can join me in a new document.)
 * [|Presentations] (A few volunteers can join me in a new presentation.)
 * [|Spreadsheets] (A few volunteers can join me in a new spreadsheet.)
 * [|Forms] (Anyone can join me in activity 2 below!)

Create a document, presentation, or spreadsheet to illustrate your answer. Example answers include:
 * Activity 1: How can Google Docs be used at your site or in your program? (Interactive Demonstration)**
 * Using a document for shared notes, meeting minutes, resources, or lesson plans.
 * Using a presentation for shared materials - or presenting data.
 * Using a spreadsheet for sharing and analyzing data.


 * Activity 2: Who are we? (Interactive Demonstration)**
 * 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!)

Create a form for collecting data. Examples include:
 * Activity 3: Forms for Teacher Observation or Data Collection (Interactive Demonstration)**
 * 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


 * BONUS Activity: Create a self-grading quiz! (Time permitting)**
 * 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!


 * BONUS 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

More Sample Uses of Google Docs For PLCs
 * [|PLC Reflections] (Via Skip Offenhauser)
 * Sample [|"PLC" Templates]
 * Thousands of [|Templates for Students and Teachers]
 * Don't Miss [|Todd Roth's Templates]


 * More on Google Docs in Education**
 * [|Overview from Google Teacher Academy in Boulder, CO] (August 2009)
 * [|Top Ten Tips from Google Teacher Academy in Washington, DC] (December 2009)
 * [|Google Docs for Administrators from Google Teacher Academy in San Antonio, TX] (March 2010)
 * [|Google Docs for Educators from CUE's Google Workshop for Educators] (June 2010)


 * Reflection Activity**

[|Online Evaluation]