Many of us use a rubric to assess student work and projects. I am into saving time so I like to use spreadsheets to calculate things for me quickly.
When doing a rubric scale it is important to realize it does not translate to a percentage. For example when you rate a 2 out of 5 on the rubric scale that is not 2/5 (40%). The spreadsheet I created allows you to determine what percentage you want each rubric score to calculate into.
Probably you do not want each rubric criteria item to weight equally either. Has a header probably should not weigh the same as used critical thinking so I included a column to over ride the equal weighting of criteria.
I made a quick YouTube video taking a tour of the rubric
Click Here to get a copy of the 5 point rubric
Click Here to get a copy of the 3 point rubric
Click Here to get a copy of the 4 point rubric
Photo Credit: The Fanboy via Compfight cc
11 thoughts on “Rubric Scoring – a template”
First off thank you for your template. I copied your 4 point template and watched your tutorial to see if there were any issues. I cannot get tabs for all the student placeholders you created(40 I believe). When I change view(to List) and can see that you set it up this way. Is this a Google issue? Any suggestions are greatly appreciated.
Try this link: https://alicekeeler.com/epicrubric I have updated and made some improvements.
Thank you for your time Alice. Thank you! I can’t get it to work with Google Chrome, but in Internet Explorer it runs like a charm. Again, thanks for your contributions to help others. People like you make this country and world better.
That just hurts my soul. Did you try firefox? Thank you for the kind compliments!
Wow! Thank you so much for sharing this! It will definitely help me out with my classroom!
This is absolutely fantastic! Thank you so much.
Thank you! This is very useful.
I was really excited to find this and appreciate your time and effort building it. I just wish it worked. Maybe it’s because I’m on Chrome?
100% it works on Chrome. It is a Google Doc. You have to be logged into your Google Account to make a copy.
Thank you so much for this! But I’m finding that if I enter a value less than two (1, 1.5, etc.) in the student score column, the overall percentage grade does not calculate– it just reads “N/A.” How can I get around this?
No, I did not write the formulas to allow for decimals. Sorry