Documentation:Connect/Create Weighted Calculated Column in the Grade Center (How To)

From UBC Wiki
Jump to: navigation, search

The Weighted column is a type of calculated column that generates a grade based on the result of selected columns and categories, and their respective percentages. When creating a Weighted column, you can include other calculated columns or other Weighted columns. You can change your selections at any time and the calculation updates automatically.

This document will show you how to:

  • Access the Grade Center
  • Create a Weighted Calculated Column
  • Set Primary and Secondary Displays
  • Set Options


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 > Weighted 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 to Percentage.
  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, select what columns to include in the Total 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.
  3. For each category or column you add, enter a percentage. The percentages of all columns added together must equal 100 percent. After assigning the last percentage, click anywhere in the box to update the percentage below the Selected Columns box in the Total Weight area.
    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)