Average Column

1. From the Control Panel select Grade Centre > Full Grade Centre.

2. Click on the Create Calculated Column button.
3. Select Average Column from the drop down list.

Column Information

1. Enter a title for the column in the Column Name textbox.
2. Optionally, enter an abbreviated title for the column in the Grade Centre Name textbox.

Note: The Grade Centre Name is only displayed in the Grade Centre, the Column Name will be displayed in My Grades to the students (refer My Grades tool page).

3. Select the format the marks must be entered in from the Primary Display drop down list.
   • Score: The number entered is displayed.
   • Letter: You can enter a letter grade (A⁺ to E^-) or if you enter a number it is converted to a letter grade.
   • Text: Any text entered is displayed.
   • Percentage: The number entered is displayed with a percentage sign.
   • Complete/Incomplete: If any number is entered a green tick is displayed.
4. Optionally, select another display option for the marks from the Secondary Display drop down list.

Note: The secondary display option (i.e. percentage) is only displayed in the Grade Centre, it cannot be viewed by students in My Grades.

Note: It is possible to create your own Grading Schema that will be listed as an option in the Secondary Display drop down list. (Refer to the Create a Grading Schema guide).

Dates

1. The date the item was created will be automatically displayed.

Select Columns

1. Select the All Grade Columns radio button. OR
2. Select the Selected Columns and Categories radio button.
   • From the Columns to Select highlight items you want to include in the average.
   • Click on the right arrow button.

3. The items will be displayed in the Selected Columns side.
4. Click on the cross icon if you need to remove a column.
5. From Calculate as running total select a radio button:
   • Yes: Only columns that have marks or attempts are included in the average.
   • No: Columns without marks or attempts are included in the calculation with the value of 0.

Exclude Lowest Grades in Calculation

This feature is useful if you want to include only the best X out of X results when calculating an average. For example, if a student has completed 12 weekly quizzes, you can include only their best 10 results in the final average calculation.

1. Select the Category of assessment you would like to create an average total for.
2. Click on the arrow to select your chosen category. 

3. In the Drop Lowest Grades text-field, enter the number of grades to drop from the final calculation. 

4. Select No for the Calculate as Running Total radio button.

Note: You must select No to include any attempts that are incomplete or graded as '0' in the final average calculation.

Options

1. Select the required Include this Column in Grade Centre Calculations radio button:
   • Yes: Makes the column available to for inclusion in calculations.
   • No: The column is not available for inclusion in calculations.
2. Select the required Show this column to students radio button:
   • Yes: Students can view their own mark entered in this column using My Grades.
   • No: Students cannot view their own mark entered in this column using My Grades. i.e. Select this option to hide the column from the students until all marks are finalised. (Refer to guide Hiding marks while marking is in progress).
3. Select the required Show Statistics radio button:
   • Yes: Students can view the average and median mark for this column using My Grades.
   • No: Students cannot view the average and median mark for this column using My Grades.

​​

Submit

1. Click on the Submit button.