docs

2015 - 2016 Events‎ > ‎Google Workshop For Educators Rapid City, SD 2010-02-01‎ > ‎

Google Docs

GWE_Docs_RC

Integration Resources

Ways to use Google docs in the classroom

Google Resources

Video Resources

Activity 1: Who are we?

Complete this survey.
View the results.
Demonstration: Self-grading Quiz (Your answer to the last question on the survey will be graded!)

Activity 2: Google Docs in Action

Each team will be assigned one of the following tasks:

Doc: Write an essay or epic poem about your favorite teachers (or students) (bonus pts for including images)

Presentation: Create a visual presentation about what you would do with a million dollars (bonus points for multimedia)

Spreadsheet: Create a spreadsheet of 5 different fun stats on the people in your group (bonus points for creating a chart or graph)

Teams have 10 minutes to collaboratively complete the task.
Make sure you share the doc with everyone on your team and also with carcherdavison@gmail.com
One member of each small group will present the file to the large group in 2 min or less.

Activity 3: Forms

Forms are one of my favorite tools in Docs. You can use it for so many things such as pre-test, post-tests, data-collection, meeting minutes, simple answer keys for quick grading, sign-up, and more.

Create a form that you could use in your classroom/location in the near future.
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.
Make sure you share the form with everyone on your team and also with carcherdavison@gmail.com
One member of each small group will present the file to the large group in 2 min or less.

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 quizzes will be added below.