1. Before you import your grades into Moodle from Excel, ensure your Excel document has similar properties and columns as the image below:
You may have a column for reference that lists the students’ names, which should be followed by a column that Moodle can map the grades to. In this case, the students’ email is the item of reference. The other columns should include the titles of other grades, assignments, quizzes, etc.
2. When you are ready to import the spreadsheet to Moodle, save the Excel document as a .csv file as follows:
Note: If you are using Excel 2007 you will want to click on the “Office” button, go to “Save As” and select “Other Formats” to find .csv.
3. On your Moodle course page, navigate to Settings >> Course administration >> Grades. This will take you to the grader report. From here go to Settings >> Grade administration >> Import > CSV file. Here you may upload the file. After doing so select “Upload Grades”.
4. The next page will include an Import Preview that will display up to the first 10 rows of data so that you may ensure everything looks correct.
5. Below Import Preview you will find the Identify user by section. If you choose to map grades by email, as in this example, for the Map from drop-down, select Email (referecing the second column of the spreadsheet) and for the Map to drop-down select “useremail.” There are also options to map by “username”, “userID”, and “useridnumber”, and if you choose to map by these options your column heading in your spreadsheet should match accordingly. This will correctly match the grades in the .csv file to the students’ Moodle accounts.
6. Underneath this you will find Grade item mappings, which allow users to select how to designate each column in the spreadsheet to Moodle grading. There are three basic options: you can ignore a column, map it to a pre-existing assignment/quiz, or create a new grade item.
a. Select “ignore” for the Name and Email fields. Moodle already has columns for these.
b. If you are importing a quiz or assignment that has already been added to Moodle you will want to select the appropriate grade item from the drop-down menu. For example, if you have an offline activity already set up for a grade item you are importing, you should match the grade item to its existing referent accordingly, which will be listed in the drop-down menu.
c. For all other grades which you are importing for the first time without a pre-existing Moodle referent, select new gradeitem from the dropdown menu. This will create grade categories for each new assignment you entered from the spreadsheet.
When you are finished mapping grades, select Upload grades.
7. Two important things to keep in mind:
a. If you import grades and map them to a pre-existing assignment you will not be able to edit those grades using the assignment tool interface. Any changes will have to be made from the Grader Report screen.
b. If you map the .csv file to a pre-existing Moodle assignment or quiz it will overwrite any grades that may have previously been entered.