Skip to main content
Skip table of contents

Student Grade Data

This category includes the grades earned by students, along with report card information as published in the grade and reportCard resources within the Student Grade category.

Note: While grading periods are created from terms, [StoredGrades] records are mapped to grading periods using the StoreCode. For a grade to be published, the StoreCode must be either 'Y1' for a year grade, or must match a term record for the school where [StoredGrades]StoreCode = [Terms]Abbreviation.

Student Grades

This view captures the grade records published for students. The layout includes the School Name, Student Number, Student Name, Course Number, Course Name, Section Number, and Term ID, along with Letter Grade, Numeric Grade, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.

grade

This educational resource represents an overall score or assessment tied to a course over a period of time, for example, the grading period. Student grades are usually a compilation of marks and other scores.

Primary PowerSchool Source Data

  • [StoredGrades]

Selection Criteria

Records are published if the following criteria are met:

  • The student was published in the Student category.
  • StudentUniqueId must be populated in PowerSchool.
  • The student must not be excluded from state reporting.
  • The school where the grade was earned must not be excluded from state reporting.
  • The course must have a valid state course code.
  • The course must not be excluded from printing ("sched_do_not_print").
  • The section at the school where the grade was recorded must not be excluded from state reporting ("State_ExcludeFromReporting").
  • The Stored Grades record must not be excluded from transcripts ("excludefromtranscripts").
  • Within the studentSectionAssociationReference complex type, location, classPeriod, and courseOffering must refer to a valid section record in the Master Schedule category.
  • The Store Code for the grade must be either 'Y1' for a year grade, or must match a term record for the school where [StoredGrades]StoreCode = [Terms]Abbreviation.
  • Either letter grade or numeric grade must be populated.

Resource Output

  • A grade record is published for each student, course section, and stored grades record that meets the selection criteria within the year for the Term selected in the PowerSchool UI.
  • Published grades include exam, semester, progress report, grading period, and final grades.
  • Where available, both letter grade and numeric grade are published.
  • The grade resource is dependent on the prior publishing of the following resources: student, section, studentSectionAssociation, and gradingPeriod.
  • 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

letterGradeEarned

A final or interim (grading period) indicator of student performance in a class as submitted by the instructor.

If NumericGradeEarned is not provided, then LetterGradeEarned is required.

Varchar(20)

[StoredGrades]Grade

C

numericGradeEarned

A final or interim (grading period) indicator of student performance in a class as submitted by the instructor.

If LetterGradeEarned is not provided, then NumericGradeEarned is required.

Integer

[StoredGrades]Percent

C

diagnosticStatement

A statement provided by the teacher that provides information in addition to the grade or assessment score.

Varchar(1024)

[StoredGrades]Comment_Value

O

gradeType

The type of grade, for example, Exam, Final, Grading Period, Progress Report.

Enumerated List

Derived from:

[StoredGrades]CreditType

If contains ‘ex’: ‘Exam’

If contains ‘s’: Semester

If contains ‘pr’: ‘Progress Report’

If contains ‘fin’: ‘Final’

Else: ‘Grading Period’

M

studentSectionAssociationReference/studentSectionAssociationIdentity

Relates the student and section associated with the grade.

M

/studentReference/studentIdentity

The student enrolled in the section.

Integer

StudentUniqueId downloaded from State

Derived from:

[CC]StudentID

M

/sectionReference/sectionIdentity

The section in which the student is enrolled.

M

//locationReference/locationIdentity

The location, typically a classroom, where the section meets.

M

///classroomIdentificationCode

A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or resource.

Varchar(20)

[Sections]Room

Default: ‘OPEN’

M

///schoolReference/schoolIdentity

The school for the section’s classroom.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if value is greater than 0
Otherwise [Schools]School_Number

M

//classPeriodReference/classPeriodIdentity

The class period during which the section meets.

M

///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.

Varchar(20)

[Period]Period_Number

Derived from:

[Section_Meeting]Period_Number

M

///schoolReference/schoolIdentity

The school for the section’s class period.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if value is greater than 0
Otherwise [Schools]School_Number

M

//courseOfferingReference/courseOfferingIdentity

The course offering taught in the section.

M

///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; must match localCourseCode in corresponding courseOffering.

Varchar(60)

If Report Course.Section setting is set to Yes, then Local Course Number + Section_Number +’_’+ Section DCID

Otherwise,

[Sections]ID

M

///term

The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school. This must match term in corresponding courseOffering.

Enumerated List

[Sections]TermID

[Terms]Portion

[Terms]Abbreviation

M

///schoolYear

The identifier for the school year, for example, 2010-2011. This must match schoolYear in corresponding courseOffering.

Enumerated List

[Terms]YearID

M

///schoolReference/schoolIdentity

The school offering the course; must match schoolID in corresponding courseOffering.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if value is greater than 0
Otherwise [Schools]School_Number

M

/beginDate


Month, day, and year of the student’s entry or assignment to the section.

Date

[CC]DateEnrolled

R

gradingPeriodReference/gradingPeriodIdentity

Identifies the grading period associated with the grade(s).

M

/gradingPeriod

The name of the period for which grades are reported.

Descriptor

Derived from:

[StoredGrades]StoreCode

Records are mapped to grading periods using StoreCode.

M

/beginDate

Month, day, and year of the first day of the grading period.

Date

Derived from:

[StoredGrades]StoreCode

Map to Terms:

[Terms]FirstDay

M

/educationOrganizationReference/
educationOrganizationIdentity

The school for which the grading period is defined.

Integer

SchoolID downloaded from State

Derived from:

[Prefs]Name=districtnumber 
[Prefs]Value

and

[Schools]Alternate_School_Number if value is greater than 0
Otherwise [Schools]School_Number

M

JavaScript errors detected

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

If this problem persists, please contact our support.