1. Setting up your Gradebook 
    1. Getting Started
  2. Set up a grade category
    1. To Set Up a Grade Category:
  3. Set aggregation type
    1. Aggregation Types
  4. Adjust grade category or item settings
  5. Moving grade items or categories
  6. Showing/hiding grade items or categories
  7. Adding manual grade items
  8. Custom Grade Calculations (Advanced)
  9. Gradebook FAQ

Your gradebook (Grader Report) is a cuLearn tool for viewing, managing, and releasing student grades. All cuLearn courses come with a built-in gradebook that instructors can customize to display course grading information. Once an instructor or TA has entered and released grades in the gradebook, students can view their grades in their own individual grader reports.

How do I access the gradebook?

How do I navigate the gradebook?

Setting up your Gradebook 

When you add a graded cuLearn activity to your course, such as an assignment, quiz, or forum, a grade item (column) is automatically added to your gradebook. For assessments that are not linked to a cuLearn activity, such as an offline midterm, you need to add the grade item manually. The setup of your gradebook determines how the grades appear to students, as well as how the course total is calculated.

Getting Started

You can configure the setup of your gradebook under the Setup tab of your gradebook (see screenshot below). For an overview of the gradebook layout, see Navigating Gradebook.

To setup your gradebook:

  1. Set up grade categories to group similar assessments together (ex/ Quizzes)
  2. Set the aggregation type to determine how the course total is calculated
  3. Add manual grade items for offline assessments
  4. Adjust your settings preferences for individual grade items or categories
  5. Move grade items and categories to re-arrange your gradebook
  6. Show/Hide grade categories or items from students to control the visibility of your gradebook

Set up a grade category

A grade category aggregates grade items and calculates a single grade according to a chosen aggregation method. For example, you might establish a grade category for “quizzes” and set up your gradebook to aggregate the four quizzes in your course to calculate the grade for that category as a “mean of grades”; gradebook will then calculate the mean (or average) of the quizzes category by adding all grades for the four quizzes and dividing by four. The result of this calculation will be used as the value for the “quizzes” category in your Course total.

To Set Up a Grade Category:

  1. Log in to cuLearn using your MyCarletonOne credentials.
  2. Click on your course link.
  3. In the navigation menu on the left side of your course page, click Grades.
    NOTE: If you cannot see the navigation menu, you may need to expand it first. To open the navigation menu, click on the hamburger button on the top-left side of your course page
  4. Click the Setup tab, then Gradebook Setup (See screenshot below). 
  5. Scroll to the bottom of the page and click the Add category button.             
  6. Under the Grade category heading:
    1. Provide a name for your category, such as “Quizzes,” or “Participation.”
    2. Click Show more… to access the following settings options:
      • Aggregation – You can set the aggregation type for a particular category, independent of the course total. The options are identical to those of the course total (see Set Aggregation Type for more information on aggregation types).
      • Do not exclude Empty grades – It is highly recommended that you leave this box unchecked. This option will exclude unmarked grade items from the category in the category total calculation
        NOTE: If you select this option, you should be sure to enter a zero (0) score for any missed or incomplete assessments or the assessment will not be counted towards the category total. If a student did not complete anything in the category, and you leave the scores for category items ungraded, that student would end up with a score of 100% for the category with this setting.
      • Keep the highest – Allows you to retain a selected number of highest grades for the category. This option will have no effect if you activate the “Drop the lowest” setting.
      • Drop the Lowest – Allows you to exclude a selected number of lowest grades in the category from the category total.
  7. Under the Category total heading, click Show more… to configure the following optional settings:
    • Category total name – Enter a name for your category total (ex/ Assignments Total).
    • Item info – Enter a description or details about the category.
    • Select the Grade type for this category: Value, Scale, Text, or None.
      NOTE: It is recommended that you choose “Value” as your grade type for easy calculation of grades. If you choose Scale as your grade type, you will then be able to select a type of scale. Avoid selecting letter grade as a scale for the grade type as we have had reports of technical problems with this setting.
    • Maximum grade – Enter the maximum grade (total point value) for the category when using the value grade type.
    • Minimum grade – Enter minimum grade for the category when using the value grade type.
    • Grade to pass – Enter the minimum grade required to pass.
    • Overall decimal points – Select how many decimal points you want to display in the category total; the default is two.
    • You can hide grades from students by selecting the Hidden check box.
  8. Click Save changes.

You will automatically be taken back to the Gradebook Setup tab of your gradebook. 

Set aggregation type

The aggregation of your gradebook determines how the course total is calculated. cuLearn’s gradebook can calculate your Course total by aggregating grade items a number of different ways, including: Mean of grades, Weighted mean of grades, Simple weighted mean of grades, or Natural.  You can set the weights for individual grade items or grade categories.

 ***It is highly recommended that you leave your aggregation type as the default setting, which is Weighted Mean of Grades.

To set the aggregation type:

  1. Log in to cuLearn using your MyCarletonOne credentials.
  2. Click on your course link.
  3. In the navigation menu on the left side of your course page, click Grades.
    NOTE: If you cannot see the navigation menu, you may need to expand it first. To open the navigation menu, click on the hamburger button on the top-left side of your course page
  4. Under the Setup tab of your gradebook, go to Gradebook Setup.                     
  5. Under the Actions column, click the Edit drop-down menu and select Edit Settings (see image below)
  6. You will be taken to a new page where you can customize the Grade Category and Category Total. Under Grade category, click Show more to expand a list of options (see images below).
  7. Click the Aggregation drop-down menu, and select one of the following options:
  8. Click Save changes.

Below, you will find a brief description of how each setting aggregates grades

Aggregation Types

Weighted mean of grades (RECOMMENDED)

Setting the aggregation to Weighted Mean of Grades will calculate the course total according to the weight you assign to grade items or categories. For example, you may have a midterm in your course worth 100 marks, but it only weighs 15% of the overall course total. In this case, you will want to choose Weighted Mean of Grades as your aggregation type.

To set the weight of individual grade items:

  1. Log in to cuLearn using your MyCarletonOne credentials.
  2. Click on your course link.
  3. In the navigation menu on the left side of your course page, click Grades.
    NOTE: If you cannot see the navigation menu, you may need to expand it first. To open the navigation menu, click on the hamburger button on the top-left side of your course page
  4. Under the Setup tab of your gradebook, go to Gradebook Setup.                     
  5. In the Weights column, enter the corresponding percentage weight value for each of the grade items and/or categories in your course.
  6. Click Save changes.
NOTE: You must ensure that the sum of the assigned weights adds up to 100. Gradebook will not inform you of any calculation errors here, so please double check!

Mean of grades

The mean of grades calculates the sum of all grade items and/or categories in a course and divides the sum by the number of grade items or categories. It provides you with an “average” of all course assessments.

Simple weighted mean of grades

Aggregating by simple weighted mean of grades will calculate the course total by giving more weight to items that have higher maximum grades and less weight to those with lower maximum grades. A midterm worth 40 points, for example, would actually be worth more in the course total than a final exam worth only 30 points in this aggregation method.

Essentially, the weight of each item is calculated as the maximum grade for the grade item and/or category. The course total is calculated as the sum of the grades for each item or category divided by the sum of the maximum grades for each item.

Eg. Research paper = 40/75
Exam = 55/80
Quiz = 15/34
Sum of grades for each item = 40 + 55 + 15 = 110
Sum of the maximum grades for each item = 75 + 80 + 34 = 189
Course total = 110/189 = 0.582 = 58.2/100 = 58.2%

NOTE: Do not use to calculate extra credit. Ensure that all “extra credit” boxes in the category options are unchecked for successful calculation of course total.

Natural

The natural aggregation method is very similar to simple weighted mean of grades. Natural aggregation calculates the sum of maximums from all aggregated items. Unlike simple weighted mean of grades, however, it does not automatically calculate a mean based on the sum of grades and sum of maximum grades for each item. In the example calculation above for Simple Weighted mean of grades, then, Natural aggregation would display the course total as 110/189.

Adjust grade category or item settings

You can customize the settings options for individual grade items and categories in your gradebook.

To edit a grade item or category’s options:

  1. Log in to cuLearn using your MyCarletonOne credentials.
  2. Click on your course link.
  3. In the navigation menu on the left side of your course page, click Grades.
    NOTE: If you cannot see the navigation menu, you may need to expand it first. To open the navigation menu, click on the hamburger button on the top-left side of your course page
  4. Under the Setup tab of your gradebook, go to Gradebook Setup.                     
  5. Under the Actions column, click Edit in the same row as the item or category and select Edit Settings.
  6. You will be taken to a page where you can configure the settings for the grade item or category.
  7. When you are finished configuring your settings, click Save changes.

Moving grade items or categories

You can re-arrange your gradebook by moving the grade items or categories, or moving a grade item in or out of a category.

To move a grade item

  1. Log in to cuLearn using your MyCarletonOne credentials.
  2. Click on your course link.
  3. In the navigation menu on the left side of your course page, click Grades.
    NOTE: If you cannot see the navigation menu, you may need to expand it first. To open the navigation menu, click on the hamburger button on the top-left side of your course page
  4. Under the Setup tab of your gradebook, go to Gradebook Setup.                     
  5. Click on the double-headed arrow next to the item or category name you want to move
  6. You will see boxes appear above and below each item/category in your gradebook (see screenshot below).  When you hover your cursor over a box, you will see the message “Move to Here“. Identify where you would like the grade item/category to appear, then click on a box to move your item to that location.   

Your gradebook setup page will automatically reload with the grade item in your new selected location.

To move a grade item in or out of a category

  1. Log in to cuLearn using your MyCarletonOne credentials.
  2. Click on your course link.
  3. In the navigation menu on the left side of your course page, click Grades.
    NOTE: If you cannot see the navigation menu, you may need to expand it first. To open the navigation menu, click on the hamburger button on the top-left side of your course page
  4. Under the Setup tab of your gradebook, go to Gradebook Setup.                     
  5. Under the Select column, click the checkbox next to the item you want to want to move to a new category.
  6. Scroll down to the Move selected items to drop-down menu at the bottom of the setup table, and select the name of the category you want to move the item into.       
    NOTE: If you want to move the grade item from a category to the main gradebook, you can select the course name from the drop-down menu.

Your gradebook setup page will automatically reload with the grade item in your new selected category.

Showing/hiding grade items or categories

By default, when you add a new grade item to your gradebook, it is automatically visible to your students (this is true for the final course total column as well).

In the Gradebook setup tab, you can also choose to Hide or Show all or individual grade items and categories.

To Hide a grade item or category from students:

  1. Log in to cuLearn using your MyCarletonOne credentials.
  2. Click on your course link.
  3. In the navigation menu on the left side of your course page, click Grades.
    NOTE: If you cannot see the navigation menu, you may need to expand it first. To open the navigation menu, click on the hamburger button on the top-left side of your course page
  4. Under the Setup tab of your gradebook, go to Gradebook Setup.                     
  5. In the Actions column, click on the Edit drop down menu beside the item you wish to hide.
  6. Select “Hide” to hide the Grade item from the students (see screenshot below).

The grade item/category should appear greyed out when it is hidden (see screenshot below)

To Show (release) the grade item or category to students:

  1. Under the Actions column, click on the Edit drop down menu beside the item you wish to hide.
  2. Select “Show” to unhide the Grade item from the students.

NOTE: If you have made your grade item/category visible, but your students still cannot see their grades, it is possible you have hidden your entire gradebook in the Course settings.

To reveal your gradebook to your students:

  1. Go to your main cuLearn course page.
  2. On the top-right side of the page, click on the Gear Icon.
  3. In the drop-down menu, select Edit Settings.               
  4. Click on the Appearance tab (approximately halfway down the page).
  5. Make sure that Show gradebook to students, is set to Yes.         
NOTE: If this setting is set to “No”, your gradebook will NOT be revealed to students regardless of whether you have made grade items/categories visible on the gradebook setup page.

Adding manual grade items

When you add a cuLearn activity to your course, such as an assignment, quiz, or forum, a grade item column will automatically appear in the gradebook.  For course assessments that are not linked to a cuLearn activity, such as student presentations or an offline midterm, you will need to manually add a column to the gradebook.

To add a grade item to your gradebook:

  1. Log in to cuLearn using your MyCarletonOne credentials.
  2. Click on your course link.
  3. In the navigation menu on the left side of your course page, click Grades.
    NOTE: If you cannot see the navigation menu, you may need to expand it first. To open the navigation menu, click on the hamburger button on the top-left side of your course page
  4. Under the Setup tab of your gradebook, go to Gradebook Setup.                     
  5. Scroll to the bottom of the page and click the Add grade item button.
  6. Under Grade item, enter an item name and customize the item settings, including:
    • Item info: A space for entering information about the item.
    • ID number: Setting an ID number allows you to identify the item for custom grade calculations. If you are not using a custom calculation, leave this field blank.
    • Grade Type: Select one of the following grade type options to determine how the grade is displayed:
      • Value – A numerical value with a maximum or minimum
      • Scale – An item in a list
      • Text – Feedback only
    • Scale – This setting determines the scale used for the scale grading type (Pass Fail, Letter grade, etc.) This setting is only available if you selected Scale as the grade type.
    • Maximum grade: The maximum grade determines the maximum achievable grade for the category when using the value grade type. This setting is only available if you selected Value as the grade type.
    • Minimum grade: The minimum grade determines the minimum achievable grade for the category when using the value grade type. This setting is only available if you selected Value as the grade type.
    • Grade to Pass: The minimum grade required to pass. This setting is only available if you selected Value or Scale as the grade type.
    • Grade display type: This setting determines how the grades are displayed in the Grader and User reports (Real, percentage, or letter grades).
    • Overall decimal points: This setting determines the number of decimal points displayed for each grade (the default is 2).
    • Select the Hidden checkbox to hide the grades from students.
    • Hidden until gives you the option to hide the category until a specific date/time.
    • Lock after gives you the option to lock grades from being updates after a specific gate/time.
  7. Under Parent Category, you can:
    • Enter the Item weight (for the category aggregation)
    • Select the category that you want the grade item to appear under in the grader report.
  8. When you are finished adjusting the grade item settings, click Save changes.

Manual grade items will appear in your Grader Report with a square next to the item name (see example below).  

Custom Grade Calculations (Advanced)

A grade calculation is a formula used to determine grades.  As an instructor you can use the Grade calculation function to create a customized grade formula for your course. To create a grade calculation, you will first need to enable “show calculations” for your grader report, then set up a custom grade calculation.

***If your are planning on setting up a grade calculation for your course, please consult with the EdTech team (edtech@carleton.ca)

To enable show calculations:

  1. Log in to cuLearn using your MyCarletonOne credentials.
  2. Click on your course.
  3. In the left navigation menu, click Grades.
  4. Click the Setup tab, then Preferences: Grader Report
  5. In the Show calculations drop-down menu, select Yes.                        

To set up a grade calculation:

  1. In the left navigation menu, click Grades.
  2. Click on the edit drop-down menu next to a category or course total.                    
  3. Select Edit calculation
  4. Under ID Numbers, assign ID numbers for your grade items as you want them to appear in your formula.
    NOTE: Once you’ve entered an ID number it should appear surrounded by double square brackets. For example, if you have a grade item with the ID number Q1, you can refer this item using [[Q1]] in your calculation.   
  5. Enter a formula into the Calculation text box using the calculation functions below. Your formula should begin with an equal sign (=) and may include common mathematical operators, such as max, min, or sum. Enter your assigned grade item ID numbers into the formula using square brackets, with each function separated by a comma (see example below).    
  6. Click Save Changes.

Calculation functions

All grade calculations must start with an equal sign (=) followed by an expression using operators and functions supported by the system. All common arithmetic operators are supported, including the following:

  • addition, using the plus (+) sign
  • subtraction, using the minus (-) sign
  • multiplication, using the asterisk (*) character
  • division, using the slash (/) character
  • exponentiation, using the caret (^) character
NOTE: Functions can also appear in expressions, using a separator between their arguments listed within round brackets (see examples below).

Example Calculations

  • =max([[Quiz.1]], [[Quiz.4]], [[Assignment.1]]) – Returns the maximum value of the grades referred by Quiz.1, Quiz.4 and Assignment.1
  • =average(max([[Quiz.1]], [[Quiz.4]], [[Assignment.1]]), min([[Quiz.1]], [[Quiz.4]], [[Assignment.1]])) – Returns the average of the maximum and the minimum values among Quiz.1, Quiz.4 and Assignment.1 (functions can be nested)
  • =sum([[item1]]*0.3, [[item2]]*0.6, [[item3]]*2) – Returns a weighted grade sum where item1 is weighted 30%, item2 is weighted at 60% and item3 is weighted at 200%
  • =if([[midtermexam]]>=5, [[midtermexam]]+[[lab]], 0) – Returns the sum of midtermexam and lab items if the midtermexam grade is 5 of more, and 0 otherwise. This is a very handy way of dealing with conditional evaluation in a course.
  • =if(AND([[item1]]>=5, [[item2]]>=5), ([[item1]]+[[item2]])/2, 0) – Returns the average of item1 and item2 if both have 5 of more, and 0 otherwise. This is a very handy way of dealing with sine qua non activities.

Gradebook FAQ