Using Google Docs for Rubrics

At last year’s annual MassCUE conference, I went to a session presented by Katrina Kennett (@katrinakennett). Her presentation focused on how to use Google Docs to create rubrics, and she outlines the process in this video:

YouTube Preview Image

She further explains her process and goals in this blog post.

I was energized by the presentation and immediately implemented Google Spreadsheets to create my own rubrics.

You can create self-grading rubrics if you like, or you can create rubrics that tally the number of rubric points and convert it to a grade. The first might save a little time, but the second allows you more control over the final grade.

I had a little trouble figuring out what formula to use to convert total rubric points to grade. For instance, I have long used the ELA rubrics published by Greece, NY schools. Jay McTighe introduced me to these rubrics many years ago when he visited a school where I was teaching at the time. As a result of his presentation, I came up with a formula for converting these 30-point rubrics to 100-point grades.

What I can’t seem to do with my rubric is determine what formula to put in one of the cells that will convert, say, 25 points to a 90 on an essay. If you can help me with that, please chime in below or email me at dana dot huff at gmail dot com. I had to disable my contact form, unfortunately, because of a barrage of requests for advertising and guest posts. Very frustrating and a subject for a separate rant some other time. I think there should be a formula that can do this, but I wasn’t able to hit the right one. Update: Please see the comments. I have tested the formula suggested in the first comment with a few different configurations, and it works.

I am sharing a link to a Google rubric I have created combining Katrina’s method with the Greece Schools’ rubric. This Google rubric is view only, so if you want to edit it, you will need to make a copy of it. This rubric is Greece’s literary analysis rubric. As you can see, the rubric has five criteria: meaning, development, organization, language, and conventions. It also has six levels of performance.

The easiest way to see how all of this works is to look at the rubric, make a copy of it, and see what’s under the hood by clicking on cells, where you can see the various formulas and conditional formatting rules.

After reading a student’s writing, I determine which cell best describes their level of performance for each criterion and type an exclamation point (!) at the end of the description. Using conditional formatting, I have set up the spreadsheet so that an exclamation point tallies the points for each criterion in the Rubric Score column and turns the background of the selected cell purple so that students can clearly see where their level of performance falls on the rubric. A cell at the bottom of the Rubric Score column totals the points for all the criteria. I then use the chart I shared in my blog post about rubrics and how to convert point-based rubrics fairly (see link above). As I said before, I have not figured out how to get my rubric to convert these points to a numerical grade.

Katrina assigns weights to the different parts of her rubrics, so she was able to set up an auto-grading feature when she selects cells. Here is a link to her rubric so that you can see how it works. As with mine, this rubric is view only, so you must make a copy of it before you can edit it for your use; however, you can click on the cells to see her formulas. As you can see, her use of the Google Rubric is much more developed and more sophisticated than my own.

What is the advantage of using Google Rubrics over paper ones, especially given that I’m not making as sophisticated a use of them as Katrina is?

  • My classroom is almost completely paperless.
  • We are already using Google Docs in my classroom, and using Google Docs for rubrics enables me to put rubrics and docs in one place.
  • Using Hapara, I can create a Google Spreadsheets Workbook for each student and copy each rubric to their workbooks as I create them. They will then have access to each rubric in one workbook. At the end of the year, or even at more frequent intervals, they can look for trends.
  • I can share links to their rubrics in my comments on their essays themselves (in Google Docs) and also in our open gradebook comments area (we use PowerSchool).

Of course, if I can figure out the formula I need to convert rubric points to a grade without weighting, then I’m all set.

Feel free to ask questions (or help me out with my spreadsheet formula) in the comments.

Related posts: