A sample grading spreadsheet
A Rubric, Prompt and Sample Responses from Eastern Kentucky University
Spreadsheets can be of great assistance in calculating students grades, as well as keeping them organized. A simple example of how to use a spreadsheet is shown below, and even though different spreadsheet packages are available, they are similar enough that this example could easily be modified for your particular package and your particular assessment system.
Of course, in your own spreadsheet, you would not have cells labelled 'Column 1' or 'Row 1,' these are included in this example as points of reference.
This would be a grading calculator where 6 papers are assigned throughout the semester, each weighted equally. The paper average counts for 65% of the grade, a journal counts for 20% of the grade, and participation 15%.
Grade Calculator Fill in Grades in column 3 below, the average is then calculated for you Column A Column B Column C Column D Row 7 Paper 1 80 80 Row 8 Paper 2 90 85 Row 9 Paper 3 75 81.66666667 Row 10 Paper 4 61.25 Row 11 Paper 5 49 Row 12 Paper 6 40.83333333 Row 13 Total Paper Grade 66.29166667 (Enter Grades in Column 3 cells Below) Row 18 Paper 66 Row 19 Journal 90 Row 20 Participation 95 Row 23 Paper Grade 42.9 Row 24 Journal Grade 18 Row 25 Participation Grade 14.25 Row 27 Total Grade 75.15
The formulas for the above spreadsheet printout are as follows: The formulas are always entered into column D, in the following rows: In row 7,enter: =SUM(C7) row 8, =SUM(C7,C8)/2 row 9, =SUM(C7,C8,C9)/3 row 10, =SUM(C7,C8,C9,C10)/4 row 11, =SUM(C7,C8,C9,C10,C11)/5 row 12, =SUM(C7,C8,C9,C10,C11,C12)/6 row 13, =SUM(D7:D12)/6 row 23, =SUM(C18*0.65) row 24, =SUM(C19*0.2) row 25, =SUM(C20*0.15) row 27, =SUM(D23:D25)
Although this may seem like a lot of work, once you have created a master program, it can be copied and used for each of your students. This makes calculating grades as simple as inputting a couple of numbers, plus you have a handy record for each student, valuable for use at conference time and end-of-semester reports.
If you change the grading system, it is simple to alter the program to reflect this. The initial cost of time is well worth it in the long run.