Grades and Assessment DATs
On this page:
This section includes DATs used to return grading and assessment information.
Stored Grades
Stored grades data is extracted from the [StoredGrades] table using the stored.by.course.number DAT with the course name, store code and field name, or with the stored.by.course.period.cached DAT, using the expression, store code and field name. The stored.by.course.numberlist allows users to return data for multiple courses using one DAT.
Format: ^(stored.by.course.number;coursenumber;storecode;field) – Based on course name.
Example: ^(stored.by.course.number;ENG2100;S1;grade)
Format: ^(stored.by.course.numberlist;coursenumber,coursenumber;storecode;field) – Multiple courses in one DAT.
Example: ^(stored.by.course.numberlist;ENG2100,FRL3200,HIS3199;S1;grade)
Format: ^(stored.by.course.period.cached;expression;storecode;field) – Based on expression.
Example: ^(stored.by.course.period.cached;1(A) 2-3(C) 4(4);S1;grade)
Name | Code | Description |
|---|---|---|
Grade | ^(stored.by.course.number;course number;store code;grade) | Grade for the course/term. [StoredGrades]Grade |
Earned Credit | ^(stored.by.course.number;course number;store code;earnedcrhrs) | Earned credit for the course/term. [StoredGrades]EarnedCrHrs |
Potential Credit | ^(stored.by.course.number;course number;store code;potentialcrhrs) | Potential credit for the course/term. [StoredGrades]PotentialCrHrs |
Credit Type | ^(stored.by.course.number;course number;store code;credit_type) | Credit type for the course/term. [StoredGrades]Credit_Type |
Behavior | ^(stored.by.course.number;course number;store code;behavior) | Behavior/Citizenship for the course/term. [StoredGrades]Behavior |
Teacher Comments | ^(stored.by.course.number;course number;store code;comment) | Teacher comments for the course/term. [StoredGrades]Comment |
Absences | ^(stored.by.course.number;course number;store code;absences) | Absences for the course/term. [StoredGrades]Absences |
Tardies | ^(stored.by.course.number;course number;store code;tardies) | Tardies for the course/term. [StoredGrades]Tardies |
Standards and Standard Grades Section
The standard (std) DAT extracts standard data from the Standard table, and standard grade data from the StandardGradeSection and StandardGradeRollup tables (and their companion tables StandardCourseAssociation, StandardGradeSectionComment, and StandardGradeRollupComment).
When retrieving standard definition information, the DAT returns data from the Standard record.
When retrieving standard grade information, if the standard has only been assessed in one section for the same reporting term, the grade information will be returned from StandardGradeSection. If the standard has been assessed for more than one section for the same reporting term, the grade information will be returned from StandardGradeRollup.
DATs with “cache” in the code (for example, *std.storedcache.avg) pull data from the server memory, rather than accessing the database each time the report is rendered. The first call to one of these DATs caches all of the standard grades for a student for a year. Subsequent calls pull the data from memory. This is advantageous when you want to run reports on multiple standards DATs, and results in increased performance of the report.
Format: ^(*std.stored.high;StandardIdentifier;Store Code;Year;Grade Level)
Example: ^(*std.stored.high;SSS.6;S1;2008;12)
Standards
Note: XX = Standard Identifier, TT = Store Code, YYYY = Year, or GG = Grade Level. The YYYY or GG parameter is optional, and if omitted, the DAT will default to the year selected in the Term context and will include all grade levels.
Name | Code | Description |
|---|---|---|
Description | ^(*std.info.desc;XX) ^(*std.info.desc;SSS.6) | Standard description. [Standard]Description |
Name | ^(*std.info.name;XX) ^(*std.info.name;SSS.6) | Standard name. [Standard]Name |
Type | ^(*std.info.type;XX) ^(*std.info.type;SSS.6) | Standard type. [Standard]Type |
Courses | ^(*std.info.course;XX) | Comma-separated list of course numbers associated with the standard. |
Subject Area | ^(*std.info.subj;XX) | [Standard]SubjectArea |
List Parent | ^(*std.info.listparent;XX) | [Standard]Identifier of the parent standard. |
Conversion Scale | ^(*std.info.conv;XX) | Standard grade conversion scale. |
Standard Grades
Name | Code | Description |
|---|---|---|
Stored Average Score | ^(*std.stored.avg;XX;TT;YYYYorGG) ^(*std.storedcache.avg;XX:TT;YYYYorGG) ^(*std.stored.avg;SSS.6;S1) | Stored average score for the term. [StandardGradeRollup]StandardAveragePercent [StandardGradeSection]StandardPercent |
Stored High Score | ^(*std.stored.high;XX;TT;YYYYorGG) ^(*std.storedcache.high;XX;TT;YYYYorGG) ^(*std.stored.high;SSS.6;S1;2008) | Stored high score for the term/year. [StandardGradeRollup]StandardHighPercent [StandardGradeSection]StandardPercent |
Number of Scores | ^(*std.stored.num;XX;TT;YYYYorGG) ^(*std.storedcache.num;XX;TT;YYYYorGG) ^(*std.stored.num;SSS.6;S1;12) | Number of scores for the standard identifier for this term/grade level. [StandardGradeRollup]NumScores 1 if no StandardGradeRollup record exists. |
Stored Translated Average Score | ^(*std.stored.transavg;XX;TT;YYYYorGG) ^(*std.storedcache.transavg;XX;TT;YYYYorGG) ^(*std.stored.transavg;SSS.6;S1) | Stored translated average score for the term. [StandardGradeRollup]StandardAverageGrade [StandardGradeSection]StandardGrade |
Stored Translated High | ^(*std.stored.transhigh;XX;TT;YYYYorGG) ^(*std.storedcache.transhigh;XX;TT;YYYYorGG) ^(*std.stored.transhigh;SSS.6;S1) | Stored translated high score for the term. [StandardGradeRollup]StandardHighGrade [StandardGradeSection]StandardGrade |
Stored Comment | ^(*std.stored.comment;XX;TT;YYYYorGG) | [StandardGradeRollupComment]CommentValue [StandardGradeSectionComment]CommentValue |
Tests
The Tests DAT extracts information from the [Test], [TestScore], [StudentTest] and [StudentTestScore] tables. Tests are setup at Start Page > District Setup > Tests. When using the Tests DAT, ensure that the test name and test score name are entered exactly as setup at the district.
Format: ^(tests;name=[name];score=[score name];which=[test selection];type=[type];result=[output result];format=[output format])
Parameter | Usage and Examples | Description |
|---|---|---|
Name | ^(tests;name=[name] Example: ^(tests;name=[SAT] | Identifies the test associated with the score. [Test]Name |
Score | ^(tests;score=[score name] Example: ^(tests;score=Math | Identifies the test score to report. Setup Test Scores at Start Page > District > Tests > Edit Scores. [TestScore]Name [TestScore]TestID = [Test]ID |
Which | ^(tests;which=[selection] which=first: Score from first test taken which=last: Score from last test taken which=best: Best test score which=current: Score from current term which=[TermID], such as 1801 which=[Grade_Level], such as 11,or 12 | If there is more than one score for a student with the score name specified in the “score” parameter, use the “which” parameter to identify which of the score to use. [StudentTest]Test_Date [StudentTest]TermID [StudentTest]Grade_Level [StudentTest]TestID = [Test]ID |
Type | ^(tests;type=num ^(tests;type=percent ^(tests;type=alpha | Identifies the type of score to report. [StudentTestScore]AlphaScore, [StudentTestScore]NumScore and [StudentTestScore]PercentScore [StudentTestScore]TestScoreID = [TestScore]ID |
Result | ^(tests;result=value: The value of the scores. ^(tests;result=sum: The sum of the scores. ^(tests;result=avg: The average of the scores. ^(tests;result=date: The date of the scores. ^(tests;result=count: The number of scores. ^(tests;result=min: Uses the minimum scores. ^(tests;result=max: Uses the maximum scores. | Determines what result the DAT will produce. For example, if you want to show the average of several scores, the DAT would appear as: ^(tests;test=SAT;testscore=Math;type=num;result=avg) |
Format | ^(tests;format=##0.00 | Determines the format for the result. |
Example #1:
^(tests;name=midterm;score=english;which=current)
This example returns the total current English score of the midterm test.
Example #2:
^(tests;name=ACT;score=Math;which=last;type=num;result=value;format=##0.00)
This example returns the numerical value of the last math score of the ACT test, such as 23.14 if a student's score was 23.14285. Note that the numeric value is truncated (the value is not rounded) to two decimal places.
GPA
The GPA DAT returns a student’s GPA based on the specified parameters. GPAs are calculated on the fly and not stored in a database table.
Format: ^(*gpa method=”value” type=”value” term=”value” year=”value” grade=”value” credittype=”value” scale=”value”)
Parameter | Usage and Examples | Description |
|---|---|---|
method | ^(*gpa method=”value”) Example: ^(*gpa method=”weighted”) | Specify the name of the GPA calculation to use. If omitted, the weighted calculation will be used. |
type | ^(*gpa method=”value” type=”value”) Example: ^(*gpa method=”weighted” type=”cumulative”) | Specify the type of the calculation: Cumulative, Current, or Projected. If omitted, the Cumulative type is used. |
term | ^(*gpa method=”value” type=”value” term=”value”) Example: ^(*gpa method=”weighted” type=”cumulative” term=”S1,S2”) | Specify one or more term abbreviations. Only grades whose store codes match the specified abbreviations are used in the GPA calculation. If omitted, any store code is permitted. If one or more term abbreviations are specified, but no grade level, only grades from the current school year are evaluated in the GPA calculation. |
grade | ^(*gpa method=”value” type=”value” term=”value” grade=”value”) Example: ^(*gpa method=”weighted” type=”cumulative” term=”S1,S2” grade=”9,10,11,12”) | Specify one or more grade levels (separate multiple values by commas). Only grades stored at the specific grade levels are used in the GPA calculation. If omitted, the historical grade range for the current school is used. |
year | ^(*gpa method=”value” type=”value” term=”value” grade=”value” year=”value”) Example: ^(*gpa method=”weighted” type=”cumulative” term=”S1,S2” grade=”9,10,11,12” year=”2006”) | Specify one or more four-digit school years (separate multiple values by commas). For example, use 2007 to specify the 2007-2008 school year. Only grades stored for the specified school years are used in the GPA calculation. |
credittype | ^(*gpa method=”value” type=”value” term=”value” grade=”value” year=”value” credittype=”value”) Example: ^(*gpa method=”weighted” type=”cumulative” term=”S1,S2” grade=”9,10,11,12” year=”2006” credittype=”MAT,ENG”) | Specify one or more credit types (separate multiple values by commas). Only grades associated with the specified credit types are used in the GPA calculation. If omitted, grades with any credit type (or no credit type) are used in the calculation. |
scale | ^(*gpa method=”value” type=”value” term=”value” grade=”value” year=”value” credittype=”value” scale=”value”) Example: ^(*gpa method=”weighted” type=”cumulative” term=”S1,S2” grade=”9,10,11,12” year=”2006” credittype=”MAT,ENG” scale=”HighSchool”) | Specify the name of the grade scale to use for the calculation. Only grades present in the specified scale are included in the GPA calculation. If the name of the grade scale is not recognized, the Default grade scale is used. If omitted, the GPA points from the grade itself are used. |
If Type, Term, Grade, Year, Credittype, or Scale are specified in the GPA calculation as setup at the District, the setting at the District will take precedence over the setting as specified in the GPA DAT.
For example, if the Weighted GPA is setup at the District with ENG and MAT specified as Credit Types, the following GPA DAT example will only include grades that are associated with the ENG or MAT credit types, even though credittype is not specified in the DAT:
^(*gpa method=”Weighted”)
Class Rank
The Honor Roll DAT returns results from the [ClassRank] table. Class Rank are set up on the Class Rank Methods page.
When creating a class rank method, it is necessary to choose a GPA Calculation Method. For more information on GPAs, navigate to the GPA Calculation Methods page and select a calculation and then access the PowerSchool Help Files. You may also refer to Knowledgebase article 11148 on PowerSource.
Format: ^(*classrank method="[GPA Calculation Method name]" result="[value]" percentiledigits="[decimal places]")
Name | Code | Description |
|---|---|---|
Method | ^(*classrank method="[GPA Calculation Method name]" Example: ^(*classrank method="Simple" Example: ^(*classrank method="Weighted" | Identifies the name of the GPA Calculation Method used to determine the class rank. If the “method” parameter is omitted, the default “weighted” GPA Calculation Method is used. The “weighted” GPA Calculation Method is installed with the PowerSchool application. [ClassRank]GPAMethod |
Result | ^(*classrank result=[“value”] ”gpa”: Displays the student’s GPA. ”outof”: The total number of students in the class rank list. ”percentile”: The student’s rank percentile. ”rank”: The student’s rank. ”rankof”: Displays the rank of the total number of students, such as 5 of 65. ”rankoutof”: Displays the rank out of the total number of students, such as 5 out of 65. “schoolname”: Displays the name of the school where the student earned the class rank. | Determines how the rank is displayed. If this parameter is omitted, PowerSchool uses the “rank” option. [ClassRank]GPA [ClassRank]Outof [ClassRank]Rank [ClassRank]SchoolName |
Percentiledigits | ^(*classrank percentiledigits=[“decimal places”] Example: ^(*classrank percentiledigits=“3” | Determines the number of decimal places to use in the rank result. |
Example #1: ^(*classrank)
Returns the student’s rank value using the weighted class rank method, such as "26".
Example #2: ^(*classrank method="High Honors" result="gpa")
Returns the GPA calculated for the student by the High Honors class rank method used to determine ranking, for instance, "3.92."
Example #3: ^(*classrank result="rankoutof")
Returns the student’s rank value using the Weighted class rank method and the total number of ranked students separated by the words "out of", as in "4 out of 157.”
For more examples, please refer to Knowledgebase article 6490.
Honor Roll
The Honor Roll DAT returns results from the [HonorRoll] table. Honor Roll Methods are set up on the Honor Roll page.
When creating an honor roll level, it is common to choose a GPA Calculation Method. For more information on GPAs, navigate to the GPA Calculation Methods page and select a calculation and then access the PowerSchool Help Files. You may also refer to Knowledgebase article 11148 on PowerSource.
Format: ^(*honorroll method="name" term="abbreviations" grade="grade levels" year="year number" result="data type")
Name | Code | Description |
|---|---|---|
| Method | ^(*honorroll method=”Honor Roll Method name" Example: ^(*honorroll method=”Middle School Honors” | Identifies the name of the Honor Roll Method used to determine the honor roll. [HonorRoll]Method |
| Term | ^(*honorroll term=”term abbreviation” Example: ^(*honorroll term=”S1” Example: ^(*honorroll term=”Q2” | Narrows the honor roll records by the store code used when calculating the Honor Roll. [HonorRoll]StoreCode |
| Grade | ^(*honorroll grade=”grade levels” Example: ^(*honorroll grade=”9” Example: ^(*honorroll grade=”6,7” | Narrows the honor roll records by grade level. [HonorRoll]Grade_Level |
| Year | ^(*honorroll year=”year number” Example: ^(*honorroll year=”2008” Example: ^(*honorroll year=”2006,2007” | Narrows the honor roll records by the year. [HonorRoll]YearID The YearID is 17 for 2007, 18 for 2008, etc. |
| Result | ^(*honorroll result=”[data type]” “level”: Name of the honor roll level. ”message”: Message associated with the honor roll level. ”GPA”: GPA used to determine the honor roll. ”School Name”: School associated with the honor roll record. ”Date”: Date honor roll was calculated. | Determines the honor roll result. [HonorRoll]Level [HonorRoll]Message [HonorRoll]GPA [HonorRoll]SchoolName [HonorRoll]DateStored |
Example #1: ^(*honorroll method=”Achievers" term="T1,Q1" grade="9,10" year="2008" result="gpa")
This example returns the GPA for the Achievers honor roll level record awarded for the T1 and Q1 term associated with the student’s 9th or 10th grade year, within the 2008-2009 school year.
Example #2: ^(*honorroll method="High Honors" term="S1")
This example returns the level value for any High Honors honor roll records awarded for the S1 term.
Example #3: ^(*honorroll method="Scholarship" term="Q3" result="message")
This example returns the text message defined within the Scholarship honor roll level awarded for the Q3 term of the current year. For example: "Congratulations! You have been awarded the Gold Team scholarship for this year!"
Example #4: ^(*honorroll method="Future Leaders" term="T2" grade="7" result="schoolname")
This example returns the name of the school where a Future Leaders honor roll record was awarded for the T2 term of the student’s 7th grade year, for example, "John Connor Middle School".
Credit Hours
The credit_hours DAT returns the number of cumulative historical earned credit hours earned by the student. The value of credit for each historical grade is stored in [StoredGrades]EarnedCrHrs.
There are no parameters for the ^(*credit_hours) DAT.
Format: ^(*credit_hours)
Example:
- Setup ^(*credit_hours) on the Cumulative Information student screen on the GPA Info for Student Screens page.
- View the cumulative credit hours on the Cumulative Information student screen.