Answering Your Gradebook Questions

*This article is part of the DLE WEEKLY UPDATE series.

Are you wondering what the student view of the grades looks like?

Go to your Grades/Enter Grades tab, click on the chevron beside the name of one student, and then click Preview. You (the instructor) control the students’ view of the grades (points, percentage, letters) from your Grades menu, Settings/Org Unit Display Options tab.

How do I manually enter student grades in the gradebook (Grades/Enter Grades)?

• How do I enter grades for all columns, for one particular student?
  Click on the student name in the Last Name/First Name column. This view also allows you to enter comments for each grade.
• How do I enter grades for all students, for one particular column?
  Click on the chevron for the title of the column and then choose Enter Grades
• How do I use the gradebook as a spreadsheet?
  Go to Grades/Enter Grades and click on the Switch to Spreadsheet view button. Click Save to save the changes.

How do I remove a gradebook column?

Go to Grades/Manage Grades and click Delete from the More Actions button. In the next screen, select the grade items you would like to remove and click Delete. Note that you can ONLY remove columns that are NOT associated with any activities. For columns with associations, you need to go to that particular activity (quiz, assignment or discussion topic) and remove the association from the Grade Item drop down list (choose NONE). To figure out which activity the grade item is associated to, in the Manage Grades screen, click on the question mark icon in the Association column

Want to reorder the columns in the gradebook?

Go to Grades/Manage Grades tab/More actions/Reorder.

I have different points possible displaying in the gradebook for the columns associated with quizzes and assignments. What do I do?

If there are no submissions for your quiz or assignment, then to correct this, you just need to edit the associated column from Grades/Manage Grades and adjust the points.
If you already have graded the assignment or quiz, this is what you need to do:

• Assignment: You published the grades, but noticed that the column in the Grades has different maximum points than the assignment. Unfortunately, once you edit the column and change the points, the existing grades won’t get automatically adjusted. You will need to go to Activities/Assignments/View Submissions and Update the grade for each student (the same screen you use when you first grade the assignment and publish grades).
• Quiz: After you edit the maximum points for the column, in Grades, go to Activities/Quizzes/Grade/Users tab. Select all the students and then click Publish Feedback. Click Save and Close and then go back to the same screen and hit again Publish Feedback. This will force the grades to be readjusted in the gradebook.

Troubleshooting Final grades:

• Final calculated grade showing a value out of a percentage different than 100?
  Switch to the Treat ungraded items as 0 option, from Grades/Settings/Calculation Options tab, under the Grade Calculation label
• Final calculated Grade not automatically updating?
  Make sure you have the Automatically keep final grades updated option checked off from Grades/Settings/Calculation Option tab
• Final Calculated Grade not visible to students?
  Go to Grades/Enter Grades tab and click on Enter Grades from the Context menu for the Final Calculated Grade column. Then select all the rows and click on the Realease/Unrelease option.
• I get error messages that the weights are not adding up to 100%.
  From Grades/Manage Grades, select all columns and click on Bulk Edit. Adjust the weights and click Save.
• Grades not displaying in columns for completed activities.
  Check if your quizzes/assignments/topics have gradebook columns associated. Watch this video from D2L on troubleshooting final grades.

Need to keep a copy of the student grades?

If you ever need to save a paper copy of the students grades, this is how you can export it to a file that you can open in Excel. Note that, if you use a combined course and you need to download students from one particular section, you will need to filter first by the section.

How do I hide a gradebook column?

There are different types of gradebook columns in Brightspace, and each has a different way of hiding its content from student view.

• Hide Final Calculated Grade/Final Adjusted Grade columns – Click here for detailed instructions on how to hide these columns.
• Hide a column that is NOT associated with any online activity (for instance, when you require to enter grades for course participation) – While in Grades/Enter Grades view, click on the chevron for the title of the column and choose Edit. Click on the Restrictions tab and then on Hide from Users. You can also use dates to restrict the view of the grades for a limited amount of time.
• Hide a column associated with online activity (quiz/assignment/discussion) – As these activities are linked to gradebook columns, just hiding the columns in the gradebook won’t actually hide the grades from students. They still have the option to view their grades by going to the Activities menu and then to that particular activity, if that activity is still visible. Follow the steps from number 2., but also make sure you hide the quiz/assignment/ discussion, or have the grades set up as draft and not published.

Note: Please make sure you hide the gradebook columns prior to you entering the grades!