The following Synergetic functions are used when calculating student results. Similar functions are grouped together with variations related to either the:
They are used on the Formula sub-tab of Subject Assessment Maintenance. See Subject Assessment Maintenance - Area tab - Formula sub-tab.
Formula |
Description |
---|---|
@sfAvgClass / @sfAvgSubject |
Average the selected student results using the specified class or assessment area. The results are averaged based on the students either:
Note: These functions only act on a single field (column). For example, @sfAvgSubject(A1) shown immediately above operates on the Written Exam area (A1) for classes GEEA1 and GEEA2 within the German subject assessment GEEA. Tip: You can improve the format of the output by setting the Round to Decimal Places field on the Formula sub-tab. |
@sfCentileClassHighLow / @sfCentileClassLowHigh / @sfCentileSubjectHighLow / @sfCentileSubjectLowHigh |
Students can be ranked by their class or subject and placed in any of the 99 numbered points that divide an ordered set of scores into 100 parts. For the HighLow functions, the:
In the following @sfCentileSubjectHighLow example, the top:
Note: Not all centiles are represented given the small sample. Use the LowHigh functions if you are using an intermediate field such as Ranking as the 'assessment area' in the formula. This will ensure that the top ranked students continued to be displayed first. |
@sfDecileClassHighLow / @sfDecileClassLowHigh / @sfDecileSubjectHighLow / @sfDecileSubjectLowHigh |
Students can be ranked by their class or subject and placed in one of ten (decile) equal parts, so that each part represents a tenth of the sample. See Adding a decile or similar formula to student results. For the HighLow functions, the:
In the following @sfDecileSubjectHighLow example, the students in the top 10% are in the first decile (Decile 1). Use the LowHigh functions if you are using an intermediate field such as Ranking as the 'assessment area' in the formula. This will ensure that the top ranked students continued to be displayed first. |
@sfMarkToGrade |
Convert a mark into an alpha grade. That is, A, B, C or D. You specify the assessment area, then the grade and the minimum mark required to receive that grade, using the following format: @sfMarkToGrade(A1;,A{90},B{80},C{70},D{60},F{0}) This formula will allocate marks:
You need to use a semicolon to separate the area being marked (here A1) from the grades as in the example. Note: The allocation of alpha grades to marks is also defined in the lookup table luReportResultType. See luReportResultType lookup table in the System maintenance manual. |
@sfMax / @sfMin |
Calculate the minimum and maximum values within multiple assessment areas. |
@sfMaxClass / @sfMaxSubject |
Determine the maximum for the selected student results using the specified assessment area. The maximum is identified based on the students either:
Note: These functions only act on a single field (column). For example, @sfMaxSubject(A1) shown immediately above operates on the Written Exam area (A1) for classes GEEA1 and GEEA2 within the German subject assessment GEEA. |
@sfMedianClass / @sfMedianSubject |
Determine the median for the selected student results using the specified assessment area. The median is identified based on the students either:
Note: These functions only act on a single field (column). For example, @sfMedianSubject(A1) shown immediately above operates on the Written Exam area (A1) for classes GEEA1 and GEEA2 within the German subject assessment GEEA. |
@sfMinClass / @sfMinSubject |
Determine the minimum for the selected student results using the specified assessment area. The minimum is identified based on the students either:
Note: These functions only act on a single field (column). For example, @sfMinimumSubject(A1) shown immediately above operates on the Written Exam area (A1) for classes GEEA1 and GEEA2 within the German subject assessment GEEA. Tip: You can double click on a column to sort the results. Double click again to change the sort order. In the examples above, the Written Exam field (column) has been sorted so that the minimum value is at the top (circled). |
@sfQuartileClassHighLow / @sfQuartileClassLowHigh / @sfQuartileSubjectLowHigh / @sfQuartileSubjectHighLow |
Students can be ranked by their class or subject and placed in any of the four quartiles. For the HighLow functions, the:
In the following @sfQuartileSubjectHighLow example:
Use the LowHigh functions if you are using an intermediate field such as Ranking as the 'assessment area' in the formula. This will ensure that the top ranked students continued to be displayed first. |
@sfRankClassHighLow / @sfRankClassLowHigh / @sfRankSubjectHighLow / @sfRankSubjectLowHigh |
Students can be ranked by their class or subject. See Adding a ranking formula to student results. The HighLow functions give the highest result the lowest rank:
Note: Any students with the same result are ranked the same. This is taken into account for subsequent students. Use the LowHigh functions if you are using an intermediate field such as Ranking as the 'assessment area' in the formula. This will ensure that the top ranked students continued to be displayed first. |
@sfStdDevClass / @sfStdDevPClass / @sfStdDevSubject / @sfStdDevPSubject |
Calculate the standard deviation for the selected student results using the specified assessment area. The standard deviation calculated can either be for a:
Tip: Use the sample standard deviation functions in most cases. The standard deviation is identified based on the students either:
Note: These functions only act on a single field (column). |
@sfWeightedAverage |
Calculate the average for the selected assessment areas, taking into account the weighting factors applied to each. See Adding a weighted average formula to student results. For example, the German A subject assessment includes three areas that are assessed:
It is important to be consistent across each of the assessment areas used in the weighted calculations. For example, you might represent them as follows:
The result for the GEEA1 class is calculated on the Student Results Maintenance window. |
Last modified: 22/12/2016 10:18:33 AM
See Also New method of calculating and summarising assessment areas Adding a weighted average formula to student results |
© 2017 Synergetic Management Systems. Published 20 July 2017.