Grades

This category captures student grades and includes the following data views and resources:

Student Grades

This data view represents a detailed list of student grades successfully published to the ODS, and represents an overall score or assessment tied to a course over a period of time, for example, the grading period. The published view layout provides the School Name, Student Number, Student Name, WISEid, Course Number, Course Name, Section Number, Term ID, Store Code Term, Letter Grade, Numeric Grade, Performance Base Conversion Type, Last Publish Date, Publishing ID, and Resource ID.

Note: Grades resources are only published for public schools.

grades

This educational entity represents an overall score or assessment tied to a course over a period of time. 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 must not be excluded from state reporting.
The student’s school of enrollment must not be excluded from state reporting.
The student's school of enrollment must have an Ed-Fi State School number.
The student's school of enrollment must have a WISEdata Reporting option.
The section must not be excluded from state reporting.
The course must not be marked as Exclude On Report Cards/Transcripts.
The studentUniqueID must be populated in PowerSchool ([Students]State_StudentNumber).
The course must have a valid state course code.
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.
A letter grade or numeric grade must be populated for at least one grading period.
The student must be in grade 9 or above.

Resource Output

A grades record is published for each student, course section, and stored grades record based on year of the Term selected in the PowerSchool UI.
The grades resource includes the most recent grade per course, per grading period.
The grades resource is dependent on the prior publishing of Ed-Fi resources: students, gradingPeriods, and studentSectionAssociation.
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
gradingPeriodReference A reference to the related gradingPeriods resource.				R
/descriptor	gradingPeriodDescriptor - The name of the period for which grades are reported.	String	When [StoredGrades]StoreCode = Y1: '1' Or [Terms]Portion [Terms]Abbreviation	R
/schoolID	The school related to the grading period.	Integer	Derived from: [StoredGrades]SchoolID	R
/beginDate	The month, day, and year of the first day of the grading period.	Date	When [StoredGrades]StoreCode = Y1: The earliest value in [Terms]FirstDay for the term selected in PowerSchool. Otherwise: [Terms]FirstDay	R
studentSectionAssociationReference A reference to the related studentSectionAssociation resource. Note: For students who have multiple enrollments in a section, only the student's final section enrollment is published.				R
/studentUniqueID	The student enrolled in the section.	String	[Students]State_StudentNumber	R
/schoolID	The school related to the student section association.	Integer	Derived from: [Sections]SchoolID	R
/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	Derived from: [Period]Abbreviation [Period]Period_Number	R
/classroomIdentificationCode	A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity.	String	[Sections]Room	R
/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	[Sections]Course_Number	R
/uniqueSectionCode	A unique identifier for the Section that is defined by the classroom, the subjects taught, and the instructors that are assigned.	String	Derived from: [Sections]DCID	R
/sequenceOfCourse	When a Section is part of a sequence of parts for a course, the number if the sequence. If the course has only one part, the value of this Section attribute should be 1.	Integer	'1'	R
/schoolYear	The identifier for the school year.	Integer	[Terms]YearID	R
/termDescriptor	The name of the term in which the section is offered, for example, First semester, Second semester, Year long, Summer school.	String	Derived from: [Terms]Portion [Terms]Abbreviation	R
/beginDate	Month, day, and year of the student's entry or assignment to the section. If blank, default is the start date of the first grading period.	Date-Time	[CC]DateEnrolled	R
type	The type of grade (e.g., Exam, Final, Grading Period, Progress Report).	String	'Final'	R
performanceBaseConversionType	The performance base conversion assessed for the student.	String	Derived from: StoredGrades.EarnedCrHrs StoredGrades.PotentialCrHrs StoredGrades.Grade StoredGrades.Percent CC.SectionID GradeScaleItem.Name GradeScaleItem.GraduationCredit GradeScaleItem.IsProficient GradeScaleItem.CutoffPercentage Note: If none of the conditions listed below are definitively met, a default of 'Pass' is published. 'Pass': [S_WI_GSI_X]Perf_Base_Conversion_Type = P If EarnedCrHrs >= PotentialCrHrs If Grade starts with P, S, or N If GraduationCredit = 1 If IsProficient = 1 'Fail': [S_WI_GSI_X]Perf_Base_Conversion_Type = F If PotentialCrHrs > 0 and EarnedCrHrs = 0 or blank If Grade starts with F If GraduationCredit = 0 If Percent grade < CutOffPercentage for graduation credit based on the grade scale 'Not Completed': [S_WI_GSI_X]Perf_Base_Conversion_Type = N If EarnedCrHrs > 0 and < PotentialCrHrs If both Grade and Percent fields in the StoredGrades table are empty and EarnedCrHrs = 0 If Grade starts with I 'Withdrawal or Dropped': If the TermID in the StoredGrades record is not the latest term for the course If the max value [CC]TermID for the section < 0 'Not Graded': [S_WI_GSI_X]Perf_Base_Conversion_Type = NG	R
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.	Number	[StoredGrades]Percent	O
diagnosticStatement	A statement provided by the teacher that provides information in addition to the grade or assessment score.	String	[StoredGrades]Comment (trimmed to 300 characters) if not blank	O
wiDpiGrade				O
/certificatedProgramStatusType	The student's status in a certificated program.	String	[S_WI_SGR_X]Cert_Programs_Status_Type 'a' = Student met the requirements of the certificated program and was or is to be awarded a certificate 'b' = Student is continuing in the certificated program 'c' = Student has left the certificated program before completion 'd' = Student completed program but did not meet the requirements for the certificate	O