Embedded Files
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.
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.
- Need a Google Account? Please create one!
- The free Google Chrome web browser is recommended (or FireFox - Friends Don't Let Friends Use IE)
- Misc Resources: Online Stopwatch - GMail Trick for Student Emails - Google Search Story from Maine - Scratch Camp in Edmond - Flickr Creative Commons Images
- Google Docs / Google Drive
- Our Google Docs Skill List
Past workshop links (not used 18 Nov 2013)
- Please sign in and share your Google Account Email
- Our Collaborative Groups Today
- Share Responses to Videos
- Share Your Survey - Take Surveys from Others
- Our 5 Photo Story
- Post-Workshop Evaluation Form
* Please see the bottom of this document for attribution information and links.
Hands-On Activities
Activity 1:
How might Google Docs be valuable to an educator?
Welcome to the World of Google!
Welcome to the World of Google!
- 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
- Choose a team leader and have that person create and share the document with the other members of the team.
- Share the file (doc, presentation, or spreadsheet) with your whole team.
- Include your instructor, too: wesfryer@gmail.com
- Teams have 15 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
- 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
- Get into a group of 2 or 3 people.
- 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
- Have another person in your group use the website 5 Card Flickr to select Photos for a 5 Photo Story. (Make your selections collaboratively.)
- Copy the links to each photo and insert them into your document.
- Write creative paragraphs to accompany each photograph. Each paragraph should FOLLOW each photo.
- Add an appropriate title at the top of your document.
- Add your author credits (with at least your first names, last names and links are optional) at the bottom of your story
- Change the sharing settings for your story to Public: Anyone with the link.
- 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:
- 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 at least ten 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
Even MORE Presentation!
Overview (with Links to Help Pages):
Resources for Teachers:
- Overview for Educators (presentation)
- Google Docs For Educators
- Google Docs: The Basics
- Google Docs: Tips and Tricks
- Ideas for the Classroom
- Google Docs in Plain English (video)
- DEMO TEMPLATE: Custom Walkthrough Forms (with Individual Reports!)
- TIP: Quick and Easy Mail Merge Using Google Docs
- ADDED: Quick and Easy IF Formulas for Grading Google Forms
- Friends/Administrators without Docs can try it too: Demo
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
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
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):
- 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 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:
- A Sample Teacher Observation Form (Click on the "entry" tab.) - From GCT Kern Kelleybegin_of_the_skype_highlighting end_of_the_skype_highlighting
- More Ideas (Collected by Colette Cassinelli)
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"
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 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
- 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.
- Response to Literature Scoring Form - This form collects literature response scores and coordinates the results.
- 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
- Science Fair Judging Form - This is the scoring form used in a middle school science fair.
- 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.
- Vocabulary Flashcard builder - This spreadsheet creates a custom flashcard sheet.
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.
3 Getting Started Guides for Beginners
A Great Comparison of all Google Docs components
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.
Teach Collaborative Revision with Google Docs
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:
- With a Little Help From My Friends: The Gifts of a Writing Buddy
- Writing's Top 10 Tips for Revision
- Collaborative Revision Checklist
- Individual Revision Checklist
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:
- Our workshop backchannel for May 11, 2011
- Our workshop backchannel on Chatzy (for both face-to-face and virtual participants)
- Our workshop Ustream.tv Channel (for virtual participants only)
- Our Google Docs Skill List
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
Using Google Docs in the Classroom
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 Keyboard Shortcuts
Google Wants YOUR Docs Ideas- click here to submit and see examples.
How to Create a Self Grading Quiz Using Google Forms
Create Children's Books Using Sites and Drawing Tools Example 1 Example 2
Research Projects- Putting it all together
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.
Page updated
Google Sites
Report abuse