Best X of Y Total Column (Original)

Video Guide

Create Best X of Y total column (YouTube 2m 9s)

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

2. Click on the  Calculated Column button.
3. Select Total 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.
4. Score: The number entered is displayed.
5. Letter: You can enter a letter grade (A⁺ to E^-) or if you enter a number it is converted to a letter grade.
6. Text: Any text entered is displayed.
7. Percentage: The number entered is displayed with a percentage sign.
8. Complete/Incomplete: If any number is entered a green tick is displayed.
9. 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 Categories to Select highlight items you want to include in the calculation.
   • Click on the right arrow button.

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).

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. Select the Drop Grades radio button.
6. Enter the number of low scores you do not want to include in the calculation in the Drop Lowest textbox.
7. From Calculate as running total select a radio button:
8. Yes: Only columns that have marks or attempts are included in the calculation.
9. No: Columns without marks or attempts are included in the calculation with the value of 0.

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 the guide Hiding mark 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.

​