Uploaded image for project: '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
    • Status: Closed
    • Priority: 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

      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.

        Gliffy Diagrams

          Activity

          Hide
          dougiamas 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
          dougiamas 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
          rechristof 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
          rechristof 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
          skodak Petr Skoda 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
          skodak Petr Skoda 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
          rechristof 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
          rechristof 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
          skodak Petr Skoda 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
          skodak Petr Skoda 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:
                Fix Release Date:
                3/Mar/08