Average Column

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 or display the average grade for each student/participant for a Grading Period.

Simple Average Formula

To find the average of all selected columns, the percentage is calculated to four decimal places. The percentage values for all selected columns are added together. The result is divided by the number of columns included in the calculation. The results display according to the Primary and Secondary Display options.

(Column 1%) + (Column 2%) + (Column 3%) + (Column 4%) = % earned divided by 4 columns = Average percentage score

Three values: 8/10, 3/5, 2/2

Percentage equivalents: 80.0000%, 60.0000%, 100.0000%

Total of the values: 240.0000

Number of items: 3

Total value divided by number of columns: 240.0000/3 = 80.00%

Note: You can assign a grade to a maximum of four decimal places, but the Grade Center displays only to a maximum of two decimal places. Grades to three or four decimal places are rounded up. For example, 45.4357 is rounded up to 45.44. Calculated columns also display to a maximum of two decimal places. Columns with text as the primary display cannot be averaged.

When you create an average column, you can include:

  • 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).

1. Go to the Control Panel >> Grade Center >> Full Grade Center >> Create Calculated Column >> Average Column.


2. Type a Column Name This name becomes the column name in the Grade Center and on students’/participants' My Grades pages. 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.

Note: 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 see its full name on the Grade Information Bar.

3. Optionally, type a Description.

4. Enter the a Primary Display. This option cannot be Text. Optionally, make a selection in the Secondary Display drop-down list.

5. If grading periods exist, you can associate an average 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.

6. In the Select Columns section, select what to include in the average column's calculation. The following table lists the options.

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. If no grading periods exist, the drop-down list does not appear.
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.

Note: A column that is set to No to Include this Column in Grade Center Calculations does not appear in the selection list.

Tip: 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.
  • Weight Columns allows you to select how to weigh columns within the category. Drop Grades removes a number of either the highest or lowest grades for each category from the calculation. If you do not type numbers in the boxes, no grades are dropped.
    • Click Equally to apply equal values to all columns within a category.
    • Click Proportionally to apply the appropriate value to a column based on its points compared to other columns in the category.
  • Use only the Lowest -OR- Highest Value to Calculate removes all grades from the calculation except for the best or worst score.

Note: To delete a selection in the Selected Columns box, click the red X.

7. 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.

8. 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/participants on their My Grades pages.
9. Click Submit.

This article was updated: 12/14/2017