Learning Centered Technology

Technology for the Educator

Blackboard 9 Grade Center Series: Drop Lowest Score

leave a comment »

To drop the lowest score for each test, you will need to set up a calculated column. The column will drop the lowest score and provide a final Test score for the Test category. This is a two-part process; first, you will need to setup a calculated column to drop the lowest Test score and then remove all Test scores from the existing Totals column.

Create Calculated Column to Drop Lowest Test Score

Go into the course> Control Panel> Grade Center> Full Grade Center> Create Calculated Column> Total Column.

DLS-1

In the Create Total Column screen, enter a name such as “Drop Lowest Test Score.”

For Description (optional), enter “Drop lowest test score.”

DLS-2

Select Score for Primary Display.

In the Select Columns, section select “Selected Columns and Categories.” This will make all the columns in the grade book visible.

Under Categories to Select click Test and then the arrow button to move the category into the Selected Columns box.

DLS-3

The category Test will appear on the right side of the screen with options. For Drop Grades, enter the number of scores you want to drop. In the example below, the instructor will drop 1 low test score.

DLS-4

For Calculate as Running Total, select No.

For Include this Column in Grade Center Calculations, select Yes.

For Show this Column to Students you may select either Yes or No.

For Show Statistics (average and median) for this column to Students in My Grades, select No.

DLS-5

Click Submit.

The Total Test Scores column now shows the total of the entire Test, and the Lowest Test Dropped shows the total with the lowest score dropped.

DLS-6

Notice how the Total Test column grade is not the same as the Lowest Test Dropped column.

Modify Original Totals Column

The final step is to modify the Total column for all columns to remove the original test scores. If this step were skipped, the test scores would be calculated multiple times in the totals column

Go into the course> Control Panel> Grade Center> Full Grade Center> Find the Total column and click the column action menu> Select Edit Column Information.

DLS-7

Scroll down to Selected Columns and you will see All Grade Columns are included in the totals.

DLS-8

Click on Selected Columns and Categories. Select the columns you want to include in the calculation. Make sure to leave out the test scores and the Total Test Scores or these columns will be calculated multiple times.

Click the Arrow to move the columns into the Selected Columns box.

DLS-9

Make sure to include the Lowest Test Dropped in the Selected Columns box.

DLS-10

Once you hit submit the Total column will be updated to calculate only the columns you included in the selected columns box. You will notice a difference between the old Total Score and the new.

DLS-11

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: