Adding a weighted average formula to student results

Owned by Former user (Deleted)
Last updated: Jan 15, 2021 by Richard Kennedy (Unlicensed)

To add a weighted average formula to student results, you use the Formula sub-tab of Subject Assessment Maintenance:

  1. Search for the subject assessment. See Searching for subjects and assessment areas.
  2. Open the Area sub-tab of Subject Assessment Maintenance. See Subject Assessment Maintenance - Area tab - Area sub-tab.
    The Area sub-tab of the Area tab of the Subject Assessment Maintenance window is displayed.


  3. Set the weighting factors for each of the assessment areas on the Area sub-tab. For example:
    • Area 1 (Written Exam) - 50% represented as 0.5
    • Area 2 (Oral Exam) - 20% represented as 0.2
    • Area 3 (Homework) - 30% represented as 0.3.

    Note:     It is important to be consistent across each of the assessment areas used in the weighted calculations.

  4. Create a new assessment area to calculate and store the weighted average. See Creating new subject assessment areas.

    Note:     While not strictly assessment areas, the calculation 'assessment areas' are used to calculate results and summarise them, as required.

    The Area sub-tab of the Area tab of the Subject Assessment Maintenance window is displayed.


  5. Select the Formula sub-tab. See Subject Assessment Maintenance - Area tab - Formula sub-tab.
    The Formula sub-tab of the Area tab of the Subject Assessment Maintenance window is displayed.
  6. Select the @sfWeightedAverage function from the Function field.
  7. Select the areas to use in the formula. In this example, select:
    • Written Exam, also designated as A1
    • Oral Exam, also designated as A2
    • Homework, also designated as A3.
  8. Select a suitable result type, preferably one that is numeric without a mask.
  9. Update the Weighting Factor.
  10. Update the output format of the field to suit your needs.
  11. Click .
  12. Click .
  13. Click .
    The changes to the subject assessment and its areas are saved.
  14. Search for the results for a class of the selected subject. See Searching for student results.
    The All Students tab of Student Results Maintenance window is displayed with the results for the class. 
  15. Click .
  16. Click .
    The result for the class is calculated on the Student Results Maintenance window.