This educational entity 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.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
Action
Trigger
Post
When a grade is posted to a Grading Task that is mapped to an Ed-Fi Grade Type, or a grade is posted to a standard tied to a Rubric that is mapped to an Ed-Fi Grade Type:
Standards will report to Ed-Fi if they are contained in a Standard Group that is mapped in Learning Standards.
Do not report if the Course is marked as Inactive or State Excluded.
Do not send records if the School or Calendar Exclude check box is checked.
Check to see if the student has a Student Section Association in the Ed-FI identity Mapping table before sending.
If the Student Section Association exits, continue with processing the record to Ed-Fi.
If the Student Section Association does not exist, the record will go to the Error Log with a message stating: Student (First Name Last Name, Ed-Fi ID) does not have a Student Section Association record for the course (Course Number Course Name). This record must exist before Grades can be sent.
The Grading Task must be mapped to a Grading Period to report.
Report to the Grading Period that over laps the Term the grade is Posted to.
The end date of the Grading Period must be on or after the Term Start Date and on or before the Term End Date based on the Term to which the grade is posted.
If the Grade is aligned to more than 1 Grading Period that overlaps the Term, the grade will report to all eligible Grading Periods.
Put
When a grade is updated on a Grading Task that is mapped to an Ed-Fi Grade Type.
Delete
When a grade is deleted from a Grading Task that is mapped to an Ed-Fi Grade Type.
Delete
When Grade Type Descriptor is no longer mapped and a resync is performed.
Delete
When a Student Section Association no longer exists.
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
Action
Business Rule
None
If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Delete
If a resource is toggled to 'OFF" after data has sent and an action is performed that would trigger a delete, that data will remain in the ODS until a resync is done.
Resync
If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
Resync
If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
Resync
If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.
Resync
If Rubric is changed after mapping, a resync will need to be done to reflect the changes.
Natural Key Changes, Cascading Updates, and Deletes Logic
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
Action
Trigger
Delete/Post
Natural Key change: If the Natural Key of the Grading Period Reference or Student Section Association changes, a delete/post will occur.
Delete/Post
If the Grade Type Descriptor is changed or removed.
Scope Year Logic
This table describes scope year logic of this object.
Logic
Grades will post to the scope year the course's calendar is aligned to.
Data will only send for the years that have valid configuration.
Resource Preferences
This table describes the Resource Preferences of this object.
Data Element Label
Mapping Needed
Grading Tasks
Grade Type Descriptors
Identity Mapping Object Key
campusObjectType
Object Key Data Source
GradingScore - Section - Term - EdFiGradingPeriod
scoreID - sectionID - termID - gradingPeriodID
Event Queue Detail
This table describes the Event Queue Detail of this object.
Campus Table
Ed-Fi Action
Fields
gradingscore.score
Post/Put/Delete
The primary table used for sending data for this resource.
gradingTask
Post/Put/Delete
The primary table used for sending data for this resource.
Object Data Elements
This table describes data elements sent within the Grades resource.
Data Element Label
Business Requirement
Business Rules
M, C or O
Data Source GUI Path
Database Field
id
The unique identifier of the resource.
M
gradeTypeDescriptor
The type of grade (e.g., Exam, Final, Grading Period, Progress Report).
Reports the Ed-Fi Code from mapping for the Grading Task or Rubric.
If the grading task or Rubric is not mapped, do not report.
M
Grading & Standards> Grading Tasks
gradingTask
gradingPeriodReference
A reference to the related GradingPeriod resource.
Reports the fields that are part of the Natural Key for the Grading Period the Grading Task or Standard is aligned to:
Only report to Grading Periods that are aligned to the Term Schedule the grade was posted in.
M
studentSection AssociationReference
A reference to the related Student Section Association resource.
Reports the fields that are part of the Natural Key for the Student Section Association resource.
M
diagnostic Statement
A statement provided by the teacher that provides information in addition to the grade or assessment score.
This field is optional, does not report.
O
letterGradeEarned
A final or interim (grading period) indicator of student performance in a class as submitted by the instructor.
Reports only for grades posted from a grading task.
Determine if the posted score is an integer or not:
If the posted value is not an Integer, then report the posted score here.
If the posted value is an Integer, then report in the Numeric Grade Earned field below.
O
Grading & Standards> Score Groups & Rubrics> Score
gradingscore.score
numericGrade Earned
A final or interim (grading period) indicator of student performance in a class as submitted by the instructor.
Reports only for grades posted from a grading task
Determine if the posted score is an integer or not:
If the posted value is an Integer, then report the posted score here.
If the posted value is not an Integer, then report in Letter Grade Earned field above.
O
Grading & Standards> Score Groups & Rubrics> Score
gradingscore.score
performanceBase ConversionDescriptor
The performance base conversion assessed for the student.
O
learningStandardGrades
An unordered collection of gradeLearningStandardGrades. A collection of learning standards associated with the grade.
Reports an item for each grading score that meets the following criteria:
Grading score is associated to a learningStandard.
Grading score is associated to this natural key (same person, section, termDescriptor, gradeTypeDescriptor, gradingPeriodDescriptor, and gradingPeriod sequence).
O
Scheduling > Course > Standards
Arrays
Data Element Label
Business Requirement
Business Rules
M, C or O
Data Source
GUI Path
Database Field
performanceBaseConversionDescriptor
A performance level that describes the student proficiency.
Reports the Ed-Fi Code from mapping for the Rubric List Item.
If not mapped, report null.
O
Grading & Standards> Score Groups & Rubric
letterGradeEarned
A final or interim (grading period) indicator of student performance for a learning standard as submitted by the instructor.
Determine if the posted score is an integer or not:
If the posted value is not an Integer, then report the posted score here.
If the posted value is an Integer, then report in the Numeric Grade Earned field below.
O
Grading & Standards> Score Groups & Rubrics> Score
numericGradeEarned
A final or interim (grading period) indicator of student performance for a learning standard as submitted by the instructor.
Determine if the posted score is an integer or not:
If the posted value is an Integer, then report the posted score here.
If the posted value is not an Integer, then report in Letter Grade Earned field above.
O
Grading & Standards> Score Groups & Rubrics> Score
learningStandardReference
The identifier for the specific learning standard (e.g., 111.15.3.1.A).
