Skip to end of metadata
Go to start of metadata

To create an average column

  1. In the grade center point to Create Calculated Column, and then click Average Column.


  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

      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


  6. Under Select Columns, choose the columns you wish to include in the total. You can choose all columns, or you can select 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 minimum/maximum column

  1. Point to Create Calculated Column, and then click Minimum/Maximum Column.


  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

      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

  6. Under Select Columns, choose the columns you wish to include in the average. You can choose all columns, or you can select individual columns to include in the total.
  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.


  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

      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
  6. Under Select Columns, choose the columns you wish to include in the total . You can choose all columns, or you can select individual columns or whole categories to include in the total.




  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 add a Letter Grade Column, simply select Test in the Primary Display list.

To create a weighted column

  1. Point to Create Calculated Column, and then click Weighted Column.


  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

      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
  6. Under Select Columns, choose the columns you wish to include in the average.

    For Weighted Columns, you must select columns. If you are unsure about this process, see the section below on selecting columns for weighted grades.

  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

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

  1. Under Columns to Select, click the title of the column you want to move to the Select Columns area, and then click the arrow between the two areas.


  2. Continue adding columns or categories until you have completed the column.

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

  1. Under Columns to Select, click the title of the column you want to move to the Select Columns area, and then click the arrow between the two areas.


  2. In the Selected Columns area, type the percentage of weight you want to give to your selected column.

  3. Continue adding columns or categories and giving them appropriate percentage weight.

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
     

 


For questions or comments, contact the Computer Services Help Desk
HelpDesk@MissouriState.edu
417-836-5891