GWE_Docs_RCGoogle Workshop for Educators - GWE_Docs_Aurora Integration Resources
Google Resources
Video Resources
|
|
Activity 1: Google Docs in Action
Read the following editorial text by Anna Quindlen.
Each team will complete two of the following tasks:
- Doc: Search Google
Image to symbolize your interpretation of the topic of the piece. Copy the link to your image to the document. Write a brief explanation of how this
picture symbolizes your interpretation of the text.
- my email: carcherdavison@gmail.com
- Presentation: Copy and paste three quotes/passages that you have questions about from
the column. Use one slide per question.
- Spreadsheet: Survey five people to find out the longest number of pages they've ever written. Create a spreadsheet (bonus points for creating a chart or graph).
- Teams have 10
minutes to collaboratively complete the tasks.
- 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 2: Who are we?
- Complete this survey.
- View the results.
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 3 question form that you
could use as a pre-reading or post-reading questionnaire for the article above.
- 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 for your book 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.
|
|
|