GPA DATs

Summary

The GPA DAT is used to print a student Grade Point Average in a report, export, or the cumulative info screen.

Overriding The DAT Parameters

With the exception of the method parameter (Which is the only mandatory parameter) an parameter can be overridden at the GPA Calculation Method record at the District Office.

For more information on GPA Calculation Methods see KB 7182


Format

^(*gpa method="[gpa method]" type="[gpa type]" term="[term1],[term2],[etc]" grade="[grade]" credittype="[credit type]"year="[year1],[year2],[etc]" scale="[grade scale]")

The GPA DAT parameters are separated by spaces, not semicolons.

The values are separated from the parameter by an equal sign and enclosed in quotes.

It is not necessary to use every parameter, as omission of a parameter will trigger a default value.


Parameters

Method

Example Use: ^(*gpa method="simple")

Specifies the GPA Calculation Method to use.

Methods are defined at: Start Page > District > GPA > GPA Calculation Methods

If omitted, the "weighted" calculation method is used. 

Type

Example Use: ^(*gpa type="current")

Specifies what grades to use, there are three options.

cumulative: Historical / Stored Grades

current: Final grades from the Gradebook

projected: a combination of current and historical

If omitted, the Type from the GPA Calculation Method is used.

Term

Example Use: ^(*gpa term="S1")

Example Use: ^(*gpa term="Q2,Q3,Q4")

Specifies the Reporting Term / Store Code to get the grade values from.

Only exact matches are accepted

If omitted, all Term values are included.

If both Term and Year are omitted, only current year grades are used.

Grade

Example Use: ^(*gpa grade="10")

Example Use: ^(*gpa grade="9,10,11,12")

Specifies the Student Grade Level to get grade values from.  For example, if you list "10" as the grade, it will search only grades that were stored during a student's 10th grade (contains a grade_value of 10 in the historical grade record).

If omitted, it will search the historical grade range that is set for the school.

[StoredGrades]Grade_Level

Credit Type

Example Use: ^(*gpa credittype="SCI")

Example Use: ^(*gpa credittype="SCI,MAT,ENG")

Specifies the Credit Types to get grade values from. For example, if you list "SCI" as the type, only grades from a course with SCI as a credit type will be included.

Credit type values must be an exact match

If omitted, all credit types are included

[StoredGrades]Credit_Type

Year

Example Use: ^(*gpa year="2004")

Example Use: ^(*gpa year="2003,2004")

Specifies the Year to get the grade values from.  For example, 2004 returns all grades from the 2014-2015 school year.

If omitted, all years are included [StoredGrades]TermID

If both Term and Year are omitted, only current year grades are used.

Scale

Example Use: ^(*gpa scale="Default")

Specifies the Grade Scale to use in determining the value of a Letter Grade.

For example, if Default is used, only grades that are part of the Default Grade Scale are included AND the Point value will come from the grade scale rather than the grade record itself.

If omitted, the values from the actual grade record will be used.

Example: A student earns 5 GPA points for an A grade on an honors based added value gradescale. The GPA tag is set to use a gradescale without added value. On the report the A grade is reinterpreted to be worth the simple value of 4 GPA points.