Computing the Final Grade
[Revised: April 8, 2007] |
Click Here for Excel Grade Calculator Please Note: In order to use this tool to calculate your final average, you must use a computer that uses Windows and which has Excel available. |
Here's how I compute your final score.
The General Process |
|||||
| Item | Item Score |
Value of Item toward final grade |
Process | Add Rows 1 to 10 |
|
| 1 | Test 1 | 15 percent | Multiply Test 1 grade by .150 | Put value here | |
| 2 | Test 2 | 15 percent | Multiply Test 2 grade by .150 | Put value here | |
| 3 | Test 3 | 15 percent | Multiply Test 3 grade by .150 | Put value here | |
| 4 | Test 4 | 15 percent | Multiply Test 4 grade by .150 | Put value here | |
| 5 | Test 5 | 15 percent | Multiply Test 5 grade by .150 | Put value here | |
| 6 | Reaction Paper # 1 | 3.75 percent | Multiply Paper # 1 grade by .0375 | Put value here | |
| 7 | Reaction Paper # 2 | 3.75 percent | Multiply Paper # 2 grade by .0375 | Put value here | |
| 8 | Reaction Paper # 3 | 3.75 percent | Multiply Paper # 3 grade by .0375 | Put value here | |
| 9 | Reaction Paper # 4 | 3.75 percent | Multiply Paper # 4 grade by .0375 | Put value here | |
| 10 | Final (Concepts Test) | 10 percent | Multiply Final grade by .100 | Put value here | |
| Final Grade | Add values in this column. This is your final score. | ||||
Here is an example
An Example of Computing a Final Grade |
|||||
| Item | Item Score | Value of Item toward final grade | Process | Add Rows |
|
| 1 | Test 1 | 100 | 15 percent | 76 X .150 = | 15.00 |
| 2 | Test 2 | 76 | 15 percent | 76 X .150 = | 11.40 |
| 3 | Test 3 | 64 | 15 percent | 64 X .150 = | 9.60 |
| 4 | Test 4 | 88 | 15 percent | 88 X .150 = | 13.20 |
| 5 | Test 5 | 82 | 15 percent | 82 X .150 = | 12.30 |
| 6 | Reaction Paper # 1 | 100 | 3.75 percent | 100 X .0375 = | 3.75 |
| 7 | Reaction Paper # 2 | 90 | 3.75 percent | 90 X .0375 = | 3.38 |
| 8 | Reaction Paper # 3 | 75 | 3.75 percent | 75 X .0375 = | 2.81 |
| 9 | Reaction Paper # 4 | 0 | 3.75 percent | 75 X .0375 = | 0.00 |
| 10 | Final (Concepts Test) | 86 | 10 percent | 86 X .100 | 8.60 |
| Final Grade | 80.04 | ||||