Combining two part exam for a single grade
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.