On the frontlines – teaching students; teaching teachers. A source for EdTech tips, tricks, and solutions.

Tuesday, September 9, 2014

Make Goobric Count for You

I have been using Doctopus and Goobric (click link to see the walkthrough) extensively this semester already. One of the things that I was struggling with was that Goobric doesn't automatically add up the scores from a rubric so that I can easily enter the grade into a gradebook.

I was trying forever to figure this out, but then I realized how silly I was being. You can simply set up a SUM formula for the columns of the rubric so that it will automatically add up all of the elements of the graded rubric.

Create the formula:

  • Go to the column that says grade (create when you run Doctopus)
  • Goobric adds columns based on the categories of a rubric you assign to the document
  • In the grade column, enter the formula (or change based on the needs of your rubric):     
    •  =SUM (l2:r2) - I typed in each cell, just so you can see the range that this formula will do
  • Since my rubric is scored on columns l, m, n, o, p, q, r, I need to add those columns together **or however many columns you have for your rubric**
    • My rubric has 6 categories, so there are 6 cells that I am adding together
    • If your Goobric has 4 categories, your formula will look like: =SUM (l2:o2)

Even more magic:

Now, instead of entering this formula for every row (changing l2 to l3 etc.), there is a great trick to replicate that formula for every row. 

In the lower right hand corner of the cell with the grade, you have a blue box. Click the blue box and drag it down the column till the last student on your roster, and it will replicate that formula for every row. You'll see in the illustration that each row that has grades from the rubric will be added up in the grade column (J).  

This will save you time trying to add up each element of the rubric. And if you set up the formula before you grade it, your grade (sum) will show up even if you aren't in the spreadsheet. 

1 comment:

  1. Thank you for this tip! I'm brand new to Goobric...I had explored Orange Slice first, which seems great! But I love how Goobric puts itself right into the student's work automatically, which Orange Slice doesn't do...I just wish Goobric would automatically calculate the final score like Orange Slice! Thanks again, this does help.