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 |
|
Choose Data View |
|
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:
|
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
| The span of time for which grades are reported. Derived from:
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
|