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:
- Make sure the term selected is the term you wish to grade.
- Increase the number of rows to more than the number of classes you are teaching for the current term.
- Make sure only “Final” is selected for both the Available Views and Default View. Leave all other boxes unchecked.
- Click on “Apply” at the bottom of the channel, then click “Back” at the bottom of the box to return to the Faculty Grade Assignment channel. You will now be able to see the classes you need to grade. Occasionally, you’ll need to click on “more” at the bottom of the channel to see additional courses. Follow remaining instructions.
- Assigning an F grade: When assigning an F, you are required to enter the Last Attend Date (aka: Last Date of Attendance). If you do not enter the Last Attend Date, you will not be able to submit/save the F or U/F grade until the date is entered.
- Assign an F grade using the drop down menu next to the student’s name.
- Enter a Last Attend Date: In the Last Attend Date column, enter the date in format MM/DD/YYYY. It you do not enter the date in this MM/DD/YYYY format, you may receive an error message.
- No Shows: If a student never attended, did not participate in class prior to census, or did not submit a content based class assignment prior to the census date, enter a “0.00” (zero) in Attend Hours column. Do not enter an F or a Last Attend Date. For a definition of what is considered a “content based course assignment” in your discipline, please contact your Department Chair.
- Incomplete Grade Contracts: Please submit signed Incomplete Contracts to your Department Dean by the last day of class to ensure they are processed by the grades due date. The Incomplete Contract is located under the Faculty tab in the Faculty Forms channel. You will not be able to enter an incomplete grade online. The Records Department enters the “I” grade once the contract is signed by the Dean.
Step 5
Next to the course you wish to grade click on the or symbol and this will bring up your grade roster.
Step 6
Grade every student using the drop down menu next to their name with the earned grade (Grade Scale below). If you do not grade every student, you will see a symbol which indicates grades are missing for that course. Grading Scale: A = Excellent, B= Above Average, C = Average, D = Below Average, F = Failing