/
Adding a weighted average formula to student results

Adding a weighted average formula to student results

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.

Related content

Adding a ranking formula to student results
Adding a ranking formula to student results
More like this
Editing formulas for the highlighted results column
Editing formulas for the highlighted results column
More like this
New method of calculating and summarising assessment areas
New method of calculating and summarising assessment areas
More like this
Adding a decile or similar formula to student results
Adding a decile or similar formula to student results
More like this
Subject Assessment Area Maintenance - Area bar - Formula tab
Subject Assessment Area Maintenance - Area bar - Formula tab
More like this
Subject Assessment Maintenance - Area tab - Formula sub-tab
Subject Assessment Maintenance - Area tab - Formula sub-tab
More like this