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.