Grades (Nebraska v3.6)

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.

ActionTrigger
Post

When a grade is posted to a Grading Task that is mapped to an Ed-Fi Grade Type and marked as State Reported.

  • Standards does not report to Ed-Fi.
  • Does not report when the Course is marked as Inactive or State Excluded.
  • Does not send records when the School or Calendar Exclude check box is checked.
  • Checks to see the student has a Student Section Association in the Ed-Fi identity Mapping table before sending.
  • When the Student Section Association exits, continues with processing the record to Ed-Fi.
  • When the Student Section Association does not exist, the record goes 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.
  • Does not send when the student's enrollment is marked as No Show or State Exclude
Put

When a grade is updated on a Grading Task that is mapped to an Ed-Fi Grade Type.

DeleteWhen a grade is deleted from a Grading Task that is mapped to an Ed-Fi Grade Type.
DeleteWhen the Student School Association record is deleted for the school in which the grades are associated.
DeleteWhen any field that is part of the Natural Key is changed.

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

NoneWhen a resource is toggled to Off after data has sent, all sent data remains in the ODS but no new data will send.
DeleteWhen a resource is toggled to Off after data has sent and an action is performed that would trigger a delete, that data remains in the ODS until a resync is done.
ResyncWhen a record is in the Ed-Fi Identity Mapping table and not in the ODS, it is deleted from the Ed-Fi Identity Mapping table.
ResyncWhen a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it is deleted from the ODS.
ResyncWhen a mapping is changed in Resource Preferences, a resync needs 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.

ActionTrigger
Delete/Post

Natural Key change: When the Natural Key of the Grading Period Reference or Student Section Association changes, a delete/post occurs.

Delete/PostWhen the Grade Type Descriptor is changed or removed.

Scope Year Logic

This table describes scope year logic of this object.

Logic

Grades post to the scope year the course's calendar is aligned to.

  • Data only sends for the years that have valid configuration.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element LabelMapping Needed
Grading TasksGrade Type Descriptors

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table

Ed-Fi Action

Fields

gradingscore.scorePost/Put/DeleteThe primary table used for sending data for this resource
gradingTaskPost/Put/DeleteThe primary table used for sending data for this resource

Object Data Elements

This table describes data elements sent within the Grades resource.

Data Element LabelBusiness RequirementM, C or O

Data Source GUI Path

idThe unique identifier of the resource.M
gradeTypeDescriptorThe type of grade (e.g., Exam, Final, Grading Period, Progress Report).

Reports the Ed-Fi Code from mapping for the Grading Task.


When the grading task is not mapped, this does not report.

M

Grading & Standards> Grading Tasks


gradingTask

gradingPeriodReferenceA reference to the related GradingPeriod resource.

Reports the fields that are part of the Natural Key for the Grading Periods resource.
M
studentSectionAssociationReferenceA 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
diagnosticStatementA statement provided by the teacher that provides information in addition to the grade or assessment score.

This field is optional, does not report.
O
letterGradeEarnedA final or interim (grading period) indicator of student performance in a class as submitted by the instructor.

When a  Grading Task is mapped to an Ed-Fi code of "Final: Final" and the student is assigned a grade mapped to a grading task with Final Grade, reports the grade regardless of roster end date.


When no grade is mapped to final grade, do not report.


Note: Sends a final grade when a student drops from a section in the first term of a section that spans multiple terms and a grade has been assigned after the student has dropped.

CGrading & Standards> Score Groups & Rubrics> Score

gradingscore.score
numericGradeEarnedA final or interim (grading period) indicator of student performance in a class as submitted by the instructor.

When a Grading Task is mapped to an Ed-Fi code of "Final: Final" and the student is assigned a grade mapped to a grading task with Final Grade, reports the grade regardless of roster end date.


When no grade is mapped to final grade, do not report.


Note: Sends a final grade when a student drops from a section in the first term of a section that spans multiple terms and a grade has been assigned after the student has dropped.

CGrading & Standards> Score Groups & Rubrics> Score

gradingscore.score
performanceBaseConversionDescriptorThe performance base conversion assessed for the student.

This field is optional, does not report.
O

Type/Descriptor

Click here to expand...

Grade Type Descriptors

Ed-Fi Short DescriptionEd-Fi Description
ConductConduct
ExamExam
FinalFinal
Grading PeriodGrading Period
Mid-Term GradeMid-Term Grade
Progress ReportProgress Report
SemesterSemester