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