department menu

End of Semester Gradebook Tasks

Why Do This?

It is important to verify all grades are correct in Cougar Courses before manually entering official grades in MyCSUSM (PeopleSoft). If an incorrect grade is entered in MyCSUSM, paper grade forms are required to request a grade change.

Contents

 

Check the User Report

  1. In the Administration block, select Gradebook setup.

 course administration block with gradebook setup link

  1. Select the View tab, and then select the User report tab (on the far right).

 view tab, user report sub-tab

  1. Under "Select all or one user" drop down menu in the upper right, choose "All users."  You will see the grades and totals for each student.

 Select all or one user drop down

  1. Set to view the report as “Myself” in the upper right.

 view report as drop down, selecting myself

  1. For each student, verify all items are visible. If grade items are grayed out, that means they are not visible to students.

 grayed out grade item

  1. Then, set to view the report as “User” in the upper right. This will show you exactly what each student sees.

 view report as drop down, user selected

  1. For each student, verify all items and totals are visible. If a total is not visible, there will be a dash for it in the Grade column.

 course total hidden, there is a dash instead

 

Grade Item Not Visible

  1. Is the item an activity such as Assignment, Quiz, Forum, etc.?
  • If so, make sure it is visible on the course homepage. Turn editing on and for the item select Edit and then Show. If you see Hide instead of Show, that means the item is already visible.

 course homepage, select edit and then show

  • If it is a Quiz, go into the settings and the Review Options section. Make sure the box for Points is checked in all available columns.

 review options section, points checked

  • If it is a Turnitin Assignment, the item will be hidden until the Post Date. To make visible, go into the settings and change the Post Date.

 turnitin dates

  1. Is it still not visible or is it a manual grade item?
  • In the gradebook, go to Setup tab and then the Gradebook Setup tab.

setup tab, gradebook setup sub-tab

  • Select Edit for that item and then Show. If you see Hide instead of Show, that means the item is already visible.

on setup tab, click edit and then show

  1. Is it still not visible?
  • Go to the Grader Report (under the View tab) and Turn editing on (upper left).

 turn editing on button

  • Scan through all the cells and verify that all the eye icons are open. An eye with a slash through it means the grade is hidden.

 eye icons

  • If closed, click the eye icon to open. Scroll to the bottom left and click the Save changes button.

 save changes button

 

Course/Category Total Not Correct

Likely causes:

Extra credit items not set as extra credit:

There are items that should be in a category, but are not:

There are unused grade items being counted in the total:

  • If you are not using grade items you will need to either delete the item, edit the item to make it worth no points, or put it into a category that is weighted to zero.
  • To delete
    • If it is an activity (Assignment, Quiz, Forum, etc.) you must delete it from your course homepage. With editing turned on, go to the item, click the three vertical dots, and then Delete.
    • If it is a manual grade item, you can delete from the Gradebook Setup tab. Go to the item and click Edit and then Delete.
  • To make the item worth 0 points (for activities)
    • Go to the course homepage and for the item click the pencil icon underneath. In the Grade/Ratings section change the Type to None. For quizzes, go to the Edit Quiz page and change the Maximum grade to 0. Save.
  • To put them into a weighted category

Categories are set to an incorrect weight:

  • To fix:
    • On the Gradebook Setup tab, go to the category title and click Edit and then Edit Settings.
    • Make sure the Aggregation is correct. If you are weighting just the category, choose “Simple weighted mean of grades.” The items within that category will be automatically weighted based on their point totals. If you are weighting the category and need to manually set the weight of each item within the category, choose “Weighted mean of grades.”  
    • If using Simple Weighted Mean of Grades or Weighted Mean of Grades, make sure the Maximum grade is correct. For example, if the category is worth 40% of the final grade, enter 40 for Maximum grade.
    • Save changes.

There are ungraded items being excluded from the total:

  • To fix:
    • On the Gradebook setup tab, for each category (including the top one with your course name) select Edit and then Edit Settings.
    • Under Aggregation, click Show More
    • Uncheck the "Exclude empty grades" box.
    • Save changes.
    • Repeat this for each category.

Items are unintentionally being dropped/excluded from the total:

  • By default hidden items are exlcuded from the totals.
  • To fix:
    • On the Gradebook Setup tab click on the Course Grade Settings tab.
    • Scroll to the Overview Report section. Set "Hide totals if they contain hidden items" to "Show totals including hidden items."
    • Scroll down to the User Report section. Set "Hide totals if they contain hidden items" to "Show totals including hidden items."
    • Save changes.

 

Show Final Letter Grade

By default the course total for each student is shown as points. You might want to also display the letter grade that corresponds to this point value.

To display a letter grade for the course total:

  1. On the Gradebook Setup tab, select Edit and then Edit Settings for the very topmost item (your course category).

for topmost item, click on edit and then edit settings

  1. At the bottom of the Category Total section click Show More.

 show more link

  1. Change the “Grade display type” to the desired option. Real means points. To show points and the corresponding letter grade choose "Real (letter)"

 grade display type options

  1. Save changes.

 save changes button

 

Change Columns Displayed

By default the User Report shows the columns Calculated Weight, Grade, Range, and Feedback for each item and category. By default the Grade is displayed as points.

To add/hide columns:

  1. Select the Setup tab and then the Course Grade Settings tab.

 gradebook setup tab, course grade settings sub-tab

  1. Go to the User Report section. Besides the default columns, the additional options include:
  • Rank
  • Percentage
  • Average
  • Letter grades
  • Contribution to course total
  1. To add a column, choose Show from the drop down for that item. To hide a column, choose Hide.

 user report options. choose show from the drop down

  1. Save changes.

 save changes button

 

Export Gradebook As An Excel Spreadsheet

You might want to keep a copy of the gradebook for your records, and to have it to reference as you enter official grades in MyCSUSM.

  1. While in the gradebook click on the Export tab and then on the Excel Spreadsheet

 export tab, and excel sub-tab

  1. By default all grade items and totals will be exported. Uncheck the boxes for the items you do not want exported.
  1. For “Export Format Options” check the boxes for the information you want exported. Real refers to points.

 export format options

  1. Click the Download

 download button

  1. Save the file to your computer.