Creating a Weighted Column

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.

A Weighted Total column is created by default and appears in new courses. You can rename, change the settings, change which columns and categories are included, or delete this default column. The default Weighted column displays no results until you select the columns and categories to include in the calculation.

When creating a Weighted Column, you can include:

  • All Grade Columns: Include all individual grade columns in the Grade Center
  • Selected Columns and Calculations: Include specific grade columns and categories (and the associated columns)
  • Selected Columns from a Grading Period: If Grading Periods exist and you have chosen a category, include only the grade columns associated with a specific grading period.

NOTE: Columns with text as the grade display are not included in a Weighted column’s calculation.

To create a Weighted Column based on four columns:

  • Assignments: 25%
  • Chapter Quizzes = 25%
  • Midterm Exam = 20%
  • Final Exam = 30%

1. To Create a Weighted Column, you first need to create all your Grade Columns.

2. Once this is done, using the Action Bar to access the drop down menu for Create Calculated Column choose Weighted Column.

3. This will open a new window, Create Weighted Column.

4. Give the Column a Name, i.e. Weighted Column.

5. You may add a Description but not necessary.

6. Choose your Primary Display (this is how the students will see the marks)

7. Optionally, you can choose a Secondary Display. The default setting is None.

 

8. Using the Select Columns (see picture below), click the name of the Column to Select and using the arrow move it to the Selected Columns box. The names of Grade Columns you created will appear here.

9. When you select and move a Column, it will ask you for a percentage. This is the percentage of the Total Grade.

10. Repeat the above steps until you have selected all the columns you want included in the Weighted Total.

11. Select the following Options as desired:

  • Include this Column in Grade Center Calculations: Select Yes to make the column available for potential inclusion when creating calculated columns. The default is set to Yes.
  • Show this Column to Students: Select Yes to display this column to students on their My Grades page. The default is set to Yes.
  • Show Statistics (average and median) for this column to Students in My Grades: Select Yes to include statistical information with the grade value when shown to students. The default is set to No.

12. Click Submit.