Skip to main content
Skip table of contents

Update Stored Class Rank and GPA Data

Introduction

This report copies and stores Class Rank and GPA data for selected students from the PowerSchool core Class Rank table to the Iowa State extended fields in order to preserve official rank information for use with the Iowa eTranscript. The report also supports the ability to delete stored Class Rank and GPA data. The current values for the Weighted and Non-weighted GPA Methods specified in Schools/School Info for the student’s current or most recent reportable school are used to identify the Rank and GPA data to store and/or delete. The values copied from the Class Rank table are available for review in the Class Rank/GPA tab of the State/Province IA page. Overrides to these calculated fields are also available and can be imported for schools that do not use the PowerSchool Class Rank feature.

Selection Criteria

This report does not have selection criteria defined.

Report Input

For help with report navigation and generation, see Generate Reports.

Field

Description

Select Schools*

If run at the district level, choose one of the following:

  • Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.

  • All Schools – Run the report for the entire district.

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*

Select one of the following:

  • 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.

If running the report for a single student, or group of students, select the students prior to running the report.

Action to Take*

Choose the action:

  • Store New Rank/GPA Data

  • Delete Stored Rank/GPA Data

  • Report Only

GPA/Rank Type*

Choose the data to copy from the following (applies only when data is stored or deleted):

  • Both Non-weighted and Weighted GPA/Rank

  • Non-weighted GPA/Rank only

  • Weighted GPA/Rank only

Rank/GPA Overrides*

Choose which override values to delete (applies only when data is deleted):

  • Delete Non-Weighted Overrides

  • Delete Weighted Overrides

  • Delete Both

Output Type

Select the output file format:

  • PDF

  • CSV

Run Now

Select this option if the user wants to run the report immediately.

Schedule

Select this option if the user wants to run this report on a scheduled basis. Once this option is selected the following choices are:

  • Run Once

    • Start Date and Start Time to run the report.

  • Repeat

    • Select Daily, Weekly, Monthly or Yearly for the appropriate re-occurrence for running the report.

      • If Daily is selected, check the Weekdays only box to limit to weekdays.

      • If Weekly is selected, check which weekday to run the report.

      • If Monthly is selected, check the month to run the report.

      • If Yearly is selected, select either the date or the weekday to run the report.

  • Date Range – Select No End Date or a date that the re-occurrence should end

Report Output

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

This report outputs a PDf and CSV file.

Item

Data Element

Description

[Table]FieldName

A

Students name

The student's first, middle, and last name.

[Students]First_Name

[Students]Middle_Name

[Students]Last_Name

B

Local ID

The student's local ID number.

[Students]Student_Number

C

State ID

The student’s state-assigned identifier

[Students]State_StudentNumber

D

Grade

The student's current grade level.

[Students]Grade_Level

E

Gender

The student's gender.

Valid values:

  • Female (F)

  • Male (M)

  • Non Binary (X)

[Students]Gender

F

School Number

The school number.

[Schools]School_Number

G

School Name

The school name.

[Schools]Name

Non-Weighted Rank/GPA

Overrides

H

Ovr Nwgt Class Size

The override for the non-weighted class size.

[S_ IA_STU_RANK]Ovr_Nwgt_Class_Size

I

Ovr Nwgt GPA

The override for the non-weighted cumulative GPA.

[S_ IA_STU_RANK]Ovr_Nwgt_GPA

J

Ovr Nwgt Rank

The override for the non-weighted class rank.

[S_ IA_STU_RANK]Ovr_Nwgt_Rank

K

Ovr Nwgt Rank Date

The override for the non-weighted rank date.

[S_ IA_STU_RANK]Ovr_Nwgt_Rank_Date

L

Ovr Nwgt School

The override for the non-weighted rank school.

[S_ IA_STU_RANK]Ovr_Nwgt_Rank_Sch

M

Ovr Nwgt Date Entered

The date the override for the Non-weighted Rank date entered.

[S_ IA_STU_RANK]Ovr_Nwgt_Date

Stored Ranks

N

Stored Non-Wgt Rank

The Stored Ranks non-weighted class rank.

[S_ IA_STU_RANK]Nwgt_Rank

O

Stored Non-Wgt Class Size

The Stored Ranks non-weighted class size.

[S_ IA_STU_RANK]Nwgt_Class_Size

P

Stored Non-Wgt GPA

The Stored Ranks non-weighted cumulative GPA.

[S_ IA_STU_RANK]Nwgt_GPA

Q

Stored Non-Wgt Rank Date

The Stored Ranks non-weighted rank date.

[S_ IA_STU_RANK]Nwgt_Rank_Date

R

Stored Non-Wgt School

The Stored Ranks non-weighted rank school.

[S_ IA_STU_RANK]Nwgt_Rank_Sch

S

Stored Non-Wgt Date Copied

The date when the Stored Rank non-weighted rank data was stored.

[S_ IA_STU_RANK]Nwgt_Date

Current Rank

T

Current Non-Wgt Rank

The Current Rank non-weighted class rank.

[S_ IA_STU_RANK]Nwgt_Rank

U

Current Non-Wgt Class Size

The Current Rank non-weighted class Size.

[S_ IA_STU_RANK]Nwgt_Class_Size

V

Current Non-Wgt Cumulative GPA

The Current Rank non-weighted Cumulative GPA.

[S_ IA_STU_RANK]Nwgt_GPA

W

Current Non-Wgt Rank Date

The Current Rank non-weighted Rank date.

[S_ IA_STU_RANK]Nwgt_Rank_Date

X

Current Non-Wgt School

The Current Rank non-weighted Rank school.

[S_ IA_STU_RANK]Nwgt_Rank_Sch

Weighted Rank/GPA

Overrides

Y

Ovr Wgt Class Size

The override for the weighted class size.

[S_ IA_STU_RANK]Ovr_Wgt_Class_Size

Z

Ovr Wgt GPA

The override for the weighted cumulative GPA.

[S_ IA_STU_RANK]Ovr_Wgt_GPA

AA

Ovr Wgt Rank

The override for the weighted class eank.

[S_ IA_STU_RANK]Ovr_Wgt_Rank

AB

Ovr Wgt Rank Date

The override for the weighted rank date.

[S_ IA_STU_RANK]Ovr_Wgt_Rank_Date

AC

Ovr Wgt School

The override for the eighted rank school.

[S_ IA_STU_RANK]Ovr_Wgt_Rank_Sch

AD

Ovr Wgt Date Entered

The date when the override for weighted rank data was stored.

[S_ IA_STU_RANK]Ovr_Wgt_Date

Stored Ranks

AE

Wgt Rank

The Stored Ranks weighted class rank.

[S_ IA_STU_RANK]Wgt_Rank

AF

Wgt Class Size

The Stored Ranks weighted cass size.

[S_ IA_STU_RANK]Wgt_Class_Size

AG

Wgt Cumulative GPA

The Stored Ranks weighted cumulative GPA.

[S_ IA_STU_RANK]Wgt_GPA

AH

Wgt Rank Date

The Stored Ranks weighted rank date.

[S_ IA_STU_RANK]Wgt_Date

AI

Wgt School

The Stored Ranks weighted rank school.

[S_ IA_STU_RANK]Wgt_Rank_Sch

AI

Wgt Date Copied

The date the Stored Ranks weighted rank data was stored.

[S_ IA_STU_RANK]Wgt_Date

Current Rank

AK

CR Wgt Rank

The Current Rank weighted class rank.

[S_ IA_STU_RANK]Wgt_Rank

AL

CR Wgt Class Size

The Current Rank Weighted Class size.

[S_ IA_STU_RANK]Wgt_Class_Size

AM

CR Wgt Cumulative GPA

The Current Rank Weighted Cumulative GPA.

[S_ IA_STU_RANK]Wgt_GPA

AN

CR Wgt Date

The Current Rank Weighted Rank date.

[S_ IA_STU_RANK]Wgt_Date

AO

CR Wgt School

The Current Rank Weighted Rank school.

[S_ IA_STU_RANK]Wgt_Rank_Sch

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close