Automatic Rubrics with Google Sheets

Yeah, I know lots of stuff from Google.  Our school had “Gone Google” so I’ve been trying to find as many tools for our instructors as possible to help make their jobs a bit easier (and mine as well).

Most of us whether we know it or not use rubrics when we grade reports and papers.  That rubric may be in our head instead of paper, but we still use one.  Unfortunately administrators and students can’t see what’s in your head or maybe it’s good they can’t.  But students do much better when they understand the yardstick they are being measured against. That’s where Alice Keeler’s add-on for Google Sheets can help out.  She has developed an add-on that will help you create a simple but effective rubric for any subject that will allow administrators, other teachers but most importantly students see what you are using as a standard for grading their research papers, reports and projects.

Go to

She has provided easy to understand instructions taking you step by step through the process of building your first rubric.  I suggest bookmarking it just in case you need to reference it again later.

I hope this helps make your job a little easier.  Here is a screen capture (using Jing)  of her web-page.



Leave a comment

Filed under Uncategorized

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s