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

From UBC Wiki
Jump to: navigation, search

The Average column is a type of calculated column that displays the average for a selected number of columns. For example, you can display the average for all tests in a course or display the average grade for each student in a Grading Period.

This document will show you how to:

  • Access the Grade Center
  • Create an Average Calculated Column
  • Set Primary and Secondary Displays
  • Set Options

Video

Watch the video below on how to create an average 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 > Average 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:
    • Score
    • Letter
    • Text
    • Percentage
    • Complete/Incomplete
  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 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.
  3. Select (Yes) or (No) to indicate whether the column should Calculate as a running total.
  4. In the Options section, select (Yes) or (No) to include the column in the Grade Center Calculations.
  5. Select (Yes) or (No) to show the column to the students in My Grades.
  6. Select (Yes) or (No) to show statistics for the column to the students in My Grades.
  7. Click Submit.

Related Resources

  • Getting Started with the Grade Center (pdf)