Google Documents, Spreadsheets, Forms, Presentations & Drawing

Google Docs allows users to create documents, spreadsheets, presentations, and forms that are stored online and accessible from any computer. Google Docs can help you streamline and organize your tasks and responsibilities. By implementing Google Docs, you will see a direct increase in your productivity and a decrease in your stress level. All the Google tools are free and technophobe friendly. Use the password provided to registered workshop participants to access:


  1. Our workshop backchannel for May 11, 2011
  2. Our workshop backchannel on Chatzy (for both face-to-face and virtual participants)
  3. Our workshop Ustream.tv Channel (for virtual participants only)
  4. Our Google Docs Skill List
* Please see the bottom of this document for attribution information and links.

Welcome to the World of Google!


The Crib Sheet: Google Docs

The Tool: Google Docs


10 Tips on Docs from the APPS EDU Training Center


Overview (with Links to Help Pages):
Resources for Teachers:

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
Sample Forms (and Spreadsheets):
Resources for Using Google Forms (from GCT Jason Borgen at Portical.org):
Additional GCT Resources:
Google Docs Templates for Students and Teachers
Interactive Overview
    • 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.)

    • Drawings (These are also included in Google Docs, but we won't cover this).


Core "Magic">> Sharing

    • 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.



  • More From CLS (with similar openings, but different specifics):





Form Templates used in **R.S.U. #19**.
If you are logged into your **Google Account**, these form templates will automatically copy into your Google Docs Dashboard.

Many of the forms are designed to work with an iPod Touch. For more information about educational uses of that device, go to http://sites.google.com/site/kernkelley/itouch.

Test and Quizzes* Self Grading Multiple Choice Quiz - Provide a link to this form or embed it into a website. This template scores the answers as soon as students complete the quiz.

Administrative Forms * Administrative Observation Walkthrough - This is an teacher observation form that the administrators can use. The iPod Touch provides an easy way for data entry, then they can complete the observation in the spreadsheet once complete.
  • Technology Survey - This is the survey we give to staff and students at the beginning of the school year.
  • Three Minute Administrative Walk-Through - This is an teacher observation form that the administrators use in my district. The iPod Touch provides an easy way for data entry, then they can complete the observation in the spreadsheet once complete.
  • Homework Check - This is a detailed form that teachers input student scores and the spreadsheet coordinates the results based on which assignments the teacher was using.
  • Discipline Form - This forms allow teacher entry of disciplinary actions. Note: We use avatar names when entering information.

Miscellaneous * Science Fair Judging Form - This is the scoring form used in a middle school science fair.

Don't miss the fantastic templates provided by Todd Roth.
MISC
The Google Docs Blog is also valuable for picking up the latest tips, tricks, and new features.
Esther Wojciki's Docs and Spreadsheets in the Classroom
3 Getting Started Guides for Beginners
A Great Comparison of all Google Docs components
Digital Toolbox: Google Docs
10 Google Forms Ideas for the classroom -
Using Google Docs in the Classroom: Tips and Tricks
20 Ways To Use Google Docs in the Classroom
Google Docs Classroom Ideas Wiki
Google Docs Keyboard Shortcuts
Google Wants YOUR Docs Ideas- click here to submit and see examples.

Interviews:
A District Administrator Talk About Google Docs and the impact on the classic research paper
Interview with Special Educator on using Google Docs
Sample Permission Slip for Google Apps for Education (includes Docs and other Web 2.0 tools)

Bronx, NY Middle School, CIS 339 Uses Google Apps as "glue" for school.
Check out how they use Google Docs

Link Library:

3 Getting Started Guides for Beginners
NEW! Educational Spreadsheet Gadgets
How to Make a Self Calculating Survey - Collete Cassinelli
A Great Comparison of all Google Docs components
Official Google Docs Blog
Google Docs for Educators
Using Google Docs in the Classroom
Google Docs Templates
Digital Toolbox: Google Docs
Read any web document in Google Docs -This extension (download link) lets you read online documents directly in your Google Docs account with a simple right click.
10 Google Forms Ideas for the classroom - provides template copies for each form by Tom Barrett
Using Google Docs in the Classroom: Tips and Tricks
20 Ways To Use Google Docs in the Classroom
Snag a Table of Contents, Dictionary or Thesaurus for your Google Doc
Google Apps Docs Interactive Tutorial
Google Docs Classroom Ideas Wiki
Teach Collaborative Revision with Google Docs
Educator's Guide- Teaching Revision with Google Docs
Esther Wojciki's Docs and Spreadsheets in the Classroom
Google Docs Blog
Google Docs Keyboard Shortcuts
Insert Footnotes
Google Wants YOUR Docs Ideas- click here to submit and see examples.
How to Create a Self Grading Quiz Using Google Forms
New! Drawing Tools
Create Children's Books Using Sites and Drawing Tools Example 1 Example 2
Research Projects- Putting it all together

Even more!

32 Interesting Ways to use Google Docs in the Classroom

Google Presentation

iGoogle

Google Labs
Hands-On Activities

Activity 1:
How might Google Docs be valuable to an educator?

  1. In a small group, create a document, presentation, or spreadsheet to illustrate your answer. Your Try to think of at least 5 ways you could use these tools in the next 6 months!
    Details
    1. Choose a team leader and have that person create and share the document with the other members of the team.
    2. Share the file (doc, presentation, or spreadsheet) with your whole team.
    3. Include your instructor, too: wesfryer@gmail.com
    4. Teams have 15 minutes to collaboratively complete the task.
    5. 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
    • Using a presentation for presenting data.
    • Using a spreadsheet for sharing and analyzing grades.

Activity 2: Forms Fun! Who are We?
Complete this survey
  • View the results.
  • Demonstration: Create and publish a chart.

Activity 3: 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:
  1. Create a and name new form. (Lost? Watch this video.)
  2. Select the appropriate question types.
  3. Apply a theme of your choice.
  4. Test your form out. Get at least ten people to respond to your form.
  5. Use Form > Show summary of responses to get a quick overview of
    how people responded.
  6. 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 FormAdvanced: A Self-Grading Quiz
    • Attendance
    • Team Smart Goal
    • Strategies and Action Steps
    • Responsibilities
    • Timeline
    • Evidence of Effectiveness

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


YouTube Video: Teachers and Principals Talk About Google Docs

YouTube Video

YouTube Video

YouTube Video


YouTube Video


Teach Collaborative Revision with Google Docs

external image writing_cover.jpgRevision 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.


Teach Collaborative Revision with Google Docs

external image writing_cover.jpgRevision 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.
ATTRIBUTION: These resources were adapted from those created for the Google Docs session of the 2010-11-14 Google Workshop for Educators at iNOCAL, Glendale, AZ by Lisa Thumann and Sallie Hill.