techcon2010

=Using Google Docs to Support Your PLC=

Take your professional learning community to the next level by using Google Docs to collaborate with colleagues. 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. Google Docs can even be used for data collection and analysis. This one tool can revolutionize the way your PLC collaborates. And it’s free.

If you have questions about this workshop, please contact Dr. Mark Wagner, educational technology coordiantor for CLMS & CLHS, at mark@edtechlife.com or 949-639-9743.

=Agenda=


 * Welcome Activity**
 * Are you working in a PLC?
 * How do you collaborate in your PLC? (What about between meetings?)


 * Do you have a [|Google Account]?
 * Have you used [|Google Docs] before?
 * Could you explain Google Docs to a colleague?


 * What do you hope to get out of today's session?


 * What is Google Docs?**
 * Your best answer?
 * [|Google Docs Crib Sheet]
 * [|Google Docs Homepage]
 * [|Google Docs for Educators]
 * [|Overview for Educators (presentation)]
 * [|Google Docs: The Basics]
 * [|Google Docs: Tips and Tricks]
 * [|Google Docs in Plain English (video)]
 * [|More...] (From [|CUE]'s [|Google Workshop for Administrators])


 * 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] (Everyone can complete a demo form - see below...)
 * Are you ready to move on to some activities?


 * Activity 1: Who are we?**
 * No Google account is required!
 * Complete [|this demo survey].
 * View [|the results] .
 * Demonstration: View summary.
 * Demonstration: Create and publish a chart.
 * Demonstration: Self Grading Quiz (Your answer to the last question on the survey will be graded!)
 * Are you ready to see how to create, edit, and collaborate on specific PLC documents? (Grin or Frown?)


 * Activity 2: How can Google Docs be used to extend your PLC online? (Demonstration)**
 * Example answers include:
 * Using a document for shared assessments, lesson plans, meeting minutes, or other resources.
 * Using a presentation for shared materials - or presenting data.
 * Using a spreadsheet for sharing and analyzing data.
 * Create a document, presentation, or spreadsheet to illustrate your answer.
 * Add colleagues as collaborators.
 * Mock up a "proof-of-concept" to illustrate something you might actually implement.
 * Are you ready to move on to creating and sharing a specific PLC form? (Grin or Frown?)


 * Demonstration 3: Forms for Data Collection, Analysis, and Sharing (Demonstration)**
 * Example topics 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
 * Advanced: A Self-Grading Quiz
 * Create a form for collecting data.
 * 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.
 * Are you ready to move on? (Grin or Frown?)
 * Time permitting we can view more samples...
 * Or create a self-grading quiz...
 * Or talk about using Google Docs with a mobile device.


 * More Sample Uses of Google Docs (for Administrators)**
 * [|Docs Templates for Students and Teachers]
 * Don't miss the fantastic templates [|provided by principal Todd Roth].
 * Sample Forms (and Spreadsheets) Used By Administrators:
 * [|PLC Reflections] (Via Skip Offenhauser)
 * [|Math Curriculum Review Team Site Level Data Survey] (Via Skip Offenhauser)
 * [|Teaching Assignments] (Via Skip Offenhauser)
 * [|Woodside High School Emergency Plan Form] (Via Kyle Brumbaugh)
 * [|Woodside High School Emergency Plan Spreadsheet] (Via Kyle Brumbaugh)
 * [|Woodside High School Co-curricular Assignments] (Via Kyle Brumbaugh)
 * 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
 * [|More Ideas] (Collected by Colette Cassinelli)
 * Even More Ideas...
 * Dan Rezac's Freemont Fight Song Form (Embedded in a wiki)


 * CHALLENGE Activity: Create a self-grading quiz! (Time permitting)**
 * Create a three question quiz using a Google Form.
 * Solicit sample answers from some colleagues.
 * 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.


 * BONUS Activity: Using Google Docs and Forms on a Mobile Device (Time Permitting)**
 * Accessing your Google Docs on a Mobile Device
 * Completing a Google Form on a Mobile Device


 * Getting Started (On Your Own)**
 * Create a [|Google Account] (if you don't already have one).
 * Login to [|Google Docs]
 * Click on the "New" button to the left and select the type of document.
 * Play... and return to this page for more information and tutorials. :)
 * Are you ready to get started?
 * Use it before you lose it!
 * Email me if you have any trouble, or...
 * Post your question to the discussion below.


 * Reflection Activity**
 * Join the [|League Learning Network], the CLMS & CLHS online social network.
 * Reply to the "[|How can you use Google Docs to support your PLC?]" forum discussion.
 * Consider specific things you learned that you would like to implement in the coming school year. What are your next steps? And what do you still have to learn?
 * Please reply to your colleagues' posts as well so that the discussion there can grow. :)