Editing formulas for the highlighted results column

You can edit any defined formulas from the All Students or Assessment tabs of Student Results Maintenance

See:

Also see:


Note: You may not have security access to this function.

To edit a formula from the All Students tab:

  1. Select the column that you want to edit the formula for.



    Tip:
    You can click anywhere in the column heading.

  2. Right click.
    The following menu is displayed.
  3. Select Edit Formula for Highlighted Column.
    The Subject Assessment Area Formula window is displayed.
  4. Update the formula.
  5. Click .
    The result calculations are applied to students in the class or subject, depending on the function used.

    Note: You do not need to click on the Student Results Maintenance toolbar.

  6. Double click on the heading to sort the values, if required. See Sorting and ranking students.

Subject Assessment Area Formula window key fields and buttons
Fields

Field

Description

Calculation Formula

Formula used for calculating student results, operating on assessment areas within the current subject assessment. For example, the German A subject assessment used in the examples includes three areas that are assessed:

  • Written Exam, also designated as A1
  • Oral Exam, also designated as A2
  • Homework, also designated as A3.

In addition, 'assessment areas' have been added to hold the result of calculations to be:

  • output on reports, such as Weighted Average, also designated as A4
  • used elsewhere, such as Ranking, also designated as A5
  • used elsewhere, such as Average, also designated as A6.

The formula used can be a simple calculation. For example, the formula for a calculated 'assessment area' such as Average can be (A1+A2+A3)/3.

Alternatively, the formula can use a Synergetic function. For example, @sfWeightedAverage(A1,A2,A3) is the correct function to use as it takes into account the weighting factors applied (see Weighting Factor below).

The result for the GEEA1 class is calculated on the Student Results Maintenance window.

Result Type

Formatting of the calculated result.

It is recommended that you use a numeric result type for a calculated assessment area record. See Creating a numeric result type for calculated assessment areas.

Weighting Factor

Weighting factor of the current assessment area which is used in calculations by other assessment areas for the subject.

It is important to be consistent across each of the assessment areas used in the weighted calculations. For example, if you have three assessment areas that you want to weight to a result using the formula @sfWeightedAverage(A1, A2, A3), you might represent them as follows:

  • Area 1 - 50% represented as 0.5
  • Area 2 - 20% represented as 0.2
  • Area 3 - 30% represented as 0.3
  • Weighted Average - 100%, represented as 1.

The default value is 1, which results in no weighting if all of the other areas have the same value.

Mark Out Of

Calculated result can be converted to a Mark Out Of value.

For example, if you want to have the calculated result converted to a mark out of 50, specify a value of 50.

The default is a mark out of 100. This is represented as either a 100 or a zero.

Round to Decimal Places

Type the number of decimal places to round the result to. Synergetic rounds up or down to the nearest value, based on the number of decimal places specified.

This field can be used in conjunction with the Decimal Places are Fixed field. In the following examples, the Decimal Places are Fixed field is cleared. Any integer results, such as 92, are displayed without any decimal places.

For example, if the Round to Decimal Places field is:

  • set to 0, a result of 92.5 is formatted as 92 on the student report
  • set to 1, a result of 92 is formatted as 92 on the student report
  • set to 1, a result of 95.312 is formatted as 95.3 on the student report
  • set to 1, a result of 95.296 is formatted as 95.3 on the student report
  • set to 2, a result of 95.344 is formatted as 95.34 on the student report.
    By default the field is blank; this results in no rounding.

Decimal Places are Fixed

When a value is specified in the Round to Decimal Places field, you can fix the format of the values that are displayed on the student reports.

Based on the examples used above, if the Decimal Places are Fixed field is selected:

  • a result of 92 is formatted as 92.0 on the student report, if Round to Decimal Places is 1
  • a result of 95.312 is formatted as 95.3 on the student report, if Round to Decimal Places is 1 (the same as earlier)
  • a result of 95.296 is formatted as 95.3 on the student report, if Round to Decimal Places is 1 (the same as earlier)
  • a result of 95.344 is formatted as 95.34 on the student report, if Round to Decimal Places is 2 (the same as earlier).

Any integer results, such as 92, are displayed with decimal places.

Truncate instead of Round

You can truncate the values that are displayed on the student reports. When:

  • No value is specified in the Round to Decimal Places field the display value is truncated to an integer. For example, a 95.999 is truncated to 95.
  • A value is specified in the Round to Decimal Places field, the display value is truncated to the highest value for the number of decimals specified. For example, a 95.999 is truncated to 95.99 if the Round to Decimal Places is set to 2.

Areas

Areas of assessment that can be used in the Calculation Formula.

Double click the required assessment area to place it in the Calculation Formula field.

Each area is designated by the letter A and suffixed by its sequence number. In the following example, the Ranking assessment area is designated A5 and included in the @sfDecileSubjectHighLow formula.

The current assessment area, used to define the calculated result, is not displayed in the Areas field. This is to avoid recursive calculations, where the result forms part of its own input.

Functions

A range of mathematical functions are supplied with Synergetic. See Functions used when calculating student results.

Double click the required function to place the function in the Calculation Formula field. Then enter the required parameters.


Buttons

Button

Description

Place a plus (+) character in the Calculation Formula field where the cursor is positioned.
Tip: You can type the formula directly in the Calculation Formula field for most of the buttons shown.

Place a minus (-) character in the Calculation Formula field where the cursor is positioned.

Place a multiplication ({}) character in the *Calculation Formula field where the cursor is positioned.

Place a division (/) character in the Calculation Formula field where the cursor is positioned.

Place an open bracket ( character in the Calculation Formula field where the cursor is positioned.

Place a closed bracket ) character in the Calculation Formula field where the cursor is positioned.

Check that the formula in the Calculation Formula field is correctly formatted.

For example, the following message is displayed if the open bracket and close bracket characters are unbalanced. Correct any formatting errors.