Moodle
  1. Moodle
  2. MDL-10901

Course total in gradebook is always a calculated percentage even though preferences are set to report real scores.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9
    • Component/s: Gradebook
    • Labels:
      None
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE
    • Rank:
      28705

      Description

      It appears that in the current 1.9 beta gradebook (downloaded 8/17/07) the Course Total column is a calculated percentage even though there is no percentage icon indicating this and in the gradebook preferences the Grade display type has been set to report real scores. If this is not fixed, we could not deploy 1.9 in our evironment because it would cause massive confusion among our students. We always prefer to report real points for each assignment or exam (rather than percentages) and thus they would expect this column to be the sum total of points for all assignments.

        Activity

        Hide
        Martin Dougiamas added a comment -

        Yes, each column in the gradebook has a min and max value. The default is 0 - 100.

        For the case you're talking about we might need an exception. Petr, can you think about the neatest way to add an option to implement course totals as a pure sum?

        Show
        Martin Dougiamas added a comment - Yes, each column in the gradebook has a min and max value. The default is 0 - 100. For the case you're talking about we might need an exception. Petr, can you think about the neatest way to add an option to implement course totals as a pure sum?
        Hide
        Rolf Christoffersen added a comment -

        Further testing of the gradebook (Moodle 1.9 Beta 2 (2007101000)) has revealed some calculation errors in the Course total. I made three offline assignments worth 100, 100 and 200 pts. I assigned some scores and manually set the range of the Course Total to 400. There must be some problem with the calculation of the scores reported in the Course total. Notice that in some cases the sum is correct but in others is off ?????.

        Midterm 1 Midterm 2 Final Exam Course total
        Range 0.00-100.00 0.00-100.00 0.00-200.00 0.00-400.00
        Test MCDB293 Student 50.0 80.0 160.0 280.0
        Test Student1 20.0 60.0 80.0 160.0
        Freshman Student 90.0 90.0 186.0 364.0
        Overall average (Submissions) 53.33 (3) 76.67 (3) 142.00 (3) 268.00 (3)

        If I define the Course total using =sum([[midterm1]],[[midterm2]],[[Final Exam]]) then the calculations are correct. This explicit approach is way to complicated and cumbersome for most users - we need an easier way of reporting the sum of point values in the course total.

        I suggest the following modifications:
        1. A grade book setting which will automatically set the range of categories and the course total to be the sum of the individual components.
        2. A simple option to set the number reported in the categories and course total to be the sum of the components.
        3. An easier way to set the max points for an assignment to a value above 100 pts. Currently, we have to hack the php code to allow this.

        The vast majority of faculty here (UCSB) report scores as raw points and sums. It is confusing to report % scores which represent variable percentage contributions to their overall total. Reporting raw scores make it very clear the value of each assignment towards their grade. Some assignments are worth 10 pts and others are worth 200 pts or more. The raw point scores make that very clear.
        Thanks!

        Show
        Rolf Christoffersen added a comment - Further testing of the gradebook (Moodle 1.9 Beta 2 (2007101000)) has revealed some calculation errors in the Course total. I made three offline assignments worth 100, 100 and 200 pts. I assigned some scores and manually set the range of the Course Total to 400. There must be some problem with the calculation of the scores reported in the Course total. Notice that in some cases the sum is correct but in others is off ?????. Midterm 1 Midterm 2 Final Exam Course total Range 0.00-100.00 0.00-100.00 0.00-200.00 0.00-400.00 Test MCDB293 Student 50.0 80.0 160.0 280.0 Test Student1 20.0 60.0 80.0 160.0 Freshman Student 90.0 90.0 186.0 364.0 Overall average (Submissions) 53.33 (3) 76.67 (3) 142.00 (3) 268.00 (3) If I define the Course total using =sum([ [midterm1] ],[ [midterm2] ],[ [Final Exam] ]) then the calculations are correct. This explicit approach is way to complicated and cumbersome for most users - we need an easier way of reporting the sum of point values in the course total. I suggest the following modifications: 1. A grade book setting which will automatically set the range of categories and the course total to be the sum of the individual components. 2. A simple option to set the number reported in the categories and course total to be the sum of the components. 3. An easier way to set the max points for an assignment to a value above 100 pts. Currently, we have to hack the php code to allow this. The vast majority of faculty here (UCSB) report scores as raw points and sums. It is confusing to report % scores which represent variable percentage contributions to their overall total. Reporting raw scores make it very clear the value of each assignment towards their grade. Some assignments are worth 10 pts and others are worth 200 pts or more. The raw point scores make that very clear. Thanks!
        Hide
        Petr Škoda added a comment -

        You can use weighted mean if you want to have different weight of grades from assignments or other activities, or you can use categories to group grade items.

        I am afraid we can not implement the sums without many changes and even more confusion in UI now. The gradebook is not designed to handle points, every value is converted to 0%-100% percent range. You can not have negative or above 100% values. sorry

        Show
        Petr Škoda added a comment - You can use weighted mean if you want to have different weight of grades from assignments or other activities, or you can use categories to group grade items. I am afraid we can not implement the sums without many changes and even more confusion in UI now. The gradebook is not designed to handle points, every value is converted to 0%-100% percent range. You can not have negative or above 100% values. sorry
        Hide
        Rolf Christoffersen added a comment -

        Petr,
        If what you say is true, then you need to remove the option of reporting real scores which is very misleading to naive users. It should be explicitly clear that the new gradebook for 1.9 can only use percentage scores. Also, you need to remove the sigma symbol from categories which I think most people would interpret to mean the sum of all the scores (not the mean of the scores).
        The inability to deal with real points will be a show stopper for Moodle 1.9 at our university. It is too bad because the new gradebook has many good features we really needed but if it can't add up raw scores, we could never implement Moodle 1.9 here until this is fixed.
        Thanks,
        Rolf

        Show
        Rolf Christoffersen added a comment - Petr, If what you say is true, then you need to remove the option of reporting real scores which is very misleading to naive users. It should be explicitly clear that the new gradebook for 1.9 can only use percentage scores. Also, you need to remove the sigma symbol from categories which I think most people would interpret to mean the sum of all the scores (not the mean of the scores). The inability to deal with real points will be a show stopper for Moodle 1.9 at our university. It is too bad because the new gradebook has many good features we really needed but if it can't add up raw scores, we could never implement Moodle 1.9 here until this is fixed. Thanks, Rolf
        Hide
        Petr Škoda added a comment -

        There is a new aggregation type "Sum" that should be doing what you want, please test it.

        Thanks for the report

        Show
        Petr Škoda added a comment - There is a new aggregation type "Sum" that should be doing what you want, please test it. Thanks for the report

          People

          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: