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

Make grade item mappings automatic

    XMLWordPrintable

Details

    • Improvement
    • Status: Reopened
    • Minor
    • Resolution: Unresolved
    • 3.5.2, 3.6, 3.6.3, 3.7.1, 3.8.1, 3.9
    • None
    • Gradebook
    • Any
    • MOODLE_35_STABLE, MOODLE_36_STABLE, MOODLE_37_STABLE, MOODLE_38_STABLE, MOODLE_39_STABLE
    • MDL-63475-master
    • Easy
    • Hide
      1. From a course with multiple grade items, export those grade items to an Excel Sheet by using Grades → Export → Excel spreadsheet. When exporting, do tick the "Include feedback in export" checkbox in the "Export format options" section.
      2. Change grades in the Excel sheet. Do change some feedbacks, too.
      3. Copy the all the table cells so that they are in the clipboard.
      4. Go to Grades → Import → Import from Spreadsheet.
      5. Paste the content of the clipboard (the previously copied cells) to the 'Data' textarea and click the "Upload grades" button.
      6. Make sure all the grade items are automatically mapped.
      Show
      From a course with multiple grade items, export those grade items to an Excel Sheet by using Grades → Export → Excel spreadsheet. When exporting, do tick the "Include feedback in export" checkbox in the "Export format options" section. Change grades in the Excel sheet. Do change some feedbacks, too. Copy the all the table cells so that they are in the clipboard. Go to Grades → Import → Import from Spreadsheet. Paste the content of the clipboard (the previously copied cells) to the 'Data' textarea and click the "Upload grades" button. Make sure all the grade items are automatically mapped.

    Description

      Right now, there are multiple formats to export grades from the gradebook, and multiple ways to import.

      However, the process of importing grades is made very tiresome by the inability of moodle to automatically map columns to grade items, even when those columns are named exactly as the grade items.

      It would greatly improve the workflow of teachers that want to export grades to excel, edit them there, and re-import them into Moodle, if the grade item mapping could be made automatic.

      This patch automates mapping of identifier fields and grade items by defaulting the dropdown menus to the matching items.

      Both grades and feedbacks are automatically mapped. In order to do so, /grade/export/lib.php has also be adjusted to use the lang string grade/feedback instead of core/feedback. Since those two lang strings are not necessarily the same in all language packs, export should use the same as import, to make auto-mapping of feedback items possible.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              technikum-wien Stefan Weber
              Luca Bösch Luca Bösch
              Jun Pataleta Jun Pataleta
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              4 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 3 hours
                  3h