How to Create Calculated Columns

Calculated columns combine data from multiple columns to calculate grades. Follow the directions below to create a calculated column. 

Step-by-Step Guide

How to Create Calculated Columns
 

To Create an Average Column

  1. In the grade center point to Create Calculated Column, and then click Average Column.
    Select a calculated column from the drop-down menu.
     
  2. In the Column Name box, type a name for your column.Type a Grade Center Display Name if desired.
  3. In the Description text area, type a description for your column.
    column information
     
  4. In the Primary Display list, select the way you wish to display items in the column:
    • Score
    • Letter
    • Text
    • Percentage
    • Complete/Incomplete
      Choose the display setting for the grades from the drop-down menu.
      Please Note:  This format will appear in the Grade Center and in the student's My Grades area.
  5. In the Secondary Display list, select the way you wish to display the items in the column for your purposes only:
    • Score
    • Letter
    • Text
    • Percentage
    • Complete/Incomplete
      Choose the display setting for the grades from the drop-down menu.
      Please Note:  Students cannot see the Secondary Display. Only those who have access to the full Grade Center can see this selection.
  6. Under Select Columns, choose the columns you wish to include in the total. You can choose all columns or you can select specific columns.
    select columns options
     
  7. Select Yes or No to Calculate a Running Total.
    calculate as running total option
     
  8. Under Options, select to include the column in the grade center, show the column to students, and to show statistics for this column to students if desired.
    Choose how students will see the calculated column
     
  9. When you are finished, click Submit.
     

To create a minimum/maximum column

  1. Point to Create Calculated Column, and then click Minimum/Maximum Column.
    Select a calculated column from the drop-down menu.
     
  2. In the Column Name box, type a name for your column.Type a Grade Center Display Name if desired.
  3. In the Description text area, type a description for your column.
  4. In the Primary Display list, select the way you wish to display items in the column:
    • Score
    • Letter
    • Text
    • Percentage
    • Complete/Incomplete
      Please Note:  This format will appear in the Grade Center and in the student's My Grades area.
  5. In the Secondary Display list, select the way you wish to display the items in the column for your purposes only:
    • Score
    • Letter
    • Text
    • Percentage
    • Complete/Incomplete
      Please Note:  Students cannot see the Secondary Display. Only those who have access to the full Grade Center can see this selection.
  6. Under Select Columns, choose the columns you wish to include in the average. You can choose all columns, or you can select specific columns.
  7. Select Yes or No to Calculate a Running Total.
  8. Under Options, select to include the column in the grade center, show the column to students, and to show statistics for this column to students if desired.
  9. When you are finished, click Submit.
     

To create a total column

  1. Point to Create Calculated Column, and then click Total Column.
    Select a calculated column from the drop-down menu.
     
  2. In the Column Name box, type a name for your column.Type a Grade Center Display Name if desired.
  3. In the Description text area, type a description for your column.
    column information
     
  4. In the Primary Display list, select the way you wish to display items in the column:
    • Score
    • Letter
    • Text
    • Percentage
    • Complete/Incomplete
      Please Note:  This format will appear in the Grade Center and in the student's My Grades area.
  5. In the Secondary Display list, select the way you wish to display the items in the column for your purposes only:
    • Score
    • Letter
    • Text
    • Percentage
    • Complete/Incomplete
      Please Note:  Students cannot see the Secondary Display. Only those who have access to the full Grade Center can see this selection.
  6. Under Select Columns, choose the columns you wish to include in the total. You can choose all columns, or you can select specific columns.
  7. Select Yes or No to Calculate a Running Total.
  8. Under Options, select to include the column in the grade center, show the column to students, and to show statistics for this column to students if desired.
    options area
     
  9. When you are finished, click Submit.
     

To create a weighted column

  1. Point to Create Calculated Column, and then click Weighted Column.
    Select a calculated column from the drop-down menu.
     
  2. In the Column Name box, type a name for your column.Type a Grade Center Display Name if desired.
  3. In the Description text area, type a description for your column.
    column information
     
  4. In the Primary Display list, select the way you wish to display items in the column:
    • Score
    • Letter
    • Text
    • Percentage
    • Complete/Incomplete
      Please Note:  This format will appear in the Grade Center and in the student's My Grades area.
  5. In the Secondary Display list, select the way you wish to display the items in the column for your purposes only:
    • Score
    • Letter
    • Text
    • Percentage
    • Complete/Incomplete 
      Please Note:  Students cannot see the Secondary Display. Only those who have access to the full Grade Center can see this selection.
  6. Under Select Columns, choose the columns you wish to include in the average.
    Please Note:  For Weighted Columns, you must select specific columns or categories.
  7. Select Yes or No to Calculate a Running Total.
  8. Under Options, select to include the column in the grade center, show the column to students, and to show statistics for this column to students if desired.
  9. When you are finished, click Submit.
     
To select columns and categories for weighted grades

In the Include in Weighted Grade area, you will select columns and categories to add to the new weighted column. Once you have select a column or category, you will need to type the percent that column or category contributes to the total of 100%.

Please Note:  If Categories are set up correctly and assigned appropriately, they are the easiest way to manage and maintain weighted grades.
  1. Under Columns to Select, click the title of the column you want to move to the Selected Columns area, and then click the arrow between the two areas.
    Select the columns and move them to selected columns using the arrow buttons.
     
  2. In the Selected Columns area, type the percentage of weight you want to give to your selected column.
    Select the percentage weight for each column.
     
  3. Continue adding columns or Categories and giving them the appropriate percentage weight.
    category information
     

Dropping a Low or High Score in a Calculated Column

After selecting which Categories are included in the Total being calculated, you can choose to drop a set number of grades or grade using the Lowest or Highest value from a Category.

  1. In the Category that's been added to the Total, set the appropriate number of grades you'd like dropped from the Category.
    Under each category you have the option to drop the highest or lowest gradde.
     

 

 

To request help related to this article, please see our Service Catalog.

Details

Article ID: 93282
Created
Mon 11/25/19 10:56 AM
Modified
Thu 9/16/21 8:11 AM