The minimum/maximum column is a type of calculated column that displays either the minimum or maximum grade for a selection of columns. For example, you can find the minimum score on all tests, but only show it in the Grade Center grid and not to your students on their My Grades pages.
Minimum: The percentage value for each column included in the calculation is compared up to four decimal places and the lowest value is displayed. The result displays up to two decimal places.
Maximum: The percentage value for each column included in the calculation is compared up to four decimal places and the highest value is displayed. The result displays up to two decimal places.
Three values: 8/10, 3/5, 2/2
Percentage equivalents: 80.0000%, 60.0000%, 100.0000%
If two values are exactly the same for a minimum/maximum column, that is the value that appears in the Grade Center grid.
Minimum/Maximum Column Combinations
The minimum/maximum column is a type of calculated column that displays either the minimum or maximum grade for a selection of columns. You can select which columns and categories are used for displaying a minimum or maximum value. For example, you can display the minimum score for a grading period to help you determine what content your students may be struggling with. You can change your selections at any time and the calculation updates automatically.
When you create a minimum/maximum column, you can include the following items:
- All Grade Columns: Include all individual grade columns in the Grade Center.
- All Grade Columns in Grading Period: If grading periods exist, include only the grade columns associated with a grading period.
- Selected Columns and Categories: Include specific grade columns and categories (and the associated columns).
Columns with text as the grade display are not included in a minimum/maximum column’s calculation. For example, if you set a grade column to display text, such as Satisfactory/Unsatisfactory, you cannot use it in calculations.
- In the Grade Center, point to Create Calculated Column on the action bar and click Minimum/Maximum Column.
- On the Create Minimum/Maximum Column page, type a brief, descriptive Column Name. This name becomes the column name in the Grade Center and on students’ My Grades pages unless you provide a different name in the Grade Center Display Name box. If this name is too long to display clearly in the Grade Center, you can type a short, descriptive name in the Grade Center Name box.
Only the first 14-15 characters typed in either name box appear in the column heading in the Grade Center grid. Point to the column heading to view its full name on the Grade Information Bar.
- Optionally, type a Description.
- Make a selection in the Primary Display drop-down list. To learn more, see the steps in How to Create Grade Columns.
- Optionally, make a selection in the Secondary Display drop-down list.
- If grading periods exist, you can associate the minimum/maximum column with a grading period by making a selection in the Grading Period drop-down list. If no grading periods exist, the drop-down list does not appear. You can use grading periods to filter Grade Center data and create calculated columns.
- In the Select Columns section, select Calculation Type: Minimum or Maximum.
- Select what to include in the minimum/maximum column's calculation. The following table lists the options.
Minimum/Maximum Column Options Option Description All Grade Columns Include all individual grade columns in the Grade Center. All Grade Columns in Grading Period Select a grading period from the drop-down list to include only those columns associated with the grading period in the calculation. Selected Columns and Categories Select grade columns and categories individually.
Select the columns in the Columns to Select box and click the right-pointing arrow to move the selections to the Selected Columns box. When you select a column, you can view information about the column in the Column Information area below the Columns to Select box.
A column that is set to No for Include this Column in Grade Center Calculations does not appear in the selection list.
For Windows, to select multiple items in a list, press the Shift key and click the first and last items. To select items out of sequence, press the Ctrl key and click each item needed. For Macs, press the Command key instead of the Ctrl key.
Select the categories in the Categories to Select box and click the right-pointing arrow to move the selections to the Selected Columns box. When you select a category, you can view which columns are included in the category in the Category Information area below the Categories to Select box. Other options appear after you move the category to the Selected Columns box:
- If grading periods exist, make a selection in the Grading Period drop-down list. If you selected a category for the calculation, you can limit the columns used by selecting a particular grading period.
To delete a selection in the Selected Columns box, click the red X.
- Calculate as Running Total: Click Yes to calculate as a running total. Running totals exempt cells that do not contain data. Click No to include all selected columns in the calculation, using a value of 0 if no grade exists. This can make grades appear artificially low.
- Select the Options:
- Include this Column in Grade Center Calculations: Click Yes to make the column available for potential inclusion when creating calculated columns.
- Show this Column to Students: Click Yes to display the column to students in My Grades.
- Show Statistics (average and median) for this Column to Students in My Grades: Click Yes to include statistical information with the grade value when shown to students.
- Click Submit.
The new minimum/maximum column appears in the Grade Center grid.
You can change the column's settings at any time and change which columns are included. Once edited, the calculation updates automatically.
You are not allowed to type directly in a minimum/maximum column's cell to edit the calculated grade. Therefore, no contextual menu appears when you move your mouse pointer over an individual cell in a minimum/maximum column.
To keep a minimum/maximum column in view, despite the addition of other columns, move the column and freeze it on the Column Organization page. To learn more, see Organize Grade Center Data.