Skip to main content
Skip table of contents

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


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.