You're looking at an older version of Totara Learn.

Please see Totara 13 help for the latest version.

All pages


A grade calculation is a formula used to determine grades, based (optionally) on other grade items. Note that this is not the same as Calculated question types.

Calculations for the gradebook follow the pattern of formulae/functions in popular spreadsheet programs. They start with an equal (=) sign, and use common mathematical operators and functions to produce a single numerical output. This output is then used as the calculated value for the grade item you are editing.

Setting a grade calculation

To set a grade calculation:

  1. Log in as trainer or other user with permission to edit grades.
  2. Click on Grades in the course administration block.
  3. Click the Categories and items tab (or select it from the gradebook dropdown menu).
  4. Click the calculator symbol (in the Actions column) opposite the grade category you wish to set a calculation for.
  5. Start with an equal sign (=).
  6. Choose a function; Example: =sum().
  7. Plug in your ID numbers enclosed in double square brackets, for example =sum([[item1]][[item2]][[item3]]).
  8. Separate each ID number with a comma, for example =sum([[item1]],[[item2]],[[item3]]).
  9. Click Save Changes.

Assigning ID numbers

You can include the values of other grade items by using their ID number as references in your formulas. The ID number is surrounded by double square brackets, for example if you have a grade item with Quiz.3 as ID number, you will refer to this item as [[Quiz.3]] in your calculation.

Below the calculation field is a list of your course with its grade categories and grade items. Next to each item or category's total is displayed the ID number you can use in your calculation (already surrounded with double square brackets). However, since the ID number is optional, some items may not yet have one. These items without an ID number have instead a form field which lets you enter an ID number directly.

As soon as you have assigned the ID numbers you need, you can click the Add ID numbers button, and the page will reload and show you the same list with the ID numbers you have just assigned.

Calculation functions

Every calculation must start with an equal sign (=). Following is a list of the functions supported by the calculation. The comma (,) character is used to separate arguments within function brackets. The comma can also be used to separate different functions. (The separator character could be a semicolon (;) in other languages, see below).

  • 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.
  • sum([[item1]], [[item2]]...): Returns the sum of all arguments.
  • an asterisk (*) gives the product of two items: From example, [[item1]]*[[item2]].

A number of mathematical functions are also supported:

  • sin
  • sinh
  • arcsin
  • asin
  • arcsinh
  • asinh
  • cos
  • cosh
  • arccos
  • acos
  • arccosh
  • acosh
  • tan
  • tanh
  • arctan
  • atan
  • arctanh
  • atanh
  • sqrt
  • abs
  • ln
  • log
  • exp

Calculations when the user language is not English

Calculation formulas use decimal and list separators as defined in each language pack.

The decimal separator (a symbol used to mark the boundary between the integral and the fractional parts of a decimal number) is a point (.) in English. In other languages it may be a comma (,).

The list separator (a symbol used to separate a list of ID numbers in square brackets) is a comma (,) in English. In other languages it may be a semicolon (;).

On this page

Provide feedback about this page using the link in the bottom right of this page. 

Still have questions? Why not post them in the forums of the Totara Community?

  • No labels