Follow these steps to import your grades for optically scanned tests from SharePoint into D2L.

When an optically scanned test has been scored, the scores are automatically posted to a SharePoint site. Instructors receive an email notification with a SharePoint link to the scoring files. (If you lose this link, email the IT Services TechSquad to request it again at techsquad@marquette.edu.)

1. Click or tap the link in the notification email to open the SharePoint webpage. If prompted, login with your Marquette email address and password.
2. If needed, access the SharePoint Documents screen. Identify the name of test scores you want to import into D2L. The test will have a similar name to this example: Scores_1450_ACCO_2030_0101_001.
3. A) Click or tap the three-dots icon for the scores file. A drop-down menu appears. B) Select Download.
   
4. Do not open the file you have downloaded to your device at this time.
5. Go to D2L and login.
6. Go to your D2L course site. Select Edit Course.
7. The "Course Administration" page appears. Click or tap Grades.
8. The "Enter Grades User List" page appears with the "Enter Grades" tab selected. Click or tap "Manage Grades" tab.
9. KEY STEP: You must edit the grade item name in D2L so that the grade item exactly matches the test name on the CSV file. This is very important, as the grades will not import if the grade item name and test name do not match. The test name is always the last three characters of the file name — omitting the file extension of .csv. For example, the sample CSV file is titled Scores_1450_ACCO_2030_0101_001.csv. The test name is: 001

10. To edit the grade item name in D2L, click or tap the down arrow next to the grade item. From the drop-down menu, select Edit.
    
    

11. The "Edit Item" screen appears. Temporarily change the name to the last three characters of the CSV filename, omitting the .csv file extension (in this example: change Exam 1 to 001). Click or tap Save and Close.
    

12. You return to the "Manage Grades" tab. Click or tap the "Enter Grades" tab.
    

13. The "Enter Grades User List" page appears. Click or tap Import.
    
    

14. The "Import Grades" page appears. Under "Import File," click or tap the Choose File button. Browse for the CSV file that was recently downloaded. In this example, the CSV file is Scores_1450_ACCO_2030_0101_001.csv. Click or tap the Continue button.
    
    

15. The "Step 2: Errors and Warnings" page appears. Note that fields with an error on this screen will not be imported. Click or tap the Continue button.
    

16. The "Step 3: Preview Import" page appears. Click or tap the Import button. 
    

17. The scores import into your Grade book. You return to the "Enter Grades User List" page. If the import is successful, you'll see an "Imported successfully" prompt.

18. View the scores that have been inserted in your Grade book. If you want to check the import, open the CSV file that you saved on your device. Compare scores on this file to scores imported into D2L.

19. The grade item name change in Steps 9 to 11 was temporary. Edit the grade item name again to reflect the name you want for this grade in D2L. From the "Enter Grades User List" page, click or tap "Manage Grades" tab.

20. Click or tap the down arrow next to the grade item.

21. From the drop-down menu, select Edit.

22. The "Edit Item" screen appears. Under "Name," modify the grade item name. For example, change it back to Exam 1.

23. Click or tap the Save and Close button. You're done.

Questions?

Place a D2L service request.