Center for Online Learning
Vista - Dropping the Lowest Grade
Using the calculated column type in Vista, it is possible to do simple functions like sum, average, etc. But did you know that you can also do a complex formula, like dropping the lowest quiz grade, then averaging?
Using the tools in Vista, create the following formula:
(SUM{column1, column2, column3, columnX} - MIN{column1, column2, column3, columnX})/Y
Note: X is an arbitrary number meaning that you can use however many columns exist in your Grade Book, or however you like. Y is the total number of columns that you are using in your formula (this creates the average)