Instructor Center Resource Guide: Importing Grades from Outside of Instructor Center

Step 1: Once final grades are prepared and complete in D2L, select the Import Grades from D2L button.

Notes: 

• D2L does not capture Last Date of Attendance information. When a failing grade is imported, in UAccess you must then choose the Student Attendance drop-down and (if required) enter the Last Date of Attendance.
• Incomplete grades cannot be entered in D2L and need to be entered directly through the grade roster in Instructor Center. 

Refer to the Assigning a Failing Grade section for more information on the requirements and fields associated with failing grades. 

For additional help, email D2L@arizona.edu, call 520-626-6804, or go to D2L's Help Page.

Step 1: Select the Import Grades from File button to upload your comma separated value (.csv) file.

Step 2: A message window pops-up, which provides more information about the import grades from file option and file setup.

Select OK.

Step 3:  The file type must be a comma separated values (csv) file in the following format. Do not include headers.

Column A: Student ID

Column B: Grade Earned

For failing grades, additional columns are required:

Column C: Attendance Code

Column D: Last Date Attended (only when awarding a failing grade for a student who stopped attending)

Attendance Codes:
C=student completed term, earned failing grade
N=student never attended
S=student stopped attending after MM/DD/YYYY

The following example shows how to report last date of attendance for a failing grade of E - note that you will only enter the date the student last attended for the S-code (student stopped attending after MM/DD/YYYY).  The C-code and N-code do not require a date:
12345678,E,C
23456789,E,N
34567891,E,S,03/02/2024

Note: You can import an incomplete grade through the file import but you cannot import additional required fields. Once the file import is complete, enter the required information on the Grade Roster.  

Your import will overwrite any grades that you may have already entered but not yet posted into your grade roster. The import will not overwrite previously posted grades that appear in the Official Grade column. For example a W grade will not be overwritten.

Step 4:  Select Choose File to upload the file. Then, select Upload. 

Once the file is uploaded, a message will appear with the number of grades that were successfully imported. Next, an error message will appear if any grades were not successfully imported.