Google Docs

http://bit.ly/gtadcdocs

or�http://tinyurl.com/gtadcdocs

or

http://sites.google.com/site/gtaresources/events/2009-12-09/docs

December 2009

Lainie Rowell

Google Certified Teacher

Santa Monica, '07

Ronald Ho

Brilliant Googler

Google Docs PM

The Plan...

Intro

Ten Tips in Ten Minutes

Hands-On

Wrap-Up

​

​

Google Confidential and Proprietary

Google Docs

Documents - Presentations�Spreadsheets - Forms

Google Docs vs. "That Other Office Suite"

Google Confidential and Proprietary

Ten Tips in Ten Minutes

Please share what tips you like best and (more importantly) add your own tips at...

http://bit.ly/gtadcdocsmod

Google Confidential and Proprietary

1. Drawings and Diagrams

Create your own drawings and diagrams in Google Docs and use them in your text documents, spreadsheets and presentations.

Google Confidential and Proprietary

2. Equation Editor

Easily insert mathematical equations into your documents.

​

Google Confidential and Proprietary

3. Bulk Upload

Upload multiple files quickly to your Docs list.

​

Google Confidential and Proprietary

4. Shared Folders

Sharing a folder with someone is an easy way to give someone access to the docs within your folder.  �My folders > Share > Invite people...

​

Google Confidential and Proprietary

5. Functions:  GoogleLookup & Google Finance

Using the Web, the GoogleLookup function attempts to find the values for straightforward facts about specific things. 

Learn more here and here. 

Google Confidential and Proprietary

6. Define & Translate

With Google Docs, you can translate words within a document, or an entire document, into one of over 40 languages.

​

Google Confidential and Proprietary

7. Secure Link

Use https://docs.google.com instead of http://docs.google.com. The extra 's' means 'secure'; all traffic is encrypted. The only down-side is it's a little bit slower.

Thanks to Mark Wagner for sharing this one.

Google Confidential and Proprietary

8. Yolink

​

 Find, Save and Share

Google Confidential and Proprietary

9. Teacher-Submitted Docs

Examples of Google Docs in Education

Google Confidential and Proprietary

10. map a list

​

Thanks to Dennis Grice for sharing this one.

Google Confidential and Proprietary

More tips available at

http://www.google.com/google-d-s/whatsnew.html

​

Hands-On

Tell us about yourself: �Spreadsheet with a Form & Map A List�

• Complete this survey. - http://bit.ly/gtadcform
• View the map. - http://bit.ly/gtadcmap
• Collaborate on the form. - http://bit.ly/gtadcspreadsheet

Google Confidential and Proprietary

What's new in Google Docs?

Google Docs overall

• Templates - Students & Teachers category!

​

​

​

​

​

​

​

• Drawings

From: Cnet Webware and Google Operating System

Google documents

• Styles
• Footnotes
• Table of Contents
• Print Preview
• Look up word (definition, synonyms, encyclopedia)

Google documents

• Tools --> Word Count

• Edit --> Document Styles

Google spreadsheets

• List view and Mobile view
• Sheet Protection
• XLSX support
• Form summary page
• Data validation
• Form Themes
• New gadgets:
• flashcards
• word search
• tree map
• ...etc

​

​

​

Google presentations

• Insert YouTube Videos
• Incremental reveal 

Helpful Tips

Most slides borrowed from Erica Hartman.

Quick Tips

• Title your documents when you start them
• Include name or ID in the title for convenience
• Organization in your Documents List is key!
• Use folders, stars and saved searches

​

​

​

​

​

• Learn advanced search --> "Show search options"

​

​

​

Organizing documents

• More Google Docs tips here.

Collaboration Quick Tips

Templates

• Create your own templates - share them as view-only and have students "Create new copy" from the File menu

Teach Revisions

• Screencast on using google docs for peer revision
• Student sample 
• Teach students to give constructive criticism by inserting comments and footnotes
• Collaboration in real time

Collaboration

• Insert lines to distinguish editing areas
• Have students each take a different color text

​

Google Templates Video

• Screencast on using templates with students
• Lab Report Template 

Google Presentations

• Chat during presentations to ask questions
• View together
• Sample presentation: New Methods in Research

Helpful spreadsheet functions

• GoogleLookup() - use Google search to return results for values you specify: =GoogleLookup("New York City", "population"), see here for more examples
• ImportRange() - from other spreadsheets, see here
• ImportHTML() - import from the web, see here to learn how
• Magic Fill - pulls from Google Sets, highlight cells, hold down Ctrl (windows) or Option (mac) and drag down

Even more spreadsheet tips

• Settings - make sure to edit locale and time zone for time stamp
• Google search inside a spreadsheet. For words/phrases that are unfamiliar, just highlight it, right click and choose "Search the Web." The results will open in a new browser window
• Create forms in a jiffy - Choose New --> Form to create new forms straight from Docs Home
• Autosave for spreadsheets and forms
• Use Ctrl + F to search for and replace text across your entire spreadsheet

Charts and Gadgets

• Spreadsheet sample
• Screencast on inserting charts and gadgets in spreadsheets

Spreadsheet gadgets tips

• Used to visualize your data
• New gadgets in the Picker!

​

Spreadsheet Forms

• Study Guides - student generated
• Curriculum -  teachers and can collaborate to write and update curriculum
• Rubrics - when written in spreadsheets can become live forms
• Gather information using Forms: evaluations, t-shirt orders, quizzes, field trip info

• Elizabeth Davis shares a Blog Rubric Form

Wrap-Up

 Questions�

&

​

Moderator Results

http://bit.ly/gtadcdocsmod

Google Confidential and Proprietary

Bonus Tip: Mailinator

Thanks to Dennis Grice for sharing this one.

Google Confidential and Proprietary

Thanks to Brian Mull for sharing this one.