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.

CLICK HERE FOR OUR SHARED DOCUMENT on 18 Nov 2013

Hands-On Activities

Activity 1:

How might Google Docs be valuable to an educator?

Welcome to the World of Google!

  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
  6. how people responded.
  7. 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

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:

Google Docs for Educators

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

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"

Sharing

Revision History

Publishing

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

http://sites.google.com/site/kernkelley/itouch.

Test and Quizzes

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

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

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

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.