Gradebook guide

The Gradebook is very powerful and allows you to manage complex grading and calculations. Some of the common grading and calculation scenarios are outlined below.

1. Select Grades from the contextual navigation menu.
2. Open the drop-down menu on the left of the page. Select Gradebook setup.
3. Go to the category heading to which you want to assign a weighting. Select the three dots menu next to the right of category heading and select Edit category.
4. If you are updating the Module total, then select the top category (by default, it is named after the module).
5. Under the Aggregation setting, select Weighted mean of grades from the drop-down menu.
6. When finished, select the Save button.
7. To assign weighting to each grade item, enter the percentage weight under the Weights column in relation to the grade item. Then select Save changes. Note: Default is 1.0 (=100%)

1. Select Grades in the contextual navigation menu above the module name.
2. Open the dropdown menu on the left of the page. Select Gradebook setup.
3. Select the Add button on the right of the page and then choose Add category. Name it as the name of the assessment.
4. Move all the grade items which represent the multiple submission links to this category.
5. Apply aggregation method Highest grade to the category.

The Gradebook provides a list of standard methods of aggregation. If none of them apply to your course, you can manually enter a formula for a category or the Module total.

1. Select Grades in the contextual navigation menu above the module name.
2. Open the dropdown menu on the left of the page. Select Gradebook setup.
3. Select the three dot menu on the left of the category or Module total and choose Edit calculation. 

   

4. Assign an ID to the grade item(s) which will be included in your calculation. Select Add ID numbers.
5. In the Calculation text box, type in the formula. The formula should start with an equal (=) sign and may use common mathematical operators, such as max, min and sum. If desired, other grade items may be included in the calculation by typing the ID numbers in double square brackets. Select Save changes.
6. Separate each ID number with a comma, for example:
   •   =average([[item1]], [[item2]]...): Returns the average of a sample
   •    =max([[item1]], [[item2]]...): Returns the maximum value in a list of arguments
   •    =min([[item1]], [[item2]]...): Returns the minimum value in a list of arguments
   •    =mod(dividend, divisor): Calculates the remainder of a division
   •    =pi(): Returns the value of the number Pi
   •    =power(base, power): Raises a number to the power of another
   •    =round(number, count): Rounds a number to a predefined accuracy
   •    =floor(number): Maps a real number to the largest previous integer
   •    =ceil(number): Maps a real number to the smallest following integer
   •    =sum([[item1]], [[item2]]...): Returns the sum of all arguments
   •    =an asterisk (*) gives the product of two items: [[item1]]*[[item2]]
7. IF Conditions - You are able to add AND or OR criteria into IF conditions in the Grade Calculation.

Screencast

The screencast below provides a step-by-step overview of how to set up a formula for a category or Module total.

1. Select Grades from the contextual navigation menu.
2. Open the dropdown menu on the left of the page. Choose Gradebook setup.
3. Select the add button on the right of the page and choose the Add category button. Name it as the name of the assessment. For example, 'Assignment 1 resubmission'.
4. Move the resubmission grade item(s) to this category.
5. Select Edit and choose Edit calculation next to the category total.
6. Assign an ID to the resubmission grade item. For example, 'resit'. Then select Add ID numbers at the bottom of the page.

   

7. Enter this formula in the Calculation box (put the ID in double square brackets). =min([[resit]], 50)

   

8. Select Save changes button.

The table below illustrates different scenarios of student marks and the respective calculated course total for an assignment with a resubmission point and a capped grade:

1. To cap resit assessment at 50, please follow the guidance in the section above - Resit assessment. Marks capped at 50 (Edit calculation).
2. Select Grades in the contextual navigation menu above the module name.
3. Open the drop-down menu on the left of the page. Select Gradebook setup.
4. Select the three dot menu and choose Edit calculation next to the category or course total. 
5. Assign an ID to the original assignment submission, for example, 'assignment'.
6. Assign an ID to the category total for the capped resit assessment, for example, 'capped_resit'.
7. Then select Add ID numbers at the bottom of the page.
8. Enter this formula in the Calculation box (put the ID in double square brackets). =max([[capped_resit]], ([[assignment]]-[[capped_resit]]))
9. Select Save changes button.

Screencast

The screencast below provides a step-by-step overview on how to set up a new category and how to add a calculation for capped grade items.

The Drop the lowest setting enables a specified number of the lowest grades to be excluded from the aggregation. 

1. Select Grades in the contextual navigation menu above the module name.
2. Open the drop-down menu on the left of the page. Select Gradebook setup.
3. Select the three dots menu next to the category and choose Edit calculation.
4. Select Show more…
5. Next to Drop the lowest option, enter the number of grade items to drop.

A scale is an ordered list of marks or text values, ranging from negative to positive (e.g. Sub-standard, Less than satisfactory, Satisfactory, Good, Very good, Excellent!, or Fail, Pass), that is used to grade assessment submissions.

1. Select Grades in the contextual navigation menu above the module name.
2. Open the drop-down menu on the left of the page. Select Gradebook setup.
3. Select the three dot menu next to the category and choose Edit category.
4. Select Scale as Grade type.
5. Select the Scale to apply from the Scale drop-down.
6. Select the Save button.

Add a new scale

1. Select Grades in the contextual navigation menu above the module name.
2. Open the drop-down menu on the left of the page. Choose Scales.
3. Select Add a new scale button. Complete the settings
4. Select the Save changes button.