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): 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 - see below...) NEW: Drawings are also included in Google Docs (but we won't cover these). Google Docs Help Center (For getting started on your own...) Here's the Core "Magic" (or what makes Google Docs better than a desktop office suite):
Activity 1: How can Google Docs be used at your site or in your program? In a small group, create a document, presentation, or spreadsheet to illustrate your answer. Example answers include:
One group member should create the file and add the others as collaborators. Publish the file and add the lead learner as a collaborator. Links to the files will be added below. One member of each small group will present the file to the large group. Complete this demo survey. View the results. Demonstration: Create and publish a chart. Demonstration: Self Grading Quiz (Your answer to the last question on the survey will be graded!) Activity 3: Forms for Teacher Observation or Data Collection Create a form for collecting data. Examples include:
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 as a collaborator. One member of each small group will present the form to the large group. Activity 4: 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. BONUS: 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 |