How to Create a Current Year Average GPA During the Middle of the School Year

Environment

Decide which GPAs should be included, this would be from the Extracurriclular Activities page on the GPA History (GRG) tab

Formula Query

Add all of the grading period GPAs. Then, divide the total by the number of GPAs being averaged.

Sample

The percentage fields in parentheses will be adding the GPA fields, then dividing by the number of GPA Fields.

In the example below, 2 GPAs have been selected to get the average for Total GPA for Mark 1 and Mark 4. Adjust the School Year (GRG.YR) as needed.

LIST STU GRG STU.ID STU.NM STU.GR GRG.T1 GRG.T4 (( (( GRG.T1 + GRG.T4 )) / 2 )) IF GRG.YR = 202X

To include additional GPAs for other Mark Grading periods, add the GPA field and increase the number being divided by. See bold below.

LIST STU GRG STU.ID STU.NM STU.GR GRG.T2 GRG.T4 GRG.T6 (( (( GRG.T1 + GRG.T4 + GRG.T6 )) / 3 )) IF GRG.YR = 202X

See GPA Calculation for information on how GPAs are calculated