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

Can't use Excel to edit the assignment Offline grading worksheet

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide
      1. As admin/teacher:
      2. Add a new course
      3. Enrol multiple students to course
      4. Add an assignment (online text), enable the offline grading worksheet feedback type
      5. As student: submit the assginemnt
      6. As teacher: 'Download grading worksheet'
      7. Using excel, open the grading worksheet
      8. Ensure the status column displays OK
      9. Set some grades and feedback comments
      10. Save the csv file
      11. Navigate back to the assignment grading screen and click on "Upload grading worksheet"
      12. Upload the file.
      13. Verify that the screen "Confirm changes in grading worksheet" appears. Click Confirm.
      14. Verify that the grades and feedback have been recorded in Moodle's gradebook.
      Show
      As admin/teacher: Add a new course Enrol multiple students to course Add an assignment (online text), enable the offline grading worksheet feedback type As student: submit the assginemnt As teacher: 'Download grading worksheet' Using excel, open the grading worksheet Ensure the status column displays OK Set some grades and feedback comments Save the csv file Navigate back to the assignment grading screen and click on "Upload grading worksheet" Upload the file. Verify that the screen "Confirm changes in grading worksheet" appears. Click Confirm. Verify that the grades and feedback have been recorded in Moodle's gradebook.
    • Workaround:
      Hide

      Edit the file with notepad++ and ignore the confusing linebreaks on the status fields.

      Show
      Edit the file with notepad++ and ignore the confusing linebreaks on the status fields.
    • Affected Branches:
      MOODLE_24_STABLE, MOODLE_29_STABLE
    • Fixed Branches:
      MOODLE_29_STABLE, MOODLE_30_STABLE
    • Pull Master Branch:
      MDL-37834-master

      Description

      The ability to download and upload the grading list as a spreadsheet is a very useful tool.

      However, on windows computers the CSV file is opened and edited by Excel and there are some issues on the CSV that generate errors during the process and prevent it to be successfully implemented.

      1 - Line breaks at the status fields - Regardless the Microsoft Office version/language, the CSV file has line breaks on the "Status" fields. These line breaks are interpreted by Excel as new records, so each record is spread over several lines - take a look at the attached image.

      Note (Damyon): Additional issues have been removed from the description and split into their own bugs (linked).

        Attachments

        1. OpenOffice.png
          OpenOffice.png
          15 kB
        2. MSExcel2013.png
          MSExcel2013.png
          19 kB
        3. Image2.jpg
          Image2.jpg
          316 kB
        4. excel2013_2.9.png
          excel2013_2.9.png
          85 kB

          Issue Links

            Activity

              People

              • Votes:
                18 Vote for this issue
                Watchers:
                16 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  21/Dec/15