homepagetitle-1306.JPG (24342 bytes)

Computing the Final Grade

The components of the class have different weights.

Each test is worth 15% of your final grade.  The reaction papers together are worth 15% of your final grade. Each one is worth 3.75% each.  The final (Concepts Test) is  worth 10% of your 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 - 10

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