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

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

XMLWordPrintable

    • MOODLE_24_STABLE, MOODLE_29_STABLE
    • MOODLE_29_STABLE, MOODLE_30_STABLE
    • MDL-37834-master
    • 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.
    • 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.

      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).

        1. excel2013_2.9.png
          85 kB
          Jun Pataleta
        2. Image2.jpg
          316 kB
          Antonio Vilela
        3. MSExcel2013.png
          19 kB
          Ulrik McArdle
        4. OpenOffice.png
          15 kB
          Ulrik McArdle

            poltawski Dan Poltawski
            avilela Antonio Vilela
            cameron1729 cameron1729
            David Monllaó David Monllaó
            Jun Pataleta Jun Pataleta
            Votes:
            18 Vote for this issue
            Watchers:
            16 Start watching this issue

              Created:
              Updated:
              Resolved:

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