Import Scantron Grades into D2L

This method is recommended, as it allows you to verify the grade item setup prior to import, helping ensure accuracy and alignment with your gradebook.

1. Before importing grades into D2L, ensure you have a Grade Item created. Check the Name and Maximum Points value of the Grade Item you plan to import grades into by navigating to the Manage Grades page. To prevent students from viewing grades immediately after import, ensure the item is Hidden before proceeding. Click on its name. From the Properties tab, copy the Name and note the Maximum Points value. Confirm that this value matches the total possible points on the scantron exam. Once you have gathered these details, you may close the window.
   
   
   
   
2. Open the <COURSE_NUMBER_D2L.txt> file that you have downloaded earlier. (Recommended applications are Notepad on a PC and TextEdit on a Mac.) To make sure scores are uploaded to the correct column in the D2L Gradebook, one of the headings in the .txt file needs to be updated so it matches the name of the Grade Item in D2L. In the first row of text, find the entry listed as “Scanned Exam MM-DD-YYYY“. Change this text to the name of the Grade Item (eg Midterm Exam), then save the file. For example:
   
   
   
   
3. Return to the D2L course and navigate to the Enter Grades page. Click the Import button.
   
   
   
   
4. Click the Choose File button and browse for the .txt file you have just saved, then click Continue.
   
   
   
   
5. Click Continue if no errors are presented.
   
   
   
   If errors appear, note any invalid Usernames highlighted in red. These typically result from students entering incorrect UCID numbers or withdrawing from the course. You can follow up with these students and manually enter their grades later if needed. Once you have reviewed the list, click Continue to proceed.
   
   
   
   
6. The Preview Import screen will display how student scores will be updated upon upload. Click Import to finalize the process.
   
   
   
   
7. After importing the grades, double-check the results to ensure accuracy. If you administered multiple versions of the exam, repeat the steps above for each corresponding .txt file. This will allow you to upload all student grades into the same Grade Item. For any students whose grades are missing, refer to the additional reports included in the email to identify the students and their scores. If available, manually enter their grades into D2L. Once you have verified all grades and are ready for students to view them, make the Grade Item Visible.
   
   

1. Open the <COURSE_NUMBER_D2L.txt> file that you have downloaded earlier. (Recommended applications are Notepad on a PC and TextEdit on a Mac.) To ensure the newly created Grade Item in D2L has a clear and meaningful name, replace the default entry “Scanned Exam MM-DD-YYYY” in the .txt file with a descriptive title — such as “Final Exam”, then save the change. For example:
   
   
   
   
2. Return to the D2L course and navigate to the Enter Grades page. Click the Import button.
   
   
   
   
3. Click the Choose File button and browse for the .txt file you have just saved. Check the box beside Create new grade item when an unrecognized item is referenced, then click Continue.
   
   
   
   
4. On the next screen, ensure Create New Grade Item is checked and the Type is shown as Numeric, then click Continue.
   
   
   
   
5. If your Gradebook uses the standard Weighted Grading system, enter the Maximum Points (i.e. the total possible score for the scantron exam), and specify the Weight this assessment item should carry toward the Final Grade. Click Continue.
   
   
   
   
6. Click Continue if no errors are presented.
   
   
   
   If errors appear, note any invalid Usernames highlighted in red. These typically result from students entering incorrect UCID numbers or withdrawing from the course. You can follow up with these students and manually enter their grades later if needed. Once you have reviewed the list, click Continue to proceed.
   
   
   
   
   
7. The Preview Import screen will display student scores that are ready to be uploaded to the new Grade Item. Click Import to complete the process.
   
   
   
   
8. After importing the grades, take a moment to verify the results for accuracy. Please note that in this case, grades are immediately visible to students upon upload. If you administered multiple versions of the exam, refer to the section titled Importing Scantron Grades into an Existing Grade Item in D2L for guidance on uploading subsequent .txt files. For any students whose grades are missing, consult the additional reports included in the email to identify the students and their scores. If the information is available, you can manually enter their grades directly into D2L.