Student Grades
This view represents an overall score or assessment tied to a course over a period of time, for example, the grading period. The layout includes the Student Number, Student Name, Course Number, Course Name, Section Number, Team ID, Store Code, Letter Grade, Numeric Grade, UIC (student's SC unique identification code), Last Publish Date, and Publishing ID.
grades
This association represents an overall score or assessment tied to a course over a period of time (i.e., the grading period). Student grades are usually a compilation of marks and other scores.
Primary PowerSchool Source Data
Terms
StoredGrades
Sections
CC
Selection Criteria
Records are published if the following criteria are met:
The student was previously published in the Student category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The school must not be excluded from state reporting.
The course must have a valid state course code.
The Store Grade for the grade must be either Y1 or F1 for a year grade or must match a term for the school where [StoredGrades]StoreCode = Terms.
Either the letter grade or numeric grade must be populated for at least one grading period.
The stored grades record must not be excluded from the transcript.
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 Grade resource is dependent on the prior publishing of the following resources: GradingPeriod and StudentSectionAssociation.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand ("Schedule" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
gradeTypeDescriptor | GradeType - The type of grade. For example, Exam, Final, Grading Period, or Progress Report. | [StoredGrades]StoreCode For Progress Report [PGFinalGrades]finalgradename | ||
gradingPeriodReference A reference to the related GradingPeriod resource. | R | |||
/descriptor | GradingPeriodDescriptor - The name of the period for which grades are reported. | String | uri://ed.sc.gov/GradingPeriodDescriptor# Derived from: [StoredGrades]storecode [Sections]termid [Terms]Portion | R |
/periodSequence | The sequential order of this period relative to other periods. | [StoredGrades]storecode [Terms]Portion [Terms]Abbreviation | ||
/schoolID | The school related to the grading period. | Integer | Derived from: [StoredGrades]SchoolId [Terms]Portion [Terms]Abbreviation | R |
/schoolYear | The identifier for the school year, for example, 2010-2011.Integer | [Terms]YearID | R | |
studentSectionAssociationReference A reference to the related StudentSectionAssociation resource | R | |||
/beginDate | The month, day, and year of the first insession day of the grading period. | [CC]dateenrolled | ||
/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 Internal spaces in the course number are replaced with an underscore | R |
/schoolId | The school related to the student section association. | Integer | Derived from: [Sections]SchoolID | R |
/schoolYear | The identifier for the school year, for example, 2010-2011. | Integer | [Terms]YearID | R |
/studentUniqueId | The student enrolled in the section. | String | [Students]State_StudentNumber | 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 | [Period]Abbreviation If blank, then [Period]Period_Number | R |
/classroomIdentificationCode | A unique number or an alphanumeric code assigned to a room by a school, school system, state, or other agency or entity. | String | [Section]Room If blank, then 'OPEN' | R |
/SectionIdentifier | A unique identifier for the Section that is defined by the classroom, the subjects taught, and the instructors that are assigned. | String | [Sections]SchoolID - trim[Courses]course_number - [Sections]section_number - to_char[Sections]dcid | R |
/sessionName | The identifier for the calendar for the academic session, for example, 2022-2023, 2023 Summer. | Derived from [Terms]schoolid [Terms]abbreviation [Terms]dcid | R | |
/studentUniqueId | The student enrolled in the section. | String | [Students]State_StudentNumber | R |
diagnosticStatement | A statement provided by the teacher that provides information in addition to the grade or assessment score. This element is not available for Ed-Fi publishing. | String | 'Final', 'Semester', or 'Grading Period' [StoredGrades]Comment_Value | O |
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. | Integer | [StoredGrades]Percent | O |
performanceBaseConversionDescriptor |