Customize Column Weighting

If you want direct control over how each individual assignment is weighted, you can customize column weights. Once you've enabled column weighting, you can set column weights when you add or edit columns. You also have the option to convert scores to percentages before calculating averages.

Enable Column Weighting

Column weights allow you to set the relative weight of each assignment in your gradebook. This gives you more control over the importance of each assignment in overall grade calculation.

To enable column weighting, do the following:

  1. On the side-navigation menu, click Grading, and then click the Weighting tab.
  2. Under Column Weighting, select the Weight columns (Not recommended) check box.

    Column Weighting Options

  3. In the Copy Setting to Active Gradebooks dialog box, do either of the following:

    • Click Weight Columns only in this gradebook to weight the columns in your open gradebook.
    • Click Weight Columns in all of my active* gradebooks to weight columns in gradebooks that appear in the Gradebooks tab.
  4. At the top of the Weighting tab, click Save & Recalculate.

    A Column Weight header row appears in your gradebook(s) if you haven't already hidden it. For more information on header rows, see Customize Header Rows.

Set Column Weights

After you enable column weighting, you can set column weights when you add or edit columns. Columns that already exist in your gradebook are assigned a column weight of 1, unless you've previously enabled column weighting and set the weights for those columns. By default, column weights are shown in the header row.

To set column weights, do the following:

  1. Right-click the column header of the assignment score column you want to weight, and then click Edit Column Name & Details.
  2. In the Edit Column dialog box, change the weight in the Column Weight box, and then click OK.

    Set Column Weight

    When you're creating a new column, you can set the Column Weight value in the Add Column dialog box,

Convert Scores to Percentages

If you want to assign any number of possible points to your score columns and still have every column be worth the same before weighting, you can convert scores to a percentage before calculating marking period averages. For example, if you want the possible points for a quiz to be equal to the number of questions, while each quiz still counts equally towards averages, you can enable this setting. This results in a system where a 15/15 (a 15-question quiz) and a 20/20 (a 20-question quiz) both carry equal weight in average calculations unless you assign a column weight.

This setting affects the scores for assignments in all assignment categories (quizzes, tests, homework, etc.). If you decide to convert scores to percentages, you should apply weighting to your scores. If you do not apply any type of weighting, every assignment you create will count equally towards averages. Column weighting allows you to determine what assignments are worth relative to each other; however, we suggest that you use both column and category weighting. If you don't apply category weighting, you'll need to consider assignments in other categories when setting column weights. For example, for tests to be worth two times more than quizzes in a gradebook that only uses column weighting, the lowest value you can ever set for a test must be double the highest value you ever set for a quiz. In that gradebook, you can't leave the default weight of 1 on any test column that you create. To enable column weighting, see Customize Category Weighting.

To convert scores to percentages before calculating marking period averages, do the following:

  1. On the side-navigation menu, click Grading, and then click the Weighting tab.
  2. Under Column Weighting, select the Convert Scores to a percentage before calculating Marking Period Averages (Not recommended) check box.

    Column Weighting Options

  3. In the Copy Setting to Active Gradebooks dialog box, do either of the following:

    • Click Convert scores to a percentage only in this gradebook to weight the columns in your open gradebook.
    • Click Convert scores to a percentage in all of my active* gradebooks to weight the columns in the gradebooks that you have selected to appear in the Gradebooks tab.
  4. At the top of the Weighting tab, click Save & Recalculate.

This topic was last updated on February 08, 2018.


Rediker Software, Inc., 2 Wilbraham Road, Hampden, MA 01036
Copyright © 2017 Rediker Software Inc. All rights reserved.

Copyright © Rediker Software, Inc. All rights reserved.