Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-57902

Enhance Grade Import feature to allow multiple course final grade imports



    • Type: Improvement
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 3.3, 3.4
    • Fix Version/s: None
    • Component/s: Analytics, Reports
    • Labels:
    • Workaround:

      You could just add a manual grade item called "SIS Final Grade" and make the course grade calculated from this manual grade item.

      You could just add a manual grade item called "SIS Final Grade" and make the course grade calculated from this manual grade item.
    • Affected Branches:


      The Grade Import feature (https://docs.moodle.org/32/en/Grade_import) allows import of sets of grades from an external system, e.g. a teacher can import a spreadsheet or CSV file with all grades for students in one course.

      It is common for institutions to store final grades in an internal system of record, such as a Student Information System (e.g. Banner), and these final grades are sometimes calculated outside of Moodle, especially when Moodle is being used to support face to face courses. This makes it impossible to use final course grade as an outcome (Y value) in learning analytics, yet this is one of the most commonly requested outcome measures in academic settings.

      To support learning analytics, we need to be able to import final grades from such an external system via CSV. As with the current per-course functionality, the import should overrride the grade entry and the previous grade (if any) should be stored in Grade History. The structure of the CSV should be very simple, consisting of one course and grade per line, separated by a comma. The course should be identified by shortname (a system-unique value). The grade should be expressed as a percentage decimal (0.0-1.0). The import action should be logged.

      This is necessary for the data gathering phase of Project Inspire and for any future open data sharing efforts. Rather than asking sites to submit final grades separately from the database, this feature allows grades to be merged with the Moodle database and anonymised appropriately via the Local Anonymise plugin.


          Issue Links



              Unassigned Unassigned
              emdalton1 Elizabeth Dalton
              Component watchers:
              Elizabeth Dalton, Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              1 Vote for this issue
              4 Start watching this issue