Academic Criteria rules determine which learners qualify for achievements based on their marks. Rules are built using a drag-and-drop formula builder with four components: Logic Operators, Functions, Variables and Modifiers.

My School > Achievements > Databases > Academic Criteria

• Important: You must build the formula components in the following order to ensure correct calculation: (1) Logic Operator, (2) Function, (3) Variable, (4) Modifier (optional).

• Note: Grade averages exclude LSEN learner marks. LSEN learner averages are calculated separately.

How do I build a criteria rule?

The example below creates a rule that finds the Top 10 Learners based on the average of Terms 1, 2 and 3. The resulting formula is: PositioninGrade(Average(Learner: Term1, Learner: Term2, Learner: Term3)) ≤ 10

Step 1 — Add a Logic Operator

The formula field starts empty with a red box of three dots. Click and drag a Logic Operator (e.g. ≤) from the bottom right onto the red dots. Watch a video example.

Step 2 — Add Functions

Drag the PositioninGrade, Average and Round functions from the top right onto Value 1. Watch a video example.

Step 3 — Add Variables

Drag Term 1 and Term 2 variables from the top left onto Values 1 and 2. To add Term 3, hover over the current values and click the + button to add another parameter field, then drag Term 3 onto the red dots. Set Precision to 2 for rounding. Watch a video example.

Step 4 — Set Value 2

Hover over Value 2 and click the edit button. Type 10 (for Top 10) and click OK. Watch a video example.

To preview results, select the relevant year and click Preview. You can also select a predefined formula from the dropdown list above the formula field.

How do I add Optional Results?

Optional Results display additional information on certificates — for example, the learner’s average and position in grade alongside the Top 10 criteria.

1. Click Add Optional Result, enter a Result Name in Afrikaans and English, and create identifiers (e.g. ‘Mark’ and ‘Position’).

2. Click the Formula tab and build the formula for each identifier using Functions and Variables (e.g. Average of Terms 1, 2 and 3 for the mark; PositionInGrade for position).

3. Set Precision to 2 where applicable. Watch a video example.

Common Academic Criteria formulas

Awards on Final Marks (subjects must be consolidated):

• Above 80% average across terms: Average(Learner: Term1, Learner: Term2, Learner: Term3) ≥ 89.5 or Between(Learner: Promotion, 90, 100)

• Silver 70–80%: Between(Average(Learner: Term1, Learner: Term2, Learner: Term3), 70, 79.5) or Between(Learner: Promotion, 70, 80)

• Top 10 per grade: PositioninGrade(Learner: Promotion) ≤ 10

• Best improvement between terms: PositioninGrade(Difference(Learner: Term4, Learner: Term1)) ≤ 1

Awards per Subject (subjects must NOT be consolidated):

• Subject above 80% on promotion mark: Learner: Promotion ≥ 79.5

• Top 10 per subject: PositioninGrade(Learner: Promotion) ≤ 10

Top learner only if above 80%:

• If(Round(Learner:Promotion,2) ≥ 79.5, PositionInGrade(Round(Learner:Promotion,2)),2) ≤ 1

Frequently asked questions

Why does my formula calculate incorrectly?

The formula components must be added in the correct order: (1) Logic Operator, (2) Function, (3) Variable, (4) Modifier. Deviating from this order will cause the formula to calculate incorrectly. Delete the formula and start over if necessary.