Result

Code

Description / Function

Cumulative GPA (weighted)

^(*gpa)

The cumulative GPA for the student.

Cumulative GPA (simple)

^(*gpa.simple)

The cumulative GPA for the student using the simple calculation method.

Cumulative credit hours earned

^(*credit_hours)

Includes all courses from each student’s Historical Grades page.

Class rank (Based on cumulative weighted GPA)

^(*class_rank_out_of;gpa)

Inserts the student’s class rank.

You can use any valid GPA type as the GPA parameter (for example, gpa.simple or gpa.percent)

Cumulative avg. % earned in all classes (weighted)

^(*gpa.percent)

Inserts the student’s cumulative average percent in all classes using the weighted calculation method.

Cumulative avg. % earned in all classes (simple)

^(*gpa.percent)

Inserts the student’s cumulative average percent in all classes using the simple calculation method.

GPA for Quarter 1 (weighted)

^(*gpa;Q1)

Calculates the GPA for Q1 of the current school year (the year in which the user is currently working in PowerSchool).

Note: Your school must previously store the Q1 grades for the code to insert the correct GPA.

GPA for the student's entire junior year

^(*gpa;11)

Calculates the GPA for grade 11.

GPA for Q1 of the student's junior year

^(*gpa;11;Q1)

Calculates the student’s Quarter 1 GPA while they were enrolled in Grade 11.

Note: You can enter the codes in any order; if you enter ^(*gpa;Q1;11), the system inserts the same number if you enter ^(*gpa;11;Q1).

GPA for the year 1999

^(*gpa;1999)

Calculates the GPA for 1999 for the current student.

GPA for Quarter 3 (simple)

^(*gpa.simple;Q3)

Same as above but using the simple GPA calculation method.

You can enter percent instead of simple if you want to insert the percent GPA for the quarter.

The current GPA (simple)

^(*gpa.current)

Inserts the each student’s current grade from the Quick Lookup page.

Note: The system always uses the simple calculation method to calculate current grades.

Weighted GPA by Credit Type

^(*gpa.credit_type.ENG)

The weighted GPA for all historical grades for the current student that are of the credit type ENG.

Weighted GPA by Credit Type by Grade

^(*gpa.credit_type.ENG;12)

The student’s weighted GPA for all historical grades that are of the credit type ENG that he or she earned in the twelfth grade.

The average % being earned in the current classes (simple)

^(*gpa.current.percent)

Uses each student’s current grades on the Quick Lookup page to calculate.

School Name

^(schoolname)

Inserts the name of the current school.

School Name Abbreviation

^(schoolabbr)

Inserts the abbreviation of the current school.

Students Age

^(age)

Inserts the current age of each student in the following format: 15 years 3 months.

Students Age (long)

^(age;long)

Inserts the current age of each student in the following format: 15 years, 3 months, and 22 days.

Term Name

^(termname)

The name of the term current for the system (for example, 99-00 Quarter 4).

School Year / Term Abbreviation

^(abbryearterm)

For example, 99-00 Q4.

School Year Name

^(yearname)

For example, 1999-2000 School Year.

School Year Abbreviation

^(yearabbr)

For example, 99-00.

Term Abbreviation

^(termabbr)

For example, Q4.

Teacher Comments

^(teachercomments)

Inserts each teacher’s comments preceded by the label Per (number).

Note: This code is often inserted in report card footers if you do not include the teacher comments in the schedule listing.

Attendance Points (per class)

^(attpointsperiod;2)

Total attendance points in the student’s current period 2 class.

Attendance Points (per quarter)

^(attpointsperiod;2;Q4)

Total attendance points in the student’s period 2 class during Quarter 4.

Attendance Points (by date)

^(attpointsperiod;2;1/1/99;3/1/99)

Attendance points the student earned in his or her period 2 class between 1/1/99 and 3/1/99.

Absences (per class)

^(per.att;2)

Total absences in the student’s current period 2 class.

Tardies

^(per.att;2;tar)

Total tardies in the student’s current period 2 class.

Total H Attendance Marks

^(per.att;2;H)

Total number of H attendance codes entered for the student in his or her period 2 class.

Total H Attendance Marks (per quarter)

^(per.att;2;H;Q4)

Total number of H attendance codes entered for the student in his or her period 2 class during Quarter 4 only.

Total H Attendance Marks (by date)

^(per.att;2;H;1/1/99;3/1/99)

Total number of H attendance codes entered for the student in his or her period 2 class during the specified dates.

Daily Membership (by date)

~(*DM;5/1/2000;5/31/2000;true)

Days of membership by date for a single student. Use in reports and exports.

Daily Attendance (by date)

~(*DA;5/1/2000;5/31/2000;true)

Days of attendance by date for a single student. Use in reports and exports.

Period Information

^(*period_info;1;current_grade;Q1)

The student’s current letter grade in his or her period 1 class in the specified term.

Period Information

^(*period_info;1;current_percent)

The student’s current percent grade in his or her period 1 class.

Period Information

^(*period_info;1;current_citizenship)

The student’s current citizenship grade in his or her period 1 class.

Period Information

^(*period_info;01;teacher_name)

The name of the teacher who teaches the student’s period 1 class.

Period Information

^(*period_info;1;teacher_comment)

The student’s current teacher comment in his or her period 1 class.

Period Information

^(*period_info;1;course_name)

The name of the student’s period 1 course.

Period Information

^(*period_info;1;course_number)

The course number of the student’s period 1 course.

Period Information

^(*period_info;1;room)

The room in which the student’s period 1 class meets.

Period Information

^(*period_info;1;section_number)

The section number of the student’s period 1 class.

Smart Pronouns

Smart Pronouns

^(His/Her)

Inserts His or Her based on the student’s gender.

Smart Pronouns

^(he/she)

Inserts he or she based on the student’s gender.

Smart Pronouns

^(He/She)

Inserts He or She based on the student’s gender.

Smart Pronouns

^(him/her)

Inserts him or her based on the student’s gender.

Smart Pronouns

^(Him/Her)

Inserts Him or Her based on the student’s gender.

Smart Pronouns

^(son/daughter)

Inserts son or daughter based on the student’s gender.

*period_info

Examples:
*period_info;03;teacher_name
*period_info;03;course_name
*period_info;03;course_number
*period_info;03;room
*period_info;03;current_grade;S2
*period_info;03;current_percent;Q3
*period_info;03;current_citizenship
*period_info;03;section_number
*period_info;03;teacher_comment

*gpa

Examples:
*gpa
*gpa.simple
*gpa;S1
*gpa.simple;Q3
*gpa;1999
*gpa;1999;S1
*gpa.simple;9
*gpa.simple;10;S1
*gpa.credittype.Math
*gpa.credittype.Math;S2
*gpa.credittype.Math;1999
*gpa.credittype.Math;11
*gpa.credittype.Math;9;S1
*gpa.credittype.Math;1999;S1
*gpa.percent
*gpa.simple.percent
*gpa.percent;S1
*gpa.percent.simple;Q3
*gpa.percent;1999
*gpa.percent.simple;9
*gpa.percent.simple;10;S1

^(attpointsperiod)

Examples:
^(attpointsperiod;02)
^(attpointsperiod;02;Q3)
^(attpointsperiod;02;2/1/2001;5/31/2001)

^(per.att)

Examples:
^(att.per;03)
^(att.per;03;T)
^(att.per;03;S1)
^(att.per;03;Q2;E)
^(att.per;03;2/1/2001;4/1/2001)
^(att.per;03;2/1/2001;4/1/2001;I)

*DM

Examples:
*DM;S1
*DM;1/16/2001;5/31/2001

*DA

Examples:
*DA;S1
*DA;1/16/2001;5/31/2001

^(field;if.fieldvalue.xxx.then=)

^(field;if.fieldvalue.#xxx.then=)
^(field;if.blank. then=)
^(field;if.not.blank. then=)

Examples:
^(ethnicity;if.fieldvalue.white.then=Caucasian)
^(ethnicity;if.fieldvalue.#white.then=Other)
^(polio3;if.blank.then=)
^(bus;if.#blank.then= ride bus)

~(stored.by.course.number)

Examples:
^(stored.by.course.number;120;Q2;grade)
^(stored.by.course.number;120;Q2;behavior)
^(stored.by.course.number;120;Q2;absences)
^(stored.by.course.number;120;Q2;comments)
^(stored.by.course.number;120;Q2;tardies)
^(stored.by.course.number;120;Q2;credittype)
^(stored.by.course.number;120;Q2;earnedcrhrs)
^(stored.by.course.number;120;Q2;potentialcrhrs)

^(std)

Examples:
^(*std.avg;LA11.2.3)
^(*std.transhigh;M12.4.5)
^(*std.num;FL3)

Extrapolates standards scores for a student. You must identify which standard code you want and the identifier.

If you do not include specific terms or dates, the default is current standard cumulative scores. You may choose average score, high score, translated score, translated high score, number of scores, and a note.

^(std.stored)

Examples:
^(*std.stored.transavg;LA11.2.3;S1)
^(*std.stored.avg;SC3.5.12;Q4)
^(*std.stored.high;FL2.5;T1;1999)
^(*std.stored.num;FA5.12;S2;11)

Extrapolates stored standards scores for a student. You must identify which standard code you want and the identifier.

If you do not include specific terms or dates, the default is current standard cumulative scores. You may choose average score, high score, translated score, translated high score, number of scores, and a note. The differences between the std code and this code are the term, year, and grade qualifiers.

^(std.info)

Examples:
^(*std.info.name;LA11.2.3)
^(*std.info.desc;SC3.5.12)
^(*std.info.type;FL2.5)

Calculates the aggregate membership days per student for the term in which you are currently working in PowerSchool.

Aggregate membership days are the total number of days the student was enrolled at the school. In some states, this number is reduced by factors such as enrollment in special programs.

You can use this code on custom pages and in student export files.

Examples:
~(aggmemdays;10/1/99;11/1/99)

Note: The system uses only days in the current school year in the total.

If you enter two dates within the code, the system inserts the total number of membership days per student that fall within the specified date range.

You can use this code on custom pages and in student export files.

Examples:
~(decode;~(grade_level);9;Freshman;
10;Sophomores;Upper Class), the report, file, or page displays Freshman instead of 9, Sophomore instead of 10, and Upper Class for any other grade level.

This code translates values you store in PowerSchool into other values in export files, reports, and custom pages.

Note: This code is for custom pages only.

If you insert this code in a custom page, and your school uses automatic PowerSchool updates, the PowerSchool update ignores this page; and the page is not updated.