This page provides information on; Determining the Last Day of Attendance, Downloading the Brightspace Grade Book, Downloading Attendance & Entering Final Grades in Banner
How to Display Final Grades and Release them to Students
By default, students do not see the “Calculated Final Grade” or “Adjusted Final Grade.” You can choose to turn on one of these grades in student view, the Calculated Final Grade or the Adjusted Final Grade. The Adjusted Final Grade is blank until you enter a new grade. By turning on this setting, students can view their final grades at the top of the screen when they go into Grades from the Nav Bar.
How do I show final grades to students?
Check to see if students see the correct grade: In Grades → Enter Grades → Click the Chevron next to a student’s name→ Select Preview. The final grade will appear at the top of the screen. If you don’t see the correct grade, go back through the steps above and make corrections.
Export the Gradebook to Excel
At the end of the semester, you will be asked to submit final grades to Banner and to your division.
- Click on Grade→ Enter Grades → Export
- Note if you have merged sections, you can separate them by changing the View By to a specific section and hit the Apply (button)
- Select the information you want to Export (such as Last Name and First Name) → click Export to Excel (button)
Note: at the top of this page, you will see an option to do All Users, or you can change it to a specific section. If you export by section then it will make it easier to read and enter final grades in Banner. - After the process is complete, hit the Download (button)
The file will automatically go into your Downloads Folder if you are using Chrome or Firefox
Prepare the Excel Files to Submit to Departments
- You can open the file, add the course information and your Grade Schema to the file
E.g. Course name, course prefix/number/section, CRN, Dates/Duration, Instructor name, grading schema. These can be added at the top by inserting blank rows or just adding them under the student data. Video on how to work with the Excel Sheet to add the following data.
- Save the file and include; Semester, Course Name and Prefix/number, Faculty Name.
(e.g., 22FA WEB_INTRO OPERATING SYSTEMS CIS105 SIMIELE)
Enter your Final Grades in Banner & Submit this file to your division for their records!
Determining the Last Date of Attendance
Here is a video on how to determine the last date a student submitted an assignment to your course. This is needed for attendance in an Online or HyFlex class. You need to combine this information along with in-person attendance for Blended and Hybrid courses.
Module classes that are closed:
If you had a course that ended early in the semester, you will not have access to the reports under Class Progress.
To check the last date of Assignments and Quizzes:
Go to Grades→Enter Grades (tab) → Click the chevron next to the student’s name and select View Event Log. This log shows entries made by the professor and submissions for Assignments & Quizzes made by students.
To view discussion submissions:
Determine the last discussion a student participated in the course, in Grade→ go to the discussion column, and hit the image in front of the grade. This will open the posts made by this student so you can see the last date a post was made.
These steps will give you the last date of attendance.