Skip to main content
Skip table of contents

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 SC 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
  • Sections
  • CC

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

gradeTypeDescriptorGradeType - The type of grade. For example, Exam, Final, Grading Period, or Progress Report.

[StoredGrades]StoreCode

For Progress Report

[PGFinalGrades]finalgradename


gradingPeriodReference

A reference to the related GradingPeriod resource.

R

/descriptor

GradingPeriodDescriptor - The name of the period for which grades are reported.

String

uri://ed.sc.gov/GradingPeriodDescriptor#

Derived from: 

[StoredGrades]storecode

[Sections]termid

[Terms]Portion 
[Terms]Abbreviation

R

     /periodSequence

The sequential order of this period relative to other periods.


[StoredGrades]storecode

[Terms]Portion 

[Terms]Abbreviation


/schoolID

The school related to the grading period.

Integer

Derived from:

[StoredGrades]SchoolId

[Terms]Portion

[Terms]Abbreviation

R

/schoolYear

The identifier for the school year, for example, 2010-2011.Integer
[Terms]YearIDR

studentSectionAssociationReference

A reference to the related StudentSectionAssociation resource

R

/beginDate

The month, day, and year of the first insession day of the grading period.


[CC]dateenrolled


/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

R

/schoolId

The school related to the student section association.Integer

Derived from:

[Sections]SchoolID

R

/schoolYear

The identifier for the school year, for example, 2010-2011.Integer[Terms]YearIDR

/studentUniqueId

The student enrolled in the section.String[Students]State_StudentNumberR

/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

/SectionIdentifier

A unique identifier for the Section that is defined by the classroom, the subjects taught, and the instructors that are assigned.String

[Sections]SchoolID - trim[Courses]course_number - [Sections]section_number - to_char[Sections]dcid

R
       /sessionNameThe identifier for the calendar for the academic session, for example, 2022-2023, 2023 Summer.

Derived from

[Terms]schoolid

[Terms]abbreviation

[Terms]dcid

R

/studentUniqueId

The student enrolled in the section.String[Students]State_StudentNumberR

diagnosticStatement





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

This element is not available for Ed-Fi publishing.

String

'Final', 'Semester', or 'Grading Period'

[StoredGrades]Comment_Value

O

letterGradeEarned



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

String

[StoredGrades]Grade

O

numericGradeEarned

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

[StoredGrades]Percent

O
performanceBaseConversionDescriptor



JavaScript errors detected

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

If this problem persists, please contact our support.