Importing Grades from an Excel file

Prior to uploading grades (exam results) from an Excel file confirm that the grade item into which the scores will be imported has been created in the course gradebook.

Step One:

1. In your Excel file, remove all columns with the exception of the username and raw test score from your CSV file.

2. Insert a blank row at the top of the file.

3. Save this file as a CSV file with a different name (so that you will have your original file left intact).

Step Two:

1. In your LEARN course, select Grades from the course navbar.

2. Select the Enter Grades tab from the upper left-hand corner.

3. Click the Export button.

4. Under Key Field, ensure that Username is selected and under Grade Values ensure that Points grade is selected.

5. Select the checkbox beside the grade item into which the grades will be imported from the list of grade items.

6. Click on the Export to CSV button.

7. Click on the filename and select Open.

8. Leave this file open as you will be copying and pasting field information.

Step Three:

1. Open your file from Step One 

2. Make sure column A contains the usernames and add the title “Username” to cell A1.

3. Copy the grade item heading from the gradebook export file (from Step Two) and paste it into the first row of column B, cell B1 (which should contain the raw scores).

4. Add the End-of-Line Indicator to the first row of the third column, cell C1.

5. Populate each row with a number sign (hash mark). The easiest way to do this is to add a number sign into cell C2 then, hold down the mouse button to select the remaining rows in column C until you arrive at the last student then press Ctrl+D to autofill the cells.

   Open

   

6. Save the CSV file.

Step Four:

1. In your LEARN course, select Grades from the course navbar.

2. Select the Enter Grades tab from the upper left-hand corner.

3. Click the Import button and browse for your CSV file from Step Three.

4. Select Next to finish the process.