End of Semester Grades in D2L


The Instructional Unit has identified the following lifelong/workplace skills that are the foundation for your course of study at CCA: Communication, Critical Inquiry, Intra/Interpersonal Responsibility, Quantitative Reasoning, Technology, and Aesthetic Perception. Of these skills, this course will focus on.

Part 1: D2L Grade Release

Step 1

Navigate to the Grades area from the Assessment dropdown menu.


Step 2

Scroll to the far right of your gradebook until you reach the Final Calculated Grade column. Select Grade All from the column’s dropdown menu.


Step 3

Once you’ve navigated to the Final Grades page, complete the following three steps using the dropdown menu next to Final Grades:


Step 4

Select the Recalculate All option from the dropdown menu, and then select all grade items in the new window that opens.

  • Click the Calculate button on the bottom left hand side of the window
  • Click the Yes button in the confirmation window.

Step 5

Select the Transfer All Transfer All button from the dropdown menu, and then click the Yes button in the confirmation window to confirm transfer of the Final Calculated Grade to the Final Adjusted Grade column


Step 6

Select the Release All button from the dropdown menu and click the Yes button to confirm release of final grades to students in D2L.


Part 2: D2L Grade Export

Step 1

Remain on the Enter Grades tab and click the Export button.


Step 2

In the User Details field, checkmark the boxes next to Last Name and First Name, and ensure all grade items are selected to be exported. Then click the Export to CSV button.


Step 3

A new window will appear containing a link to your exported file. Click on the link to open the file with the appropriate program (Microsoft Excel is generally the default program).


Step 4

After your file has opened, you will need to create an additional column with the final letter grade of each student. To do this, scroll to the far right of the spreadsheet until you have reached the column titled End of Line Indicator. Click on the heading of this column and rename the column Final Letter Grade.


Step 5

Enter each student’s final letter grade (A, B, C, D, or F) into the Letter Grade column you just created.


Step 6

To save your export, click on the File tab at the top of the spreadhseet document and click Save As . You should save your file in a .CSV .CSV format. You should title your file in the following manner: Subject * Course * Section * Grades *Last Name * First Initial *Semester Example: ENG 121 325 Grades Smith E Fall 2012


Step 7

Send your exported grades (and attendance) to your department’s administrative assisstant.


Part 3: Final Letter Grade in Banner

Step 1

Log in to your MyCCA account by entering your User Name (your S number) and your password.


Step 2

Click on the Faculty tab.


Step 3

Go to the Faculty Grade Assignment channel on the right hand side. You will see the classes you need to grade within this channel. If do not see your classes, this generally means you need to change the view preferences within this channel. To change the Faculty Grade Assignment channel preferences, please follow instructions under Step 4.


Step 4

How to adjust your view preferences on the Faculty Grade Assignment channel: Click on the small pencil on the top right hand corner of the Faculty Grading Assignment channel and complete the following steps: