Student Grades
This category includes the grades earned by students as published in the Grades resource and includes the following data views and resources:
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 Michigan 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
- PGFinalGrades
- Sections
- CC
- S_MI_TRM_TSDL_X
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' 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 |
|---|---|---|---|---|
gradingPeriodReference A reference to the related GradingPeriod resource. | R | |||
/descriptor | GradingPeriodDescriptor - The name of the period for which grades are reported. | String | Derived from: [Terms]Portion | R |
/schoolID | The school related to the grading period. | Integer | Derived from: [StoredGrades]SchoolId | R |
/beginDate | The month, day, and year of the first day of the grading period. | Date Time | [Terms]FirstDay Format: 'YYYY-MM-DD' | R |
studentSectionAssociationReference A reference to the related StudentSectionAssociation resource | R | |||
/studentUniqueId | The student enrolled in the section. | String | [Students]State_StudentNumber | R |
/schoolId | The school related to the student section association. | Integer | Derived from: [Sections]SchoolID | 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 |
/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, and leading /trailing spaces are removed. | R |
/uniqueSectionCode | A unique identifier for the Section that is defined by the classroom, the subjects taught, and the instructors that are assigned. | String | [Sections]SchoolID + "-" + [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, for example, 2010-2011. | 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: [Terms]Portion | 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 Time | [CC]DateEnrolled If blank, then [Terms]FirstDay Format: 'YYYY-MM-DD' | R |
type | The type of grade (e.g., Exam, Final, Grading Period, Progress Report). | String | Derived from: [StoredGrades]TermID and StoreCode 'Final' If [S_MI_TRM_TSDL_X] for the section term has a matching storecode. Or If [StoredGrades]StoreCode = 'Y1' or contains 'F' Or If the current date is after the end of the section term, 'Semester' 'Progress Report' If [PGFinalGrades]LastGradeUpdate is greater than [StoredGrades]DateStored and the grade in PGFinalGrades does not match the grade in StoredGrades. Otherwise: 'Grading Period' | R |
letterGradeEarned | A final or interim (grading period) indicator of student performance in a class as submitted by the instructor. | String | 'Final', 'Semester', or 'Grading Period' [StoredGrades]Grade 'Progress Report' [PGFinalGrades]Grade | O |
numericGradeEarned | A final or interim (grading period) indicator of student performance in a class as submitted by the instructor. | Number | 'Final', 'Semester', or 'Grading Period' [StoredGrades]Percent 'Progress Report' [PGFinalGrades]Percent | O |
diagnosticStatement | A statement provided by the teacher that provides information in addition to the grade or assessment score. | String | 'Final', 'Semester', or 'Grading Period' [StoredGrades]Comment_Value 'Progress Report' [PGFinalGrades]DiagnosticStatement | O |