calculate final grade for students excused from a test
If we need to add points to the final exam weight for students who were excused from a term test, besides manually adjusting grade for these students, is there a feature in bs to do this for us? can we request it?
thanks Charmaine
Best Answer
-
Hello Charmaine,
This depends on how you have your gradebook organized.
Option 1: If all the exams are in the same category, there is an option to have the lowest grade in a category dropped. This assumes that all items in that category are weighted evenly.
Option 2: If there exists no sort of categorization that would make option 1 possible, and if the student has been exempted from a certain grade item, then the overall denominator that all the grades will be calculated out of for that student will be lower, thus the weight of the remaining/non-exempted items will be greater. This does not put all that additional weight on the final, however.
Option 3: You could use a formula-based final grade (instead of points or weighted) that could account for this increased weighting on the final if a term test has no grade. This would be a bit more complex and you would have to develop the formula that made sense, but it certainly is doable.
In this example, I created a formula that said IF a student has a 0 on any of the term tests, THEN double count the final, IFNOT (meaning the don't have a zero on any of the term tests) then just average all the grades together.
You can see that Charlie and Arnold both had zeros on Term Test 3, so their Final Exam score was double counted, but Harrison and Alene did have all term test grades, so it was averaged.
Without knowing your exact grade setup, I don't know which of these will work for you, if any.
Best,
Andrea
Answers
-
thanks! If we wanted to put the weight of the excused test onto the weight of the final exam, 12.5 points, would our formula be instead of a (2* , be a (12.5 +[Final Exam.PointsReceived],,,
-
doesnt seem to be working for me
