WebCT Drop Lowest

This was a nice little find in the Dr. C WebCT help boards. It's simple and effective. If you ever need to drop your lowest test score in your WebCT grade book (version 4.1) this formula might help. To use this, all your tests would need to be out of the same number of points or be calculated percentages. First add a calculated column to your gradebook. Then edit the formula for that column. You will want to add up all your tests with the SUM method, and then using the MIN method, find the lowest score of those same tests and subtract it. The formula for 5 tests would look like this:

SUM{[test1],[test2],[test3],[test4],[test5]} - MIN{[test1],[test2],[test3],[test4],[test5]}