Documentation:Connect/Create Minimum or Maximum Calculated Column in the Grade Center (How To)

From UBC Wiki
Jump to: navigation, search

The Minimum/Maximum column is a type of calculated column that displays either the minimum or maximum grade for a selection of columns. They can be used by an Instructor to visualize student performance or to determine whether or not they would like to apply grade weighting. The Instructor may also choose to create such a column and make it visible to the students so they can determine their class standing.

This document will show you how to:

  • Access the Grade Center
  • Create a Minimum/Maximum Calculated Column
  • Set Primary and Secondary Displays
  • Set Options


Watch the video below on how to create a minimum/maximum calculated column in the Grade Center:

Access the Grade Center

  1. From the left-hand course menu, select Control Panel.
  2. Click Grade Center.
  3. Click Full Grade Center.
    Full Grade Center is the second option under Grade Center

Create an Average Calculated Column

  1. Click Create Calculated Column > Minimum/Maximum Column.
  2. In Column Information section, add a column name. This name will appear within My Grades and the Grade Center unless a Grade Center Display Name is added.
  3. (Optional) add a Grade Center Display Name. This name will only appear in the Grade Center as the column name.
  4. (Optional) Enter a description of the column. Descriptions will be visible to students in My Grades.

Set Primary and Secondary Displays

  1. Set a Primary Display option:
  2. (Optional) Add a Secondary Display option to appear next to the Primary Display in the Grade Center and is only visible to the Instructor.

Set Options

  1. In the Dates section, select a grading period.
  2. In the Select Columns section, choose the Calculation Type of the column, either (Minimum) or (Maximum).
  3. Select what columns to include in the Minimum/Maximum with one of the following options:
    • All Grade Columns
    • All Grade Columns in Grading Period, then assign a grading period
    • Selected Columns and Categories, then use columns and categories menus select columns for the Selected Columns area. You can select multiple items using CTRL + Click or Shift + Click on the PC or Command + Click or Shift + Click on Mac. Click the right directional arrow to move the selected items to the Selected Columns area and click the red “x” to remove an item from Selected Columns.
      Use right-direction arrows to add columns and categories
    Note: If using categories, select an option to weight the columns within this category Equally or Proportionally.
    Equally will apply the percentage evenly across the columns within the category regardless of varying point values.
    Proportionally will apply the percentage based upon the points compared to the other columns within the category.
    Enter a value for dropping a select number of high or low grades.
  4. Select (Yes) or (No) to indicate whether the column should Calculate as a running total.
  5. In the Options section, select (Yes) or (No) to include the column in the Grade Center Calculations.
  6. Select (Yes) or (No) to show the column to the students in My Grades.
  7. Select (Yes) or (No) to show statistics for the column to the students in My Grades.
  8. Click Submit.

Related Resources

  • Getting Started with the Grade Center (pdf)