College of DuPage
Blackboard Grade Center

Drop Lowest Score

Automatic Method: Create a Total Calculated Column

Review Drop Lowest Score - Case Study background.

To automatically drop the lowest score for each quiz, Julie will need to set up a calculated column to do this procedure. While she could do this directly in the default Total column, she will create a separate calculated column to see how this operates. The column will drop the lowest score and provide a final Quiz Score for her Quiz category. Then Julie will use the results of the Quiz Score column in the Total column.

A screenshot of the Add Calculated Column menu. Weighted is highlighted.

Categories to Select has been highlighted along with the category Test.

The Selected Columns area is displayed with 100 entered in the Category and a 1 entered for Drop lowest grades.

The Quiz Scores column now shows the total of the quizzes with the lowest score dropped. 

The Test Score column is highlighted.

Notice how the Total column grade (33 points) is not the same as the Quiz Scores column grade (28 points). This is because the calculation for the Total column is taken from the scores in all of the quiz columns. The final step is to modify the Total column to include the calculated score total of the quizzes.

The Total column menu is shown in this screenshot. Modify column is highlighted.

The column Quiz Scores is highlighted as well as the arrow to the right of the selection box.

The Test Scores column selection is displayed. Other columns may need to be added to determine a total score.

This screenshot shows that Yes has been selected for Calculate as a running total.

The information from the Quiz Scores column has been added to the Total column. The calculations are correct.

Screen shot showing final Grade Center scores for one student.

Once you have set up calculated columns, check your Grade Center settings by adding some temporary scores to the Grade Center. Check that the scores are calculating as expected.  Remove any temporary scores when satisfied.

 

Return to Drop Lowest Score - Case Study

Return to Tips and Tricks