# New Grade Center calculated column requested

Question asked by grommet.allen on May 4, 2017
Latest reply on May 16, 2017 by jkelley_blackboard

Blackboard Support suggested that I post the following into the "Blackboard Community":

What would you think of adding another calculated column to the Grade Center that could be used to adjust proportionalities of grades being averaged?  Here is an example of what I mean:  I not only administer our Blackboard instance at East Arkansas Community College, but also teach a full load of courses (some online).  In my online courses I administer 100-point exams and 20-point lab exercises.  The labs average together and are intended to count as an additional lab score.  Blackboard doesn't know how to do this, so I would like to see a calculated column that can "adjust" a score from a 20-point scale to an equivalent on a 100-point scale.  Before someone suggests just using percentages, that's been tried and the math doesn't work, because Blackboard calculates, it seems, using the RAW SCORES not the percentage.  Lets assume four 100-point exams and eight 20-point labs.  Then, using exam scores of 82, 89, 77, and 95 with "raw" lab scores of 20, 18, 16, 20, 19, 17.5, 15, and 20.  The lab average would then be approximately 18.19 (90.94%).  Using an Average calculated column Blackboard would produce the result of 72.24, when the intended average is 86.79.  This is because Bb uses the 18.19 "exam" score to average with the other 4.  It doesn't use the percentage value (which is the equivalent 100-point scale value for the lab average) that the instructor intended to be used.