Moodle FAQs

A collection of frequently asked questions (FAQs) about Moodle at EMU.

Importing your Gradebook from Excel (.csv file)

< Previous | Main | Next >

To import your gradebook from Excel the first thing you'll need to do is download the Excel file from the Grader Report.

Open the Course and click on the Grades link in the Administration Block.

Click on the Export Tab to create an Excel document that will be used to input grades.

On the Export Tab choose Excel Spreadsheet and then click the Download Button

Save the Excel Document to your computer. 

This document will list all of the assignments and activities in the course.

For any of the assignments you can enter the grades that you want to import and then save the file as a .csv file.

To import the grades into Moodle open the 

1. Navigate to the Adminstration Block and choose Import - CSV File

Click Choose a File and navigate to the CSV file created in the previous step (alternatively you can use the drag and drop method from the file explorer)

Set the Verbose scales to No.

Click Upload grades.

Under Identify user by set Map from to ID number and Map to to useridnumber.

Scroll down and map your assignments to the correct assignments and don't map anything else.

Click Upload grades.

< Previous | Main | Next >