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: Profile ID Term Abbreviation Term DCID School ID Year ID	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