Grade

This educational entity represents an overall score or assessment linked to a course over a specific period (i.e., the grading period). Student grades typically consist of a combination of marks and other scores.      

Primary PowerSchool Source Data

[Terms]

Selection Criteria

Records are published if the following criteria are met:

Student, Student Enrollment, Section, StudentSectionAssociation, and GradingPeriod.
The student must not be excluded from state reporting.
Student Section must not be excluded from state reporting.
All Enrollment will be published.

  Data Review

Field	Selection
Choose Dashboard	Grade
Choose Category	Grade info Summary    Grade info Published    Grade info Dependencies    Grade info Errors
Choose Data view	Grade

  Resource Output

Ed-Fi Data Element	Description	Data View Column	Submission	[Table] Field Name	Business Rules	Comments
BeginDate	The date when a particular event or period starts, such as the start date of a course or school year.	Begin Date	Y	[CC]DateEnrolled		Provide valid start date for student’s enrollment in course.
LocalCourseCode	A unique identifier assigned by the local education agency to a course.	Local Course ID / Course Number	Y	[S_KS_CRS_X]LocalCourseId    [Courses]Course_Number	If [S_KS_CRS_X]LocalCourseId is blank then extract from [Courses]Course_Number
SchoolId	A unique identifier assigned to a school within the education system.	School Number	Y	[Schools]SIF_StatePRID [Sections]SchoolId	Derived From [Sections]schoolId     School Number Format: ttbbbdddd If [Schools]SIF_StatePRID is blank, [Sections]SchoolId is pulled. The [Schools]SIF_StatePRID or [Sections]SchoolId must match with the Organization Catalog.	Org Id is defaulted to D=14, if the district wants aNther value to be published then the district must prepend the above alphabet in their district number.   The course is published based on sections created at the school and it uses the Section School Id
SchoolYear	The academic year for which the data is applicable, typically represented as a range (e.g., 2024-2025).	School Year	Y	Calculated using [TERMS]YearID	If 2023-2024, then extract 2024
GradingPeriodSchoolYear	The school year associated with a specific grading period.	Grading Period School Year	Y	Calculated using [TERMS]YearID	If 2023-2024, then extract 2024
SectionIdentifier	A unique identifier for a specific section of a course.	Section Number	Y	Concatenated	SchoolID+[Courses]Course_Number + [Sections]Section_Number +TermdcidID	As per KCAN  [Courses[Course_Number + [Sections]Section_Number + Term_Name    Submit only valid Course Section values.  Do Nt submit Course Section values for Certificate or MigrantServices
SessionName	The name of the session during which the course or event takes place (e.g., Fall 2024).	Session Name	Y	Concatenated  [TERMS]YearID    [Terms]Name	SessionName format:     School Year  Term Name    If 2023-2024, then extract 2024   Session name is a string that represents any of these time periods:  ● Yearlong: 2024 School Year representing 2023-24 School Year  ● Semester/Trimester: 2024 First Semester representing 2023-24 First Semester  ● Quarter: 2024 Quarter 4 representing 2023-24 Fourth Quarter
StudentUniqueId	A unique identifier assigned to each student within the education system.	State Student Number	Y	[Students]State_StudentNumber
GradingPeriodDescriptor	A description of the grading period (e.g., Quarter 1, Semester 1).	Grading Period	Y	Code Set (Descriptors)  [Terms]Portion  [Terms]Abbreviation	Derived from:  [Terms]Portion  [Terms]Abbreviation  These must show under code set mapping of profile KEDS 2023-2024.	Values must be matched with downloaded GradingPerioddescriptors    Navigation: Start Page > System Administrator > Data Exchange > Code Set Mappings
GradingPeriodSequence	The sequence number of the grading period within the school year.	Period Sequence	Y	TERMS.portion  TERMS.abbreviation	Single digit number derived from TERMS.portion and TERMS.abbreviation    Grading period Sequence Logic:  When terms abbrevation is S3 then period Sequence is 1  when terms portion = 1 then period Sequence is 1  when terms abbrevation is Q1 then period Sequence is 1  when terms abbrevation is Q2 then period Sequence is 2  when terms abbrevation is Q3 then period Sequence is 3  when terms abbrevation is Q4 then period Sequence is 4  when terms abbrevation is S1 then period Sequence is 1  when terms abbrevation is S2 then period Sequence is 2  when terms abbrevation is 23-24 then period Sequence is 1 (it will override the terms.portion value)	F
GradeTypeDescriptor	A description of the type of grade awarded (e.g., Final, Midterm).	Grade Type	Y	Final	Hardcoded.
LetterGradeEarned	The letter grade earned by a student (e.g., A, B, C).	Letter Grade	N	[S_KS_CC_X]Letter_Grade_Override [StoredGrades]Grade	If [S_KS_CC_X]Letter_Grade_Override Null Pull from [StoredGrades]Grade
NumericGradeEarned	The numeric grade earned by a student (e.g., 95, 88).	(Numeric)Percent Grade	Y	[S_KS_CC_X]Percent_Grade_Override [StoredGrades ]Percent	If [S_KS_CC_X]Percent_Grade_Override Null Pull from [StoredGrades]Percent
Extension.WorkBasedLearning	Information related to work-based learning experiences, such as internships or apprenticeships.	Work-based Learning	N	[S_KS_CRS_X]Work_Based_Learning
CollegeCreditEarned	The number of college credits earned by a student through dual enrollment or other programs.	College Credits Earned	N	[S_KS_CC_X]CollegeCredits [S_KS_CRS_X]CollegeCredits	If [S_KS_CC_X]CollegeCredits Null Pull from [S_KS_CRS_X]CollegeCredits
InstructionalMinutesCompleted	The total number of instructional minutes completed by a student in a course or session.	Instructional Minutes Completed	N	Calculated using Calendar/Bell Schedule	If [S_KS_STU_Demographic_X]Migrant_Status is True Derived from Calendar else Bell Schedule	The number of instructional hours the migrant student completed during the term.