Student Grades
This category captures student grades and includes the following data views and resources:
Student Grades
This data view represents a detailed list of Student Grades successfully published to the ODS. This entity represents an overall score or assessment tied to a course over a period of time, for example, the grading period. Records are published if the following criteria are met: The student was previously published in the student interchange, the student's unique identification code (UIC) must be populated in PowerSchool, the student, school and section must not be excluded from state reporting, the course must have a valid state course code, the Store Code for the grade must be either ‘Y1’ for a year grade, or must match a term record for the school where [Stored Grades]Store Code = Terms, and either letter grade or numeric grade must be populated for at least one grading period. A Grade record is published for each student, course section and stored grades record based on year of the Term selected in the PowerSchool UI. The published view layout provides the School Name, Student Number, Student Name, WISER ID, Course Number, Course Name, Section Number, Term ID, Store Code Term, Type, Letter Grade, Numeric Grade, Last Publish Date, Publishing ID, and Resource ID.
grades
This educational entity represents an overall score or assessment tied to a course over a period of time. Student grades are usually a compilation of marks and other scores.
Primary PowerSchool Source Data
- [StoredGrades]
Selection Criteria
Records are published if the following criteria are met:
- The student must not be excluded from state reporting.
- The student’s school of enrollment must not be excluded from state reporting.
- The section must not be excluded from state reporting.
- The student's unique identification code (UIC) must be populated in PowerSchool.
- The course must have a valid state course code.
- The Store Code for the grade must be either ‘Y1’ for a year grade, or must match a term record for the school where [Stored Grades]StoreCode = Terms.
- A letter grade or numeric grade must be populated for at least one grading period.
Resource Output
A Grade record is published for each student, course section, and stored grades record based on year of the Term selected in the PowerSchool UI.
The grades resource is dependent on the prior publishing of Ed-Fi resources: student, gradingPeriods, and studentSectionAssociations.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS manually through Publish All / Publish Missing or by scheduling a time to publish ("Schedule" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
gradingPeriodReference A reference to the related GradingPeriod resource. | R | |||
/descriptor | GradingPeriodDescriptor - The name of the period for which grades are reported. | String | Populated from the first valid value. [CST_PUBCODEMAPPINGMISC]ExternalCode When [StoredGrades]StoreCode = Y1: '1' [Terms]Portion [Terms]Abbreviation | R |
/schoolID | The school related to the grading period. | Integer | Derived from:[S_IN_SCH_X]SchoolNumberPrefix if not empty Otherwise: [Schools]Alternate_School_Number or [Schools]School_Number | R |
/beginDate | The month, day, and year of the first day of the grading period. | Date | When [StoredGrades]StoreCode = Y1: The earliest value in [Terms]FirstDay for the term selected in the PowerSchool UI. Otherwise: [Terms]FirstDay | R |
studentSectionAssociationReference A reference to the related StudentSectionAssociation resource. | ||||
/studentUniqueID | The student enrolled in the section. | String | [Students]State_StudentNumber | R |
/schoolID | The school related to the student section association. | Integer | Derived from:[S_IN_SCH_X]SchoolNumberPrefix if not empty Otherwise: [Schools]Alternate_School_Number or [Schools]School_Number | R |
/classPeriodName | An indication of the portion of a typical daily session in which students receive instruction in a specified subject, for example, morning, sixth period, block period, or AB schedules. | String | Derived from: [Period]Abbreviation [Period]Period_Number | R |
/classroomIdentificationCode | A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. | String | [Sections]Room | R |
/localCourseCode | The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students. | String | [Courses]Course_Number | R |
/uniqueSectionCode | A unique identifier for the Section that is defined by the classroom, the subjects taught, and the instructors that are assigned. | String | Derived from: [Sections]DCID | R |
/sequenceOfCourse | When a Section is part of a sequence of parts for a course, the number if the sequence. If the course has only one part, the value of this Section attribute should be 1. | Integer | '1' | R |
/schoolYear | The identifier for the school year. | Integer | [Terms]YearID | R |
/termDescriptor | The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. | String | Derived from: | R |
/beginDate | Month, day, and year of the student's entry or assignment to the section. If blank, default is the start date of the first grading period. | Date | [Terms]FirstDay Format:'YYYY-MM-DD' | R |
| type | The type of grade (e.g., Exam, Final, Grading Period, Progress Report). | String | GradeType [CST_PUBPUBLISHED_TMP]RUNTIMEPROP_3 | R |
| letterGradeEarned | A final or interim (grading period) indicator of student performance in a class as submitted by the instructor. | String | [StoredGrades]Grade | O |
| numericGradeEarned | A final or interim (grading period) indicator of student performance in a class as submitted by the instructor. | Number | If [StoredGrades]Percent is greater than 0: [StoredGrades]Percent If [StoredGrades]Grade is blank: '0' | O |
| diagnosticStatement | A statement provided by the teacher that provides information in addition to the grade or assessment score. | String | [StoredGrades]Comment_Value | O |