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


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

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.


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