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.

Welcome to the World of Google!




The Crib Sheet: 

The Tool: 

GWE Docs


Even MORE Presentation!

10 Tips on Docs from the APPS EDU Training Center

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 (even easier FREE solution: Flubaroo)

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:
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).
Google Docs Help Center (For getting started on your own...)
See Also: Getting to know Google Docs: The new version of Google documents
Core "Magic"
Google Docs Help Center (For getting started on your own...)
See Also: Getting to know Google Docs: The new version of Google documents
Great For...
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.
Using a form to collect data, administer surveys, score rubrics, or conduct walk-throughs.
More from CUE's Google Workshop for Administrators
More from the GTA for Administrators
More From CLS (with similar openings, but different specifics): 
Google Docs for PLCs
Google Docs for Subgroups
Google Docs for Classroom Management


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 


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.
  • Self Correcting Spelling Quiz - This form allows a teacher to enter 20 words and once the quiz is completed, it self corrects and analyzes the data. 
  • Virtual Inbox - A form that collects the web address of students work and organizes it by school and grade. 

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 
  • Story Board - Used by student groups to write and produce a video project.  
  • Booklist Template - Used by teachers to keep track of the names and quantity of books read by students. 
  • Word Find Template - Not a form, but spreadsheet where the user can create a custom word find.


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!

Google Presentation



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: 5 Photo Story with Google Docs
  1. Get into a group of 2 or 3 people.
  2. Have 1 person create a new Google Document and share it (with EDITING permission) between the three people in your group. Also share it with your instructor: wesfryer@gmail.com
  3. Have another person in your group use the website 5 Card Flickr to select Photos for a 5 Photo Story. (Make your selections collaboratively.)
  4. Copy the links to each photo and insert them into your document.
  5. Write creative paragraphs to accompany each photograph. Each paragraph should FOLLOW each photo.
  6. Add an appropriate title at the top of your document.
  7. Add your author credits (with at least your first names, last names and links are optional) at the bottom of your story
  8. Change the sharing settings for your story to Public: Anyone with the link.
  9. Submit the link using this Google Form.

          Activity 4: 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: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


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.



Resources from May 2011 workshop:
  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
Comments