ADAM

Aggregate Calculations

When editing a reporting period’s settings, it is possible to choose from one of four pre-defined aggregate calculations designed for the South African context. However, some schools prefer to create their own calculations which take their specific circumstances into account.

Custom calculations are entered using a text box which requires knowledge of the following syntax to express the calculation.

There are five elements that you can use in the formulae:

Each of the “<parts>” indicated above is now explained:

An example of an aggregate calculation might look like this:

W(1,
        M(
1, 1),
        M(
2, 1),
        P(
3, 50, 4, 1),
        W(
0.5,
                M(
5, 0.25),
                M(
6, 0.75)
        )
        T(
3, 3,
                M(
7, 1),
                M(
8, 1),
                M(
9, 1),
                M(
10, 1)
        )
)

This can be interpreted as follows:

“Calculate the weighted average of the following marks (note that this has a weighting of 1, but that is ultimately irrelevant because this result of this bracket is not weighted against anything else):

Note that the use of “Life Orientation” and “Physical Education” above are just to provide a context where such a calculation might be used and does not imply a recommended approach!

All spacing and commas in the calculation are entirely optional. New lines are not required and do not convey any meaning. The brackets that are used for grouping are very important. The colour used here is merely for illustrative purposes to indicate what each part represents. The colour does not appear in ADAM.

The expression below is identical in function to the one above, but, I think you’ll agree, a bit more difficult to understand!

W(1 M(1 1) M(2 1) P(3 50 4 1) W(0.5 M(5 0.25) M(6 0.75)) T(3 3 M(7 1) M(8 1) M(9 1) M(10 1)))