calculate final grade for students excused from a test

Charmaine.P.705
Charmaine.P.705 Posts: 23 🌱
edited December 2024 in Higher Ed / Postsecondary

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

Tagged:
· Share on Twitter

Best Answers

  • Andrea.M.553
    Andrea.M.553 Posts: 7
    edited December 2024 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.

    image.png

    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.

    image.png
    image.png

    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

    · Share on Twitter
  • Jennifer.W.973
    Jennifer.W.973 Posts: 386 🎆
    Answer ✓

    @Charmaine.P.705 IF functions have three parts: the IF statement, what to do when it's true, and what to do when it's false. So in your example you have the first two parts, but you need to add the last part of how the final grade is calculated when the IF statement is false. I'm assuming it will just be SUM of test, midterm, and final exam points? Add a comma between the last two } } and add the SUM function after the comma.

    · Share on Twitter

Answers

Categories