The
Tool: Google Docs Docs Templates for Students and Teachers Don't miss the fantastic templates provided by Todd Roth. What is Google Docs?
Interactive Overview (with Links to Help Pages): Activity 1: Let's make an Oregon travel promotional Doc or Presentation In a small group, create a document, presentation, or spreadsheet
to illustrate your answer. One group member should create the file and add the others as collaborators Be sure to publish your project and feel free to add me as a collaborator A question to ponder after this activity: How can Google Docs be used at you site or in your program? Example answers include:
Activity 2: Who are we? Complete this
survey. View the results here. Demonstration: Create and publish a chart. Demonstration: Self Grading Quiz (Your answer to the last question on the survey will be graded!) Sample Forms (and Spreadsheets) Used By Administrators:
Create a
form for collecting data. Examples include:
BONUS Activity: Create a self-grading quiz! (Time permitting) In a small group, create a three question quiz using a Google
Form. Solicit sample answers from other participants. Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column.) Fill Down so that the IF formulas you've written can "grade" all the responses at once! Advanced: Create a SUM formula to total up the total score for each person that took the quiz. Then create another formula to calculate the percentage. Finally, create a nested IF formula to convert the percentages to letter grades! Time Permitting: Share your quiz with the lead learner. Links to the quizes will be added below. More Sample Uses of Google Docs
Forms (for Administrators) Sample Forms (and Spreadsheets) Used By Administrators:
Resources for Administrators Using Google
Forms (from GCT Jason Borgen at Portical.org):
Additional GCT Resources for Administrators:
Even More Ideas...
Http is an insecure protocol. Https is
secure. Be sure to always use https when accessing Google Docs on a
public network (or any network for additional security). Method 1 - Simply type an "s" at the end of "http" when you connect to Google Docs to force a secure connection. You can then bookmark https://docs.google.com for future secure access. Method 2 - For users of Gmail, go to Settings, look for Browser Connection, and select "Always use https" - then always launch Docs from the link at the top of the Gmail page. This will force Docs to open using https as well. Method 3 - For administrators of a Google Apps: Education Edition domain, you can require all users in the domain to use https by Enabling SSL for your domain. 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 Official Google Docs Blog Google Docs for Educators Using Google Docs in the Classroom Google Docs Templates Digital Toolbox: Google Docs 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 Blog Google Docs Keyboard Shortcuts Insert Footnotes Google Wants YOUR Docs Ideas- click here to submit and see examples. How to Create a Self Grading Quiz Using Google Forms New! Drawing Tools Create Children's Books Using Sites and Drawing Tools Example 1 Example 2 Research Projects- Putting it all together Interviews: A District Administrator Talk About Google Docs and the
impact it has had 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. Check out how they use Google Docs Resources for Administrators 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 for
Administrators: A Sample Teacher
Observation Form (Click on the "entry" tab.) - From GCT Kern Kelley Staff Book of The Month Club Using Google Docs - From GCT Melanie Holtsman's Principal A Blog Post About Using Forms For A Mid-Year Principals' Survey - From GCT Melanie Holtsman's Principal |