GB 2.5 Weighted categories and percentages
GB 2.5 Weighted categories and percentages
In this story, our faculty user designed a gradebook which uses both weighted categories. His grading method is to assign numeric grades for each item which are then calculated with equal weight within a category. Each category total is a percentage of the grade.
Let's determine whether the calculations in this MyUCDavis example match those in Sakai's Gradebook!
Setup
Set up the following categories and percentages:
- Poems 30%
- Homework 10%
- Mid-term 25%
- Final 35%
Set up the following gradebook items under these categories:
Note: DO NOT setup any quizzes or assignments - this test does NOT involve interaction with Assignment or Tests & Quizzes tools.
- Poems - 3 items worth 20 points each
- Homework - 7 items worth 40 points each EXCEPT for H6 which is worth 30 points
- Mid-term - 1 item worth 100 points
- Final - 1 item worth 100 points
Data Entry
Now, enter the following grades for each student user. You may need to repeat this test to verify various student accounts. Columns P, H, MD, or F stand for poem, homework, mid-term, and final.
For homework 6, no grades are entered. For any other blanks, do not enter a grade.
Student |
P1 |
P2 |
P3 |
H1 |
H2 |
H3 |
H4 |
H5 |
H6 |
H7 |
MT |
F |
---|---|---|---|---|---|---|---|---|---|---|---|---|
s1 |
19 |
16 |
18 |
40 |
40 |
35 |
30 |
35 |
|
40 |
64 |
50 |
s2 |
18 |
20 |
18 |
35 |
40 |
40 |
40 |
40 |
|
40 |
97 |
82 |
s3 |
19 |
19 |
16 |
38 |
39 |
40 |
40 |
40 |
|
40 |
87 |
79 |
s4 |
19 |
19 |
18 |
36 |
40 |
39 |
30 |
40 |
|
40 |
99 |
89 |
s5 |
20 |
16 |
18 |
29 |
30 |
33 |
35 |
17 |
|
40 |
60 |
54 |
s6 |
11 |
11 |
11 |
35 |
23 |
25 |
22 |
30 |
|
40 |
60 |
53 |
s7 |
17 |
17 |
18 |
40 |
40 |
40 |
40 |
40 |
|
40 |
93 |
91 |
s8 |
7 |
11 |
9 |
|
0 |
0 |
0 |
0 |
|
40 |
38 |
38 |
s9 |
18 |
20 |
18 |
37 |
40 |
39 |
40 |
40 |
|
40 |
89 |
75 |
Percentages Comparison and Verification
Now, let's see how the calculations in MyUCDavis match up with GB 2.5. If you entered the grades as specified, and the grade calculations for no entries are calculated the same as in MyUCDavis, the category percentages should match these results:
Student |
Poems |
Homework |
Midterm |
Final |
Cumulative |
---|---|---|---|---|---|
s1 |
88.3% |
91.6% |
64.0% |
50.0% |
69.1% |
s2 |
93.3% |
97.9% |
97.0% |
82.0% |
90.7% |
s3 |
90.0% |
98.7% |
87.0% |
79.0% |
86.2% |
s4 |
93.3% |
93.7% |
99.0% |
89.0% |
93.2% |
s5 |
90.0% |
76.6% |
60.0% |
54.0% |
68.5% |
s6 |
55.0% |
72.9% |
60.0% |
53.0% |
57.3% |
s7 |
86.6% |
100.0% |
93.0% |
91.0% |
91.1% |
s8 |
45.0% |
20.0% |
38.0% |
38.0% |
38.3% |
s9 |
93.3% |
98.3% |
89.0% |
75.0% |
86.3% |
To complete the test, report the field where item grades did not result in these percentages.