SIF GPA

On this page:

Introduction

This report calculates and stores simple and weighted GPAs for students in grade levels 9-12. The students’ GPA records are stored in the database in order to be sent via SIF as part of the Utah e-Transcript and Exchange (UTREx) project. It is more efficient for PowerSchool to send data that is already stored than to calculate the data each time it needs to be sent. If the student does not have a record in the table, then a new record is inserted. If the student already has a record, then the existing record is updated.

Note: The table name is UT_StudentGPAAttendance (for districts using ODBC or another method to query the database).

The students’ GPAs can be viewed on the Utah State Information page (Start Page > student selection > State/Province – UT). The GPA is only visible for students in grade level 9, 10, 11, and/or 12 and can only be updated using this report.

Prior to running this report, a simple GPA calculation method must be assigned to each school with students in grades 9-12. On the Edit School page (Start Page > District Setup > Schools/School Info > Edit School), scroll to SIF GPA Setup and choose the appropriate GPA calculation method for the Simple GPA. The Weighted GPA is optional. This section of the page only appears for schools with grade levels 9, 10, 11, and/or 12. The available GPA calculation methods can be edited via Start Page > District Setup > GPA Calculations > Calculation Methods. See District Setup for information on GPA calculation methods.

Note: To run the report with a different GPA calculation method for a particular school year, navigate to the Edit School page, change the GPA calculation method selection, then change the term at the top of the page before running the report. You must change the GPA calculation method on the Edit School page each time you want to use a different method.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records from the [Students] table based on the following criteria:

The student must be enrolled in the school during the current school year.

Note: The current school year is based on the term selected at the top of the page when the report is run. To change the term, click Term and choose the appropriate value from the pop-up menu.

The student must be enrolled in grade level 9, 10, 11, or 12.
The student must have at least one historical grade associated with this school.
The student must not be excluded from state reporting.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Use	If run at the district level, choose one of the following from the pop-up menu: Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria. Current School Only – Includes all records associated with the current school that meet the selection criteria. District Wide – Includes all records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Processing Options	Choose a time to run the report from the pop-up menu: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
Specific Date/Time	Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Data Element	Description	[Table]FieldName
Student Name	The student’s preferred name.	[Students]LastFirst
Legal Student Name	The student's legal name.	[StudentCoreFields]PSCore_Legal_Last_Name [StudentCoreFields]PSCore_Legal_First_Name
School ID	The school number.	[Schools]School_Number
Student ID	The student’s locally assigned identifier.	[Students]ID
Grade Level	The student’s grade level.	[Students]Grade_Level
Cumulative Simple GPA	The student’s cumulative simple GPA. The report calculates the student’s GPA based on the GPA calculation method selected for the school. If the default Simple GPA Calculation method is used, review additional information about how simple GPA is calculated.	[StoredGrades]StudentID [StoredGrades]SchoolID
Cumulative Weighted GPA	The student’s cumulative weighted GPA. The report calculates the student’s GPA based on the GPA calculation method selected for the school. If the default Weighted GPA Calculation method is used, review additional information about how weighted GPA is calculated.	[StoredGrades]StudentID [StoredGrades]SchoolID

Back to Top