Skip to main content D. Hiden Ramsey Library, University of North Carolina at Asheville

Moodle Teacher Guide: Downloading the Gradebook and Bulk Downloading Assignments

This guide offers information, advice and resources on how to create an effective online course.

Downloading the Gradebook

 

You can use the gradebook's export/import feature to download a copy of your course grades, edit them in spreadsheet form and reload them to Moodle. It is highly recommended that you download and keep a copy of all final course grades. 

Download the Moodle gradebook

  • From the course homepage
  • Administration block > Course administration > Grades
  • Administration block > Grade administration > Export

  • Select a file format from the expanded list (If you click on Checklist, it will take you to an error that says "No suitable checklists found. You can then choose from the same list above, i.e. OpenDocument, Plain, etc.)
  • Add checkmarks beside the grade items you want included in the exported file
    • To choose all grade items, click the Select all link

gradebook export

 

  • Click Submit
  • Click Download

Bulk Downloading of Assignments

Assignments can be bulk downloaded, graded, and bulk uploaded to Moodle. When setting up the Assignment, be sure to check the appropriate settings in Assignment > Edit Settings. Under Feedback Types, check Feedback Files.

Once all the student papers have been uploaded, click on the Assignment in the Moodle course page.

Click on View/grade all submissions.

This takes you to the Assignment in the Gradebook. Choose Download all submissions.

When you click on DOWNLOAD, a window will pop up asking you to SAVE the download file. Save the Zipped file in a folder. When you click on the zipped file, it will unzip, giving you a new folder with all the papers filed in the folder. Each file in the zip will include the student first and last name at the beginning of the filename for identification purposes.

Read and grade the papers. When you save the changes, be sure to keep the file names the same. This way, Moodle will be able to replace the ungraded papers with the graded papers when you upload the completed folder.

To  zip the files, return to the folder in which your graded assignments reside. Click on all the files, right click to compress. This will create an archive.zip file.

To upload the graded assignments, return to the Assignment>grading. This time, click on Upload multiple feedback files in a zip.

 

Drag the zipped file into the space provided and click on Import feedback files.

This is the window showing the files (graded papers) uploaded.

After clicking confirm:

Once you click continue, you will return to the Assignment Gradebook page. Then you can enter grades or if you have downloaded a grading worksheet, you may also use these steps to bulk-upload the grades you've retrieved from the papers.


Students may now view the papers with your comments in them.

 

Downloading Gradebook, entering grades, and uploading Gradebook

Sometimes it can be more efficient to download the gradebook, enter the grades in the columns, and upload the completed gradebook. This can be done for one or more columns in the existing gradebook. This is NOT recommended for adding any gradebook columns.

1. To begin, from the Gradebook Module, click on the Export tab.

2. The simplest method to export is the Excel spreadsheet. (An error will appear when this page is first encountered, but clicking on the Excel - or any other method of export - will eliminate the error message.)

3. In the next window, a list of the columns in the gradebook will appear. By default, all columns are checked. You can either uncheck and check one or two columns, or leave them all checked.

4. Click on Download

5. Save the file.

6. Open the Excel spreadsheet and enter the grades in the appropriate columns.

7. SAVE the file using the same name, and choose the CSV or the Windows CSV file option.

8. Return to the Moodle Gradebook and choose IMPORT.

9. Drag the file from your computer into the space provided in Moodle. You can also click on Choose a File and select the file from your computer files.

10. Click on UPLOAD grades at the bottom of the Moodle window.

11. Change the Mapping from Email address to Email address.

12. Change the grade item mappings to map from the existing items into the same named grade items. You do not have to map the First name, Surname, email address, and attendance in this step. Steps 11 and 12 are very important. If you do not change the mapping, the gradebook will not understand how to align the csv file with the Moodle gradebook settings.

Note: in this photo example, the first assignment has been mapped but the second has been ignored. The second grade item will not reflect any changes you have made to the gradebook when you upload the grades.

13. Click on Upload grades at the bottom

14. Click Continue. Grades have been successfully uploaded.