Student Grades
This category captures student grade information as published within the Student Grades category. The Student Attendance category includes the following data views and resources:
grades
This resource will publish all the historical stored grades for all current year enrollments for students in grade levels 9-12. Both letter and numeric grades will be published.
Note: In order to publish Pass, Fail, and Incomplete grades correctly, the appropriate grades in the respective grade scale must be mapped to the applicable NOVA value.
Primary PowerSchool Source Data
[Courses]
[Sections]
[S_NM_GSI_X]
[StoredGrades]
[Students]
[Reenrollments]
Selection Criteria
Records are published if the following criteria are met:
The student was published in the Student category.
The student is in grades 9 - 12.
This will be adjusted to students in grades K - 12 in a future update.
The student has historical grades for the current reporting year that were earned within the reporting LEA.
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 and/or section are not excluded from state reporting.
Resource Output
A separate grade record is published for each qualifying historical (stored) grade.
The grades resource is dependent on the prior publishing of the following resources: student and gradingPeriods.
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 | Data Type | Stored in [Table]Field | Req'd |
---|---|---|---|---|
/gradeTypeDescripotor | The type of grade reported | String | Always “Final” | Req'd |
gradingPeriodReference | ||||
/gradingPeriodDescriptor | The name of the period for which grades are reported. Grading Period Descriptor Set Note: This element requires the Grading Period Descriptor mapping be completed on the Code Set Mappings page. | String | [TermBins]StoreCode | Req'd |
/periodSequence | The sequential order of this period relative to other periods. | Int | [Terms]Portion | Req'd |
/schoolID | The identifier assigned to a school. | Int | [StoredGrade]SchoolID | Req'd |
/SchoolYear | The school year in which the grade was earned. | Derived from the report year. | ||
studentSectionAssociationReference | ||||
/beginDate | Month, day, and year of the Student's entry or assignment to the Section. | Date | [Sections]TermID [Terms]FirstDay [CC[DateEnrolled | Req'd |
/localCourseCode | The local code assigned by the School that identifies the course offering provided for the instruction of students. | String | [Courses]Alt_Course_Number [Courses]Course_Number | Req'd |
/SchoolID | The identifier assigned to a school. | Int | [Sections]SchoolID | Req'd |
/schoolYear | The school year of the section. | Int | [Sections]TermID | Req'd |
/sectionIdentifier | The local identifier assigned to a section. | String | [Sections]Section_Number | Req'd |
/sessionName | The identifier for the calendar for the academic session (e.g., 2010/11, 2011 Summer). | String | This is a combined value of the following:
| Req'd |
/studentUniqueID | A unique number assigned to the student by the state. | String | [Students]State_StudentNumber | Req'd |
/letterGradeEarned | A final or interim (grading period) indicator of student performance in a class as submitted by the instructor. Note: Grades representing a grade of Incomplete, will now publish as “I”. To mark a grade as Incomplete, navigate to Start Page, District Management, District Setup, Academic Grade Scale, Edit existing or create new Grade Scale, NOVA Pass/Fail/Inc Grade Mapping and set the grade to I - Incomplete under the NOVA Pass/Fail/Inc Grade Mapping column. | String | [StoredGrades]Grade | |
/numericGradeEarned | A final or interim (grading period) indicator of student performance in a class as submitted by the instructor. | Num | [StoredGrade]Percent |