“So You Think You Can Google!”
Learn how to work smart using Google Forms and Docs. Get immediate feedback with Google Forms and
utilize the collaboration and sharing features of Google Docs. Identify innovative ways educators are using
these free apps to promote student learning. From administrator to student, there is something for everyone.
Utilize Google Docs as a collaborative tool
Learn how to create, access, and share documents anywhere
Develop easy to use assessments (forms)
http://tinyurl.com/thinkgoogle (url was shortened using www.tinyurl.com)
Show survey responses to group
Spreadsheets: collect/track data, create formulas, share spreadsheets
Forms - see entries in spreadsheet form, generate charts/graphs
Google Docs Perks:
Simple to use
Accessible from any computer, smart phone
Accepts most popular file formats, including doc, PPT, xls
Convenient collaboration – real time, 24/7, chat feature
Auto save and revision history
Choice of sharing modes:
o Private - all files start out private
o Anyone with link (you email link to large group)
o Public (can reset link)
You set type of Access: view or edit
Publish to the world on website, wiki, blog - can also un-publish at any time.
Attendance: Google template by Tammy Worcester
Lesson Plans: A Google example about the Scientific Method
Sample: BOY Survey WHAM 5th Grade Information Form
Data Collection & Analysis
Sample: Elements All Around Us Form
Sample: Elements All Around Us Spreadsheet
Excel Activity: Sample: Math Probability Spreadsheet
Collaboration With Peers
Editing Text Documents
Sample: Interactive PowerPoint
Sample: Expanding Sentences Word Processing
Sample: Instructor Teaching Preferences for AB Cohort Spreadsheet
Sample: ActivBoard Inventory Form
Sample: ActivBoard Inventory Spreadsheet
Sample: Professional Development Contact Hours Form
Sample: Professional Development Contact Hour Spreadsheet
Sample: ActivBoard Cohort Registration Request Form
Sample: ActivBoard Cohort Registration Request Spreadsheet
Sample: Professional Development Course Evaluation Form
Sample: Professional Development Course Evaluation Spreadsheet
2 Ways to Create Forms
From the Docs list
From the spreadsheet
Google Docs -- Size Limits
o 512,000 characters, usually about hundred pages depending on things like font size.
o Uploaded files converted to Google documents format can’t be larger than 1MB.
o 400,000 cells, with a maximum of 256 columns per sheet.
o Uploaded files converted to Google spreadsheets format can’t be larger than 1MB and need to be
under 400,000 cells and 256 columns/sheet.
o Presentations created in Google Docs can be up to 10MB or about 200 slides.
o Uploaded files converted into Google presentations format can also be up to 10MB.
Drawings: They say that they never have seen a drawing that was too big!
Files (1 file or more) have an upload limit of 1GB.
200 viewers and editors (combined) may share a doc or file, or you can make your doc available to
anyone by changing its visibility option.
50 may edit and view a spreadsheet, document, or drawing.
10 people may edit and view a presentation or a document in the older version of Google documents
People who can edit a doc will also be able to share it with additional people. To remove that ability,
click Change next to 'Editors will be allowed to add people...' before you click Share.
By default, everyone you share a doc with will get an invitation by email. If you'd rather not notify
them, un-check the 'Send notifications' box. They'll have access the next time they sign in.
Post Survey-Share Ideas
http://tinyurl.com/ideaswap (url was shortened using www.tinyurl.com)
Show spreadsheet survey responses to group
Resources - Help at your Fingertips
Getting to Know Google Docs: Getting Started Guide Basics
Getting to Know the New Google Docs
Introducing a New Google Docs
Google Docs in Plain English
Google Apps Quick Tour
Using Forms in Google Docs
Using Google Docs in the Classroom: Simple as ABC
Google Apps Education Training Center
Google Docs Community Video
Google Docs Template Gallery
Google Teacher Academy Resources
Tammy Worcester Google Docs Self Check Quizzes
A Love Letter (Video and Tips & Tricks for using Google Docs)
Patty Fraser, Instructional Technology Facilitator
East Baton Rouge Parish School System
Cheryl Donnelly, 5th Grade Teacher
Westdale Heights Academic Magnet