...
You may notice that the assignment weight totals in each list (30, 100, and 110, respectively) do not match the above category weights. This is okay! Assignment weight totals and Category weights are different. Categories serve as an "umbrella" for Assignments. Each category has a weight value, but within each category, each individual assignment also has its own weight value.
Some examples:
...
Category 1: Exams
Exam 1
| Student Grade (g) | Max Points (m) | Weight (w) | |
|---|---|---|---|
| 85 | 100 | 10 |
g / m = x / w
85 / 100 = x / 10
x = 8.5
Exam 2
| Student Grade (g) | Max Points (m) | Weight (w) |
|---|---|---|
| 30 | 50 | 20 |
g / m = x / w
30 / 50 = x / 20
x = 12
| Column |
|---|
Category 2: Quizzes
|
| Column |
|---|
Category 3: Homework |
That is to say, in the example above, even though Exams are worth 50% of a student's overall grade (Exams weight 50 out of a Category weight total of 100), a grade for Exam 1 only accounts for 1/3 of that 50 weight value. (The 1/3 figure is because Exam 1 has a weight of 10, out of an Assignment weight total of 30 among the Exam assignments). That means Exam 1 is only worth 16.7% (1/3 of 50%) of a student's cumulative grade.
...
(Σk wkgk / mk) / (Σk wk) = (w1g1 / m1 + w2g2 / m2 + w3g3 / m3 + ... + wngn / mn) / (w1 + w2 + w3 + ... + wn)
Example: