Docs

2015 - 2016 Events‎ > ‎2010-12-03 Google Workshop for Educators, Regina, SK‎ > ‎

Welcome and Overview

Search

Docs

Lunch

Earth and SketchUp

Sites

Even More

Reflection

Online Evaluation

Google Docs GWE CUE Regina Catholic Schools ‎‎(RCS)‎‎

Links to More Learning:

DOCS
Translate Your Doc to Another Language
Snag a Table of Contents, Dictionary or Thesaurus for your Google Doc
Teach Collaborative Revision with Google Docs
Educator's Guide- Teaching Revision with Google Docs
Insert Footnotes
New! Drawing Tools
Create Children's Books Using Sites and Drawing Tools Example 1 Example 2
Research Projects- Putting it all together

SPREADSHEETS
NEW! Educational Spreadsheet Gadgets
Esther Wojciki's Docs and Spreadsheets in the Classroom
50 Google Chart Tricks
Huge List of Functions for Spreadsheets

PRESENTATIONS
A Math Teacher uses Presentations to teach Calculus

FORMS
10 Google Forms for the Classroom
How to Make a Self Calculating Survey - Collete Cassinelli
Step by Step on Creating a self-grading quiz
How to Create a Self Grading Quiz Using Google Forms

More Sample Uses of Google Docs Forms (for Administrators)

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)

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 begin_of_the_skype_highlighting end_of_the_skype_highlighting
More Ideas (Collected by Colette Cassinelli)

Teach Collaborative Revision with Google Docs

Revision is a critical piece of the writing process—and of your classroom curriculum. Now, Google Docs has partnered with Weekly Reader’s Writing for Teens magazine to help you teach it in a meaningful and practical way.

The sharing features of Google Docs enable you and your students to decide exactly who can access and edit documents. You’ll find that Google Docs helps promote group work and peer editing skills, and that it helps to fulfill the stated goal of The National Council of Teachers of English, which espouses writing as a process and encourages multiple revisions and peer editing.

On this page, you will find several reproducible PDF articles from Writing magazine filled with student-friendly tips and techniques for revision. You'll also find a teacher’s guide that provides you with ideas for how to use these materials with Google Docs to create innovative lesson plans about revision for your classroom.

Getting Started

1) Download a step-by-step tutorial [pdf] for Google Docs.
2) Learn about the comments and revision features of Google Docs [pdf].

3) Download, print, and share the following articles [pdf] with your students:

4) Download our Educators Guide: Teaching Revision with Google Docs

After reviewing our activity ideas and Google Docs tutorials, you may develop your own lesson plans and ideas. We want to hear from you! We invite you to share your curriculum ideas with the Google Educators community through our Google for Educators Discussion Group.

Hands-On Activities

Activity 1:

How might Google Docs be
valuable to an educator?

In a small group, create a document, presentation, spreadsheet, or form to illustrate your answer. Try to think of at least 5!

Details

Choose a team leader and have that person create and share the document with the other members of the team.
Share the doc with your whole team.
Teams have 10 minutes to collaboratively complete the task.
Pick a member of the group to present the file to the large group in 2 min or less.

Examples:

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: Forms for Teacher
Observation or Data Collection

Create a form for collecting data.

For this task, your objective is create one form that you can implement immediately in your classroom or office to (1) reduce waste (2) save time and (3) collect feedback or information.

Steps in the process:

Create a and name new form. (Lost? Watch this video.)
Select the appropriate question types.
Apply a theme of your choice.
Test your form out. Get a few people to respond to your form.
Use Form > Show summary of responses to get a quick overview of
how people responded.
Sort by a few different response choices.

Examples include:

A Teacher (or Student) Observation Form
An Awards Nomination Form
A Professional Development Evaluation
A Staff or Community Survey
A Team Meeting Form
- Attendance
- Team Smart Goal
- Strategies and Action Steps
- Responsibilities
- Timeline
- Evidence of Effectiveness
Advanced: A Self-Grading Quiz

Mock up 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.

Add the lead learner (wendygorton@gmail.com) as a collaborator.
One member of each small group will present the form to the large group.

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