A minimum / maximum column can be used to choose the minimum or maximum mark from a list of chosen columns.
Create a Minimum / Maximum column
Select Gradebook from the navigation bar.
Select Marks from the Gradebook navigation bar.
Decide where you want to place the column, click on the Add new gradebook column (+) button.
Select Add Calculation from the drop-down list.
Click on the New Calculation Title and enter a meaningful title. e.g In-Sem exam total mark.
Select Points from the Select a mark schema drop-down box.
Uncheck the Calculate marks based on points earned out of total marked points checkbox. Note: this setting is unchecked so that all required assessments are included in the grade calculation and assumes that if a task does not have a mark recorded it is treated as though the student has received a mark of zero (0) for that task.
Select either Minimum or Maximum from the Functions and variables list.
Click on the created Min / Max button.
Check the required column checkboxes from the Coursework section of the drop-down list.
Click on the Validate button.
If the calculation is correct, you will recieve a Valid expression tick.
Click on the Save button.
Column will be created with either the minimum or maximum mark of the selected columns.