### docs

#### GWE_Docs_RC

Integration Resources
Video Resources

Activity 1:  Who are we?
1. Complete this survey.
2. View the results.

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)
1. Teams have 10 minutes to collaboratively complete the task.
2. Make sure you share the doc with everyone on your team and also with carcherdavison@gmail.com
3. 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.
1. Create a form that you could use in your classroom/location in the near future.
2. Send the "live form" link to colleagues so they can fill out your form.
3. Share the results with colleagues or publish them as a web page.
4. Make sure you share the form with everyone on your team and also with carcherdavison@gmail.com
5. 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)

1. In a small group, create a three question quiz using a Google Form.
2. Solicit sample answers from other participants.
3. Create an IF formula for each question to "grade" the question. (Each IF formula needs to be in a new column.)
4. Fill Down so that the IF formulas you've written can "grade" all the responses at once!
5. 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!