subgroups

 =**Supporting Student Sub-Groups: Collaboration with Google Docs**=
 * Presented by Dr. Mark Wagner, California League of Middle Schools

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 support at risk students, including special education students, English Language Learners, and others that directly effect your API. Learn strategies for differentiating instruction, documenting student learning, providing scaffolding with templates, and implementing frequent formative assessments (with immediate feedback) -- plus much more. This one tool can revolutionize the way you support at risk students, and in this economic environment, the best news is that Google Docs is FRE E.

[|California League of Schools Professional Development Solutions] **

[|Register for this afternoon's webinar] (or ask your staff to register)... there are still open spaces.


 * Introduction and Overview

media type="custom" key="4721915" Slides Developed for CUE's Google Workshop for Administrators **


 * What is Google Docs?**

[|Google Docs Homepage] [|Google Docs for Educators]
 * [|Google Docs Crib Sheet]
 * [|Overview for Educators (presentation)]
 * [|Google Docs: The Basics]
 * [|Google Docs: Tips and Tricks]
 * [|Google Docs in Plain English (video)]
 * [|Docs Templates for Students and Teachers]


 * Interactive Overview (with Links to Help Pages):**

[|Documents] [|Presentations] [|Spreadsheets] [|Forms]

Overview Presentation (From [|Google For Educators - Google Docs]) [|Demo Presentation] (Join me in the chat room!)


 * How can Google Docs be used to extend staff collaboration online?**

Example uses include:
 * Using a document for shared notes, meeting minutes, resources, or lesson plans.
 * Using a presentation for shared instructional materials - or presenting data.
 * Using a spreadsheet for sharing and analyzing data.
 * Using a form to collect data needed for decision making.


 * How can Google Docs be used to support student subgroups?**

Differentiated Learning Document Student Learning (Process and Progress) Scaffolding Frequent Formative Assessments ePortfolios
 * One-to-one with Teacher OR Collaborative Group Work
 * Inquiry-Driven and/or Project-Based Assignments
 * Examples (Protected LAUSD Documents):
 * [|Brain Storm Super Hero]
 * [|Our Story Begins...]
 * [|Fall Kerpoof Picture]
 * [|Revision History]
 * [|Comments]
 * [|Template Gallery]
 * [|Create Your Own Templates]
 * [|Word Count and Readability Statistics]
 * [|Forms] and Self Grading Quizes (See Below)
 * [|Published Documents]
 * [|Shared Folders] and/or [|Google Sites]


 * Sample Uses of Google Docs to Support Student Subgroups (From Student & Teacher Templates)**

[|ELD Lesson Plan Template] [|Special Education Meeting Reflections] [|SST Follow Up Form] [|RtI assessment data e-portfolio template] [|RtI Log] [|Research Paper Template] [|Physics Lab Template] [|More from Todd Roth...] [|Search ALL Student and Teacher Templates...] Bonus: [|Scantron Template] (For frequent assessment and feedback.)


 * More Uses of Forms for Data Collection**

Examples uses 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 (See Below)


 * More Uses of Forms (for Administrators)**

Sample Forms (and Spreadsheets) Used By Administrators: Resources for Administrators Using Google Forms (from GCT Jason Borgen at Portical.org): Additional GCT Resources for Administrators: Even More Ideas...
 * [|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)
 * [|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
 * [|A Blog Post About Using Forms For A Mid-Year Principals' Survey] - From GCT Melanie Holtsman's Principal
 * [|More Ideas] (Collected by Colette Cassinelli)
 * Dan Rezac's Freemont Fight Song Form (Embedded in a wiki)


 * BONUS: Create a self-grading quiz!**

Create a form with a small number of quiz questions. Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column - to the right of the form data.) Fill Down so that the IF formulas you've written can "grade" all the responses at once! (After responses have been submitted!) 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. Advanced: Finally, create a nested IF formula to convert the percentages to letter grades!


 * BONUS: Import and Export Google Docs**

[|Google Docs Mass Uploader] - Upload multiple documents at once! [|Google Docs Download] - Download (and backup) your Google Docs! (Firefox Add-on) [|DownThemAll] - Use with Google Docs Download to make downloading Google Docs easy. (Firefox Add-on)


 * BONUS: Make Google Docs More Secure**

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). Additional Google Docs Resources** [|Google Docs at the Google Teacher Academy] (from GCT Erica Hartman) [|Google Docs at CUE's Google Workshop for Educators] (from many GCTs, including Cory Pavicich) [|Google Docs at CUE's Google Workshop for Administrators] (from many GCTs, including Mark Wagner and Kyle Brumbaugh)
 * 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 [] 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].

[|Google Docs Homepage] [|Google Docs for Educators]
 * [|Google Docs Crib Sheet]
 * [|Overview for Educators (presentation)]
 * [|Google Docs: The Basics]
 * [|Google Docs: Tips and Tricks]
 * [|Google Docs in Plain English (video)]
 * [|Docs Templates for Students and Teachers]

Contact Information:

[|Mark Wagner, Ph.D.] [|California League of Schools Professional Development Solutions]