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, STN Number, Course Number, Course Name, Section Number, Term ID, Store Code Term, Letter Grade, Numeric Grade, Last Publish Date, Publishing ID, and Resource ID.

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 section must not be excluded from state reporting.
The studentUniqueID (Vermont Student Number) 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 [Stored Grades]StoreCode = Terms.
A letter grade or numeric grade must be populated for at least one grading period.

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	Required
Grades		Describes a grade result for a student attempt of a course/section
	gradeTypeDescriptor	The type of grade being assigned.	Descriptor	GradeType_DX	Yes
	diagnosticStatement	A detailed description of a specific issue or condition identified through assessment.	String 1024	DiagnosticStatement	Yes
	letterGradeEarned	This refers to the traditional letter grades assigned to students based on their performance, such as A, B, C, D, or F.	String 20	LetterGrade	Yes
	numericGradeEarned	This is a numerical representation of a student’s performance, often on a scale from 0 to 100.	Double	NumericGrade	Yes
	performanceBaseConversionDescriptor	This describes how a student’s performance is assessed and converted into a standardized format, such as pass/fail or incomplete.	Descriptor		Yes
gradingPeriodReference
	gradingPeriodDescriptor	It defines the specific part of the school year when grades are assigned, such as “First Six Weeks” or “1st Semester.”	Descriptor	GradingPeriod_DX	Yes
	periodSequence	An integer that uniquely identifies and orders grading periods within a school year to differentiate between multiple grading periods that may have similar descriptors	Integer	PeriodSequence	Yes
	schoolId	A unique identifier for a school.	Integer	SchoolOrgID	Yes
	schoolYear	The the academic year for which data is being recorded.	Integer	SchoolYear	Yes