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 and [Schools]Alternate_School_Number if value is greater than 0 | 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 and [Schools]Alternate_School_Number if value is greater than 0 | 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 and [Schools]Alternate_School_Number if value is greater than 0 | 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/ | The school for which the grading period is defined. | Integer | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |