Skip to end of banner
Go to start of banner

Adding a weighted average formula to student results

Skip to end of metadata
  • Created by Former user, last modified by Former user on Feb 26, 2017
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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.
  • No labels