Skip to main content
Skip table of contents

Grading Periods

This view captures the grading periods defined at each school within the district as published in the gradingPeriod resource within the Organization Info category. The layout provides the School Name, Name of Term, First Day of Term, Last Day of Term, Last Publish Date, and the Publishing ID.

gradingPeriod

This resource represents the time span for which grades are reported.

Primary PowerSchool Source Data

  • [Terms]

Selection Criteria

Records are published if the following criteria are met:

  • A session record is created for each TERM defined for a school.

  • A Grading Period record is created for each TERM defined for a school 

  • The school must not be excluded from state reporting.

  • The term or term portion exists within the year for the Term selected in the PowerSchool UI.

 Data Review

Field

Selection 

Choose Category 

  • Organization info Summary 

  • Organization info Published

  • Organization info Dependencies 

  • Organization info Errors 

Choose Data View 

  • GradingPeriod

Resource Output

  • A separate gradingPeriod record is published for each unique term record at each school based on [Terms]Portion and [Terms]Abbreviation.

  • The gradingPeriod resource is dependent on the prior publishing of the Session (Terms) resource.

  • LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Ed-Fi Data Element

Descirption

Data View Column

Submission

[Table] Field Name

Business Rules 

PeriodSequence 

The sequential order of periods within a school day.

Period Sequence  

Required

[TERMS]Portion 

[TERMS]Abbreviation 

Single digit number derived from TERMS.portion and TERMS.abbreviation 

 

Grading period Sequence: 
When terms abbrevation is S3 then period Sequence is 1
when terms portion = 1 then period Sequence is 1 
when terms abbrevation is Q1 then period Sequence is 1
when terms abbrevation is Q2 then period Sequence is 2
when terms abbrevation is Q3 then period Sequence is 3
when terms abbrevation is Q4 then period Sequence is 4
when terms abbrevation is S1 then period Sequence is 1
when terms abbrevation is S2 then period Sequence is 2
when terms abbrevation is 23-24 then period Sequence is 1 (it will override the terms.portion value) 

 

 

SchoolId 

A unique identifier assigned to a school within the district.

School Number 

Required

[Schools]SIF_StatePRID 

[Schools]Schoolnumber 

 School Number Format: ttbbbdddd

If [Schools]SIF_StatePRID is blank, [Schools]School_number is pulled.

The [Schools]SIF_StatePRID or [Schools]School_number must match with the Organization Catalog.

Org ID is defaulted to D=14, if the district needs another value to be published then the district must prepend the above alphabet in their district number. 

SchoolYear 

The academic year for which data is being reported, typically spanning from fall of one year to summer of the next.

Year 

Required

Calculated using [TERMS]YearID 

If 2023-2024, then extract 2024 

BeginDate 

The start date of a particular session, term, or grading period.

First Day 

Required

[TERMS]Firstday  

 Not applicable.

EndDate 

The end date of a particular session, term, or grading period.

Last Day 

Required

[TERMS]Lastday  

 Not applicable.

GradingPeriodDescriptor 

A code or label that describes the grading period, such as "Q1" for the first quarter or "S1" for the first semester.

Grading Period 

Required

Code Set (Descriptors) 

[Terms]Portion
[Terms]Abbreviation 

 

The span of time for which grades are reported.

Derived from:

  • [Terms]Portion

  • [Terms]Abbreviation 

These are displayed under code set mapping of profile KEDS 2023-2024.

 

TotalInstructionalDays 

The total number of days within a session, term, or grading period during which instruction is provided to students.

Total Instruction Days 

Required

[TERMS]Firstday 

[TERMS]Lastday 

Sum of in session days between TERMS.firstday and TERMS.lastday 

 

JavaScript errors detected

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

If this problem persists, please contact our support.