Faculty would like to create a custom grade column that automatically calculates student grades depending on several criteria.
He allows students to drop the lowest of their daily quizzes, and
He allows students to drop the lowest of their tests.
So what he wants is to have a Final grade that is based on:
tests(after adjustment) + quizzes(after adjustments) + assignments = adjusted total
Then he wants the Final Grade= adjusted total/possible total
How do I create this grade column?
Hi Michael - the best way that I would know to do this is through calculated columns.
The instructor needs to create a total column for each part (tests, quizzes and assignments). Then make sure all tests are in their own category and all the quizzes are in their own category and the assignments are in their own category.
Now go into edit the total column for each part (tests, quizzes and assignments) and set to drop the lowest score for the tests and quizzes.
Now set up a Final total column and edit the column to only calculate the 3 total columns above.
This should give the final grade the instructor is looking for.
hope this helps.
paige
Paige,
Yes, but that would only give the total score of the three adjusted columns (tests, quizzes,assignments) - he also wants it to be adjusted-total/possible total and that is the part I don't see how to do.
If he is needing to take the adjusted total and divide by the possible total, no I'm not aware of a way to do that directly in the Blackboard grade center since you can't calculate directly. If he is just wanting two separate columns an adjusted total and a possible total, I think that could be accomplished with the options by setting up a total that doesn't drop lowest scores etc. You can suggest the calculation enhancement to Blackboard at http://suggestions.blackboard.com.