docs

Google Docs
Activity 1:  Who are we? 
  1. Complete this survey.
  2. View the results.
  3. 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)
  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!
  6. Time Permitting: Share your quiz with the lead learner. Links to the quizzes will be added below.

Ċ
CUEtoYOU PD,
Jun 23, 2010, 12:19 AM
Ċ
CUEtoYOU PD,
Jun 23, 2010, 12:19 AM
Comments