Navigation

  • Handouts Home
  • Videoconference PD
  • Keynotes
  • Workshops
  • Breakout Sessions
  • Mapping Media to Common Core
  • Wes' eBooks
  • Booking Inquiry
  • Sitemap
  • Recent site activity

Follow Wes

blog
twitter
facebook
Google+

spacer

spacer

Other Links

  • Wes' Podcast
  • Fuel 4 Edu Change Agents
  • Wes' Archived Tweets
  • Videos by Wes
  • iPhone Apps
  • Mac Apps
  • Win Apps
  • TxTIP
  • K-12 Online Conference
  • Balanced Filtering
  • Unmasking Digital Truth
Workshops by Wesley Fryer‎ > ‎Handouts‎ > ‎

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.

  1. Please sign in and share your Google Account Email. ( Need a Google Account? Please create one!)
  2. 3 Goals for Today: Inspire you. Not Scare You. Not Overwhelm You. (Last one is always most difficult when discussing Google tools!)
  3. The free Google Chrome web browser is recommended (or FireFox - Friends Don't Let Friends Use IE)
  4. Misc Resources: Online Stopwatch - Wes' photo share - Viber App - ChefTap - OnStar - GMail Trick for Student Emails - Google Search Story from Maine - Scratch Camp in Edmond - Flickr Creative Commons Images
  5. Our Collaborative Groups Today
  6. Share Responses to Videos
  7. Share Your Survey - Take Surveys from Others
  8. Google Docs / Google Drive
  9. Our Google Docs Skill List
  10. Our 5 Photo Story
  11. Post-Workshop Evaluation Form
* Please see the bottom of this document for attribution information and links.

New Google Video Resources:

  1. Exploring Google Drive
  2. Google Docs Overview
  3. Training Videos for Google Apps
  4. Google Docs Training Videos
  5. YouTube for Schools

Welcome to the World of Google!




The Crib Sheet: 


Google Docs
 Click here for Example Doc!
 Click here for example Spreadsheet!
 Click here for example Presentation

The Tool: 

Google Docs

The Presentation:

GWE Docs

GWE Docs

Even MORE Presentation!

10 Tips on Docs from the APPS EDU Training Center

10 Tips on Docs from the APPS EDU Training Center

Overview (with Links to Help Pages): 
  • GETTING STARTED IS AS EASY AS ABC- THE BASICS
  • Documents
  • Presentations
  • Spreadsheets
  • Forms
  • Overview Presentation (From Google For Educators - Google Docs)
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
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):
  • 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 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): 
gipoco.com is neither affiliated with the authors of this page nor responsible for its contents. This is a safe-cache copy of the original web site.