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.


Welcome Activity

What is Google Docs?

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

Activity 1: How can Google Docs be used at your site or in your program? (Interactive Demonstration)
Create a document, presentation, or spreadsheet to illustrate your answer. Example answers include:
  • 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!)

Activity 3: Forms for Teacher Observation or Data Collection (Interactive Demonstration)
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

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

More on Google Docs in Education

Reflection Activity

Online Evaluation