It will allows instructors to export and import the grades to Excel Spreadsheet. 


Exporting to Excel Spreadsheet


1. Go to Grades from left navigation menu.

2. Click Export tab then click Excel Spreadsheet tab


3. Select any or all grade items to be included in Download. (NOTE: It is highly recommended to export all grades)

4. Expand "Export formation options". If you have provided feedback in the grades, also select "Include feedback in export"


5. When finished, click 'Download'. (Window will pop-up, click OK and file should be downloaded in your Downloads folder)



Importing Excel Spreadsheet to Moodle
1. Open the spreadsheet. (It may be in Protected View. Click 'Enable Editing' to edit the document.)

2. You may now choose to add a new grade item to the end of the spreadsheet or copy/paste from another spreadsheet you have prepared. Ensure the grades entered matches with the student number.

3. 
When done editing, click 'File' > 'Save As'. Save the spreadsheet as a CSV (Comma delimited) file (Not a .XLS(X) file. You may see a pop-up message. Click 'Yes'.)


4. Now go back to "Grades" in Moodle, click Import tab and select CSV file



5. Drag and drop the CSV file you saved in Step #6 into the 'File' section. Then click 'Upload grades'

6. You will be directed to a preview of your import:

  • Identify user by: Map from choose ID number
  • Identify user by: Map to choose Username
  • By default, Grade item mappings are all set to 'ignore'.
  • For the ones you want to add, select New grade item OR if the grade item already exists in the gradebook, select the grade item.

7. Once done, click 'Upload grades'.


8. You should see a message display that your grade items are imported successfully.

 


Suggestion:


We suggest using a course space over on the Development site to experiment with the spreadsheet upload process until you're comfortable.

  1. Create a sample spreadsheet/upload file with several assignment marks for a couple of our test students (Sam Student and his siblings, Sally, Syd and Singer)
  2. Add the test students to your Development course
  3. Upload the spreadsheet to your test course
  4. View the marks, both as the teacher and as the students to make sure all is as it should be
  5. Repeat over on the main Moodle site. (You may want to hide the Gradebook from students while you're working on it.)
    Edit settings > Appearance > Show gradebook to students: No

 




Creative Commons License

This work by Kwantlen Polytechnic University (KPU) is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.