Combining two part exam for a single grade

PhilLongstreet
Community Member

I teach a course where I have the students do a two part exam which I then combine into one score and then I drop the lowest exam grade of 3 exams. Thus my question is can this be done somewhat automatically in Canvas?

Structure: Exam 1 (Part 1) * 60% + Exam 1 (Part 2) = Exam 1 Grade

Course Grade: (Exam 1 + Exam 2 + Exam 3 - Lowest Exam Grade)/2 = Total Exam Grade

Currently, the best I have come up with is to create a dummy grade item (Exam 1 combine) and then manually calculate (in excel) the Exam 1 grade and put it in the Exam 1 combine. This is then used for the course grade where I drop the lowest exam score.

What I would like to do is to have canvas create the third column Excel Exam grade, by using the above weighting for the items but I haven't figured out how to do this.

Note: it is not possible to create the exam as a single part as the first part is question based in canvas, while the second part is exercise based in the Cengage SAM platform.

Labels (1)
0 Likes