Using spreadsheet forms as a rubric for grading

Students can create a spreadsheet form to evaluate their own blog posts. The teacher and student use the form as a rubric to grade the student's blog posts.

Instructions:

1. Ask your students to create a spreadsheet form to evaluate their blog posts. 2. Make a new copy of this survey and share with students as viewers, so they can self-evaluate but not change their grades. 3. Both students and teachers fill out a form for each student's blog post. 4. Use the average function in a spreadsheet to determine the final score for each student's blog post.

Examples:

Form: http://spreadsheets.google.com/pub?key=pxNTk-FNJEWzyrSOT1mkeSw

Spreadsheet: http://spreadsheets.google.com/pub?key=pM_ZE5BS0SgrdLzKT_UIUAA

Matt is a Docs & Drive expert and author of this help page. Leave him feedback below about the page.

How helpful is this article:

Feedback recorded. Thanks!
  • Not at all helpful
  • Not very helpful
  • Somewhat helpful
  • Very helpful
  • Extremely helpful