Importing and Exporting Grades

Download this tutorial in PDF format.

Exporting Grades

1. In the Navigation bar, click Grades.

2. Go to the Enter Grades screen. Click Export.

3. Under Choose Grades to Export, Select Grade Items to export (check first box to select all or check individual grade items)

4. Click Export to CSV

5. Click the course link in the Export Grades pop up window.

6. Select Open with Microsoft Excel or Save File and click OK.  

Importing Grades

1. On the course navigation bar, click Grades.

2. Under Enter Grades, click Import.

3. Under Import Grades, click Browse to choose .csv file. Note: if you are using a Mac, make sure you have saved your CSV file as a Windows CSV.

4. Select file and click Open.

5. If you have already created grade item in eLC for the items on your import file, they will self populate. If you have not created Grade Items for these items, select Create new grade item when an unrecognized item is referenced.

Note: If you want to enter grade information using Excel, we recommend creating all of your grade items in eLC first, THEN exporting your gradebook to Excel and adding grade information. This ensures that all the appropriate header information is there when the CSV file is imported back into eLC.

6. Click Continue.

7. If no errors, click Continue (if errors occur, review sample import)

8. Preview imported grades and click Import.


Troubleshooting

What if I get an error message?