Why the Export Grades tool in Blackboard shows inaccurate grades?

Whether you are preparing your grades to be exported to Banner or you just want your students to know how they are doing in regards to grades in the course, having accurate grades in Blackboard is important. We have collected solutions for the top problems that might be causing your Grade Center to miscalculate or malfunction.

Running Total

If your Total or Weighted Total column doesn’t seem to be calculating correctly first review the information on Running Total.

  • Make sure to enter in zeros for no submission in columns used to calculate grades for calculated grades in the Total or Weighted Total columns with Running Total.
  • You do not need to enter zeros for no submissions, as any grade column without a grade is automatically a zero for calculated grades in the Total or Weighted Total columns without Running Total. However, you need to review columns not in use as these will also be interpreted as zero as well. You can delete the unused column or select the chevron to the right of the column, select “Edit Column Information,” and set “include this column in Grade Center calculations” to No.

Please note: the default settings for Total and Weighted Total columns have the Running Total enabled. If you would like to change this setting, select the chevron to the right of the column, select “Edit Column Information,” and then select No for “Calculate as Running Total.” Remember to delete columns not used or edit the unused columns to set “include this column in Grade Center calculations” to No.

Include this Column in Grade Center Calculations

If your Total or Weighted Total column still doesn’t seem to be calculating correctly next review your column settings. Check any column settings by selecting the chevron to the right of the column and selecting the “Edit Column Information.”

If a column is set to No for “include this column in Grade Center calculations” then any grades in that column will not be used in the calculated column. Change this setting to Yes to enable it to be included in the calculated column.

Weighted Total using percentages

If your Weighted Total column still doesn’t seem to be calculating correctly, then review the percentages assigned to each assessment to ensure that it isn’t an incorrect percentage that is causing your Weighted Total column to miscalculate.

Weighted Total using Categories

If your Weighted Total column still doesn’t seem to be calculating correctly, then review the assigned categories for your columns. Check that all your columns have the accurate category assigned to them. For example, if you created a quiz category for all eight quizzes in your course then check to make sure each Quiz column is assigned to this category.

Extra Credit with Total Column

Have you added an extra credit column to Grade Center and students’ scores have dropped? It is important that you create an extra credit column with zero possible points. If you set an extra credit column with possible points, then this point value will increase the possible points in the Total calculated column and will negatively impact students’ grades. The Total calculated column divides the earned points (numerator) by the possible points (denominator).

Extra Credit with Weighted Total Column

You can add extra credit to individual assignments by increasing the earned points. For example, you have a paper worth 10% of a student's grade, and you are grading it out of 100 points. If you wanted to give a student 5% extra credit towards their final grade, then you can increase their paper grade by 50 points. In Grade Center, this would be viewable as 150/100 in a column worth 10% of the final grade (the extra credit gives 15% for the assignment with 5% of it being extra credit).

External Grade Column

Are you having trouble exporting the correct grade column? Review which column in Grade Center is set for the external grade column. The external grade column by default is the Total column in the Grade Center (you will see the green check mark next to the default external grade column). This column is the important one when exporting grades to Banner. Be sure to select the correct column as the external one marked with a green check mark as shown below.

Green check mark next to Total Column

If you need to export grades from a different calculated column, make sure to enable the preferred column by selecting the chevron to the right of the column and selecting the “Set as External Grade” column. The green check mark will then be present on this preferred calculated column.

Set as External Grade

Can't Fix an Immediate Problem? Submit a Ticket

Still, need help determining why Grade Center is malfunctioning? Please submit a ticket at the UIC Help Center for a support member to assist you.

Planning for Next Term

Want advice and guidance on assessment planning? Want to learn best practices for setting up Grade Center? Consider signing up for an Instructional Design Consultation.

Details

Article ID: 2342
Created
Fri 11/19/21 2:56 PM
Modified
Wed 11/24/21 12:36 PM