TIME SAVING AUTO-UPDATING RUBRIC
This is an Excel file of a 4 x 4 Rubric that Auto-Updates.
By Changing the names in the STUDENT sheet, all the student sheets auto populate with the student names.
In addition the Project name, Period of your class, and Date can be changed on the STUDENT sheet and auto-updates on all corresponding Pages.
By changing the Cells of the 4 x 4 rubric on Student 1, every additional student's rubric will update to match it. You can even change the names of the categories which will change on every other student page.
The Total cell on each student sheet is auto-calculated when numbers are added in the total column. The Grades are then auto-updated on the original STUDENT sheet for a quick breakdown and transfer to your school's grade website or gradebook.
This should save many teachers tons of time when grading.
All you have to do is duplicate your original Excel file and set it up for each project and you're good to go.
Don't forget to change the Class Name and Teacher in the student list as well. This will change all the sheets.
If you have any questions don't hesitate to ask!!
1. This was created with Excel 2011 on a Macintosh
2. Adding cells or deleting cells may ruin the calculations and cell linking. Proceed with caution.
3. Sheets are sized to fit/print on an 8.5 x 11 sheet in landscape, so resizing cells may mess with the sizing.
4. This will only work with 34 students max.