Calculations in the Blackboard Gradebook

Posted on by digitaleducation

Add a column

Blackboard Ultra provides several different calculation columns for calculating marks in the Gradebook. Which column you need depends on the action you wish to undertake and the type of assessment you have set in eVision. In most instances, this would be a “BB Other” assessment type. 

To add a column: 

  1. Enter the Marks view of the Gradebook.
  2. Hover your mouse cursor between two columns where you would like to create the new column.
  3. Click the + icon that appears.
  4. Select either Add Calculation or Add Total Calculation from the list that appears.
  5. Add a title for the column.  

The calculation columns available are: 

  • Total Calculation: This enables you to add the results of assessments together. You can do this either as:
    • Weighted total, where each assessment receives a % attribution that adds up to 100% overall.
    • Points total, where the number of points available in each assessment are combined to make a total.
  • Calculation: This allows you to conduct calculations that are more bespoke, comparable to some of the functions you may otherwise carry out in a spreadsheet. However, the functionality is limited, and more complex needs may still require off-line work. For instructions on how to download an upload files you can amend in Excel, please see the section on Offline Calculations.

Choose which column to use

In most instances, the Total Calculation column will provide the functionality required to manage combined assessments (where several tasks add together or where only some scores from a set are counted towards a total, such as a “best of x out of Y” model).

A Calculation column can also be used to achieve the same results and may provide the functionality needed to conduct calculations previously managed outside of Blackboard. However, the interface and functionality is limited, and some calculations will still need to be managed outside of Blackboard (such as rounding to the nearest integer). Instructions on how to download and upload a file from Blackboard you can amend in Excel, please see the section on Offline Calculations.

Assessment types in eVision to use with columns

To extract marks from a calculated column to eVision, you will need to use the BB Other assessment type in eVision and then ‘map’ the calculation column and the one provided by eVision together.

Total Calculation Columns

Description and use cases

A Total Calculation Column lets you add several marks from other columns together, creating an overall mark.  

You can: 

  • Give different assignments different weighting. For example, if you have three assignments, you could weight one at 50%, one at 30% and one at 20%. Any combination is possible provided the overall percentage adds to 100%, including adding up to two decimal places.
  • Apply a Marking Schema. For example, you could include several assessments added up to a total and then apply a “Pass/Fail” marking schema, changing the display of the mark to students in the Gradebook to either a “pass” or “fail” moniker.
  • Drop Scores. Set the number of highest or lowest scores to exempt from the calculation. For example, if you wish to discount the three lowest scores out of five total assignment results. This is commonly referred to as a “best x out of y” or “best of” approach to marking. 

This type of column is most useful when: 

  • You want to only consider or value the best or worst grade on several assessments.
  • You want to add together multiple assessment activities into one, overarching grade.
  • You wish to ignore X number of the highest or lowest grades for Y number of assessments.
  • You need the final grade for the assessment to be expressed as a percentage out of 100.

Key considerations: 

  • You may still need to round grades to the nearest integer: When you combine several grades together into an overall percentage, some grades may be expressed as a decimal fraction (for example, 70.5%). University policy requires that such grades are rounded to the nearest integer before being returned to students. Currently, this rounding still cannot be achieved in Blackboard.  

General setup 

  1. If you have not already put all assignments, tests or other Gradebook Items related to this calculation into a shared category, you should do this first:
    1. Navigate to the Marks view of the Gradebook.
    2. Click on the cog icon in the top-right of the screen. The Gradebook Settings menu will open on the right of the screen.
    3. Scroll down the menu and then select Add New Category under the Mark Categories header.
    4. Enter a name for your category and press return on your keyboard. You will be adding all of the assignments you want to total to this category, so give it an easily recognisable name. For example, you may want to name it after the overall assessment.
    5. Select the pink cross to close the menu.
    6. In the Marks view, find each Assessment you want to add to the calculation and:
      1. Click on the header to open the drop-down menu:
      2. Select Edit.
        1. For assignments or tests, select the cog icon.
          1. Scroll down until you see the Marking & Submissions header.
          2. Change the Mark category to the category you have just created.
        2. For items (columns created directly in the Gradebook not attached to an assignment, test or submission point), change the Mark category to the category you have just created.
      3. Repeat this for each item or assessment you wish to add to the calculation.
  2. In the Marks view of the Gradebook, hover your mouse cursor between two columns where you would like to create the new Total Calculation column.
  3. Click the “+” icon that appears.
  4. Select Add Total Calculation from the list that appears.
  5. Add a title for the column.
  6. Select either Points or Weighted.
    1. Selecting Points will calculate a points-based total where the maximum score is equal to the total of all points available in all items.
    2. Selecting Weighted will create a total calculation that treats the results of each individual assessment as a weighted %. The total value must then add up to 100%. If you choose Weighted you must then select between:
      1. Proportionally: where the weight given to an individual assessment is defined by their relative points value to other assessments you add. For example, if one assessment has 10 points available and the other 90 points, the first assessment will be weighted at 10% and the latter at 90%.
      2. Equally: where the weight given to each assessment is equally distributed irrespective of each assessment’s individual points value. For example, if you have two assessments in your calculation, one with 10 points available and the other with 90, they will both be weighted at 50% each.
  7. Total Calculation Columns initially consider all gradable items in your course. You need to exclude all but the one category you have created for this calculation. Working down the list of categories, select the exempt icon on all categories except for the one you want to work with. The exempt icon on deselected items will turn purple.
    A list of categories, all but one of which are excluded.
  8. If you are simply looking to add a selection of assessments together into an overall percentage-based score, you can now Select Save. Alternatively, you can also: 
    1. Add additional categories and adjust their individual weighting (on Weighted Total columns). If you need to manually set the weighting of a or all items, add the item to its own category and leave both selected. You can add as many categories as you wish and adjust the weighting of each by typing your preferred weight into the text box.  
    2. Exclude specific items within a category. you can exclude specific items from the within a category from the calculation. To do this, click the ˅ symbol at the right-hand end of your category to expand all of the items you have added and then select the exclude symbol next to the item you want to exclude.
      List of items within a category. The expand and exclude icon are highlighted.
    3. Unlink items from a category (to set specific weighting to each). To do this, click the ˅ symbol at the right-hand end of your category to expand all of the items you have added and then select the unlink symbol next to the item you want to remove from the category. You can then adjust the weighting of that specific item by typing the weight you want to assign to it in to the text box. Note: the total for all items and categories must add up to 100% overall.
      List of items within a category. The unlink icon to the right of one of them is highlighted.
  9. Drop worst or best scores (to create a ‘best of’ or ‘worst of’ mark). To do this, select Edit calculation rules on the category you want to adjust to open a panel of further options on the left-hand side of the screen and toggling the Enable option to on. From here, you can either:
    • Use only the highest or lowest scores from all of the added items, assessments or tests, or
    • Drop scores to set a specific number of highest or lowest scores to drop from the calculation.

Calculation Columns

  1. In the Marks view of the Gradebook, hover your mouse cursor between two columns where you would like to create the new Total Calculation column.
  2. Click the “+” icon that appears.
  3. Select Add Calculation from the list that appears.
  4. Add a title for the column.
  5. Under Select a grade schema, select between:
    • Points
    • Percentage
    • Letter
    • Complete/Incomplete
  6. You can then construct a calculation by adding and arranging functions, variables and operators as required.
    • Functions and Variables:
      • Average: generates the average from any number of selected graded items, categories or other calculations.
      • Total: generates a total from any number of selected graded items, categories or other calculations.
      • Minimum: returns the minimum grade for a selection of graded items, categories or other calculations.
      • Maximum: returns the maximum grade for a selection of graded items, categories or other calculations.
      • Variable: allows the addition of individual graded items or calculations. The maximum points for a graded item must be greater than zero.
    • Operators:
      • Add
      • Subtract
      • Divide
      • Multiply
      • Open Parenthesis
      • Close Parenthesis
      • Value: allows you to enter a numeric value to any calculation.
  7. Once you have completed the calculation, select Validate to ensure it is working as required.
  8. Select Save.

Offline Calculations 

In some instances, it may be necessary or desirable to download information from Blackboard, conduct calculations offline in Excel, and then reupload amended information to Blackboard.

Preparations

If you need to extract grades you have amended in an Excel file to eVision, you should use either a BB Other or Marks Only assessment type. 

If you are using a BB Other assessment type, you will need to add an additional Blackboard column where grades manipulated in Excel can then be re-uploaded to Blackboard. This column should then be mapped to the BB Other column for marks extraction. You cannot upload marks directly to a BB Other column. 

You can upload marks directly to a Marks Only assessment type column, so you can use this column in downloaded spreadsheets as a location for final calculations.

Downloading from the Gradebook

  1. Navigate to the Marks view of the Gradebook.
  2. Select the Download icon in the top-right corner to open an options menu.
    Download icon highlighted
  3. Select Full Gradebook.
  4. Either highlight specific items or assessments by selecting them from the Record Details list, or else select Select All Items.
  5. Set the File Type to Comma Separated Values (.csv).
  6. Select Download.
  7. When the file has downloaded and been opened, you may be prompted by Excell to update or convert the file type. Select Don’t Convert to avoid making changes to the document that will prevent uploading it back to Blackboard.

When working with downloaded Blackboard Gradebooks, care should be taken to not affect existing grades you do not want to change. Similarly, changes in formatting can prevent the file from being reuploaded.

Uploading to the Gradebook

Once you have completed offline calculations, save your file in a sensible location, sustaining the .csv file format.  

  1. Navigate to the Marks view of the Gradebook.
  2. Select the Upload icon in the top-right corner to open an options menu.
    Upload icon highlighted
  3. Either drag and drop your file, or else select Upload Local File to browse your computer or a shared location.
  4. Once a file is located, an upload progress indicator will appear. When it is complete, click Upload. You will be returned to the Gradebook and a “Upload Complete!” message will appear at the bottom of the screen.

You should check uploaded marks are correct before then releasing them to students or uploading them to eVision.