To add a weighted average formula to student results, you use the Formula sub-tab of Subject Assessment Maintenance:
- Search for the subject assessment. See Searching for subjects and assessment areas (on page ).
- Open the Area sub-tab of Subject Assessment Maintenance. See Subject Assessment Maintenance - Area tab - Area sub-tab (on page ).
The Area sub-tab of the Area tab of the Subject Assessment Maintenance window is displayed.
- 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.
- Create a new assessment area to calculate and store the weighted average. See Creating new subject assessment areas (on page ).
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.
- Select the Formula sub-tab. See Subject Assessment Maintenance - Area tab - Formula sub-tab (on page ).
The Formula sub-tab of the Area tab of the Subject Assessment Maintenance window is displayed.
- Select the @sfWeightedAverage function from the Function field.
- 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.
- Select a suitable result type, preferably one that is numeric without a mask.
- Update the Weighting Factor.
- Update the output format of the field to suit your needs.
- Click .
- Click .
- Click .
The changes to the subject assessment and its areas are saved.
- Search for the results for a class of the selected subject. See Searching for student results (on page ).
The All Students tab of Student Results Maintenance window is displayed with the results for the class.
- Click .
- Click .
The result for the class is calculated on the Student Results Maintenance window.