Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-41295

Course grade miscalculates if there's an Extra Credit category and 1 or more other categories are empty



    • 19 status:
    • 12 status:
    • Test Plan:

      Please add a Test Plan here.

      Please add a Test Plan here.


      When using categories & weights with an extra credit category, the course grade does not compute correctly when the student has earned extra credit but doesn't yet have grades in all gradebook categories. The course grade is skewed high until the student has grades in all gradebook categories.

      I replicated in 11.4, 12.5, 19, and 20 master.

      Here's an example of how to replicate:

      1. In an empty course, set up Gradebook with a few categories & weights plus an Extra Credit category. For example:
      Homework = 20%
      Labs = 30%
      Exams = 50%
      Extra credit = 5%

      2. Create 1 Gradebook item in each category, such as:
      HW 1 (100 pts) - in Homework category
      Lab 1 (100 pts) - in Labs category
      Exam 1 (100 pts) - in Exams category
      Practice sets (100 pts) - in Extra Credit category (Note: Do not mark the ITEM as extra credit; just put it in EC category.)

      3. For one student, enter a perfect score for the EC item and for the HW1 item, like so:
      HW 1 = 100
      Practice sets = 100
      Lab 1 = LEAVE BLANK
      Exam 1 = LEAVE BLANK

      4. Look at the student's course grade – it should be 105%. But it is showing as 125%.

      5. Now enter a perfect score for the Lab 1 item. The student's course grade should be 105%. But now it's 110%.

      6. Finally, if you give the student a perfect score on the Exam 1 item, the course grade will be correct: 105%.

      The current formula for calculating the course grade when some categories are empty appears to be something like this:
      (cat1avg*cat1weight + cat2avg*cat2weight + ECcatavg*ECweight) divided by (cat1weight + cat2weight)

      To calculate correctly, the EC part should not be in the numerator, but instead should be added to the final total, like this:
      ((cat1avg*cat1weight + cat2avg*cat2weight) divided by (cat1weight + cat2weight)) + ((ECcatavg*ECweight) divided by 100)

        Gliffy Diagrams



            1. 02072020_GB.gif
              33 kB
              Andrea Schmidt
            2. GB-settings-EC-category.png
              27 kB
              Karen McPhaul
            3. student-grades-1-cat-plus-EC.png
              48 kB
              Karen McPhaul
            4. student-grades-2-cats-plus-EC.png
              50 kB
              Karen McPhaul



                jesusmmp Jesus Maria Mendez
                mcphaulk Karen McPhaul
                1 Vote for this issue
                9 Start watching this issue



                    Git Integration