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

Make grade item mappings automatic

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: Minor Minor
    • None
    • 3.5.2, 3.6, 3.6.3, 3.7.1, 3.8.1, 3.9
    • 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.

      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.

            Unassigned Unassigned
            technikum-wien Stefan Weber
            Luca Bösch Luca Bösch
            Jun Pataleta Jun Pataleta
            Votes:
            4 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:

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

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.