Google Docs



















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).
  1. Teams have 10 minutes to collaboratively complete the tasks.
  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 2:  Who are we? 
  1. Complete this survey.
  2. 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.
  1. Create a 3 question form that you could use as a pre-reading or post-reading questionnaire for the article above. 
  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 for your book 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!
  6. Time Permitting: Share your quiz with the lead learner. Links to the quizzes will be added below.
Comments