MN v3.3 - Grades

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:

  • Standards do not report to Ed-Fi.
  • Do not report if the Course is marked as Inactive.
  • 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.
  • Only report a record if the Grading Task is marked State Reported and Final.
Put

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

DeleteWhen a score is deleted from a Grading Task that is mapped to an Ed-Fi Grade Type.
DeleteWhen Grade Type Descriptor is no longer mapped and a resync is performed.


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

NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
DeleteIf 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.
ResyncIf 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.
ResyncIf 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.
ResyncIf a mapping is changed in Resource Preferences, 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.

ActionTrigger
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/PostIf 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 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. Required data elements are listed in bold.

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Location

idThe unique identifier of the resource.


M
gradeTypeDescriptorThe type of grade (e.g., Exam, Final, Grading Period, Progress Report).

Always report 'FG' (Final Grade).

  • A grading task that is marked as 'final' and 'state reported' must exist on the course.
  • The grading task is mapped to Ed-Fi grade type descriptor 'FG' .
M


gradingPeriodReferenceA reference to the related Grading Period resource.

Reports the fields that are part of the Natural Key for the Grading Periods resource.

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
letterGradeEarnedA final or interim (grading period) indicator of student performance in a class as submitted by the instructor.
  1. Report the value from the state score associated to the score group of the grading task marked as 'Final' and 'State Reported' and mapped to Ed-Fi grade type descriptor 'FG'. 
  2. If the grading score is posted to a transcript record, report from TranscriptCourse.score.
  3. Do not report letterGradeEarned if the Course field 'Section Enrollment Type' = DP: PSEO Direct Pay.
CGrading and Standards > Grading Setup > Score Group and Rubric Setup > Score > State Score Value

gradingscore.score
OR
TranscriptCourse.score
academicSubject
Descriptor
This descriptor holds the description of the content or subject area (e.g., arts, mathematics, reading, stenography, or a foreign language).Report the numeric code value of the SCED Subject Area associated with the transcript ID of the transcript record   
  • If the value is not numeric or no value exists, do not report

CStudent Information > General > Transcript > Transcript Record > SCED Subject Area

TranscriptCourse.
scedSubjectArea
collegeCredit
Earned
College credit earned.

Report the value from the posted transcript record when the grading task posted to the transcript has a grading task code of 'COLLEGECREDIT'.


Otherwise, do not report.


CStudent Information > General > Transcript > Transcript Record > Transcript Credit Information > Credits Earned


TranscriptCredit.creditsEarned
collegeGradeEarnedCollege grade earned.

Report the value from the posted transcript record when the grading task posted to the transcript has a grading task code of 'COLLEGECREDIT'.


Otherwise, do not report.

CStudent Information > General > Transcript > Transcript Record > Scoring Information > Score

TranscriptCourse.score
localCreditEarnedDistrict credit earned.

If the credit is posted to a Transcript record, update to report the value from 'Credits Earned'

  • If no value exists, do not report.
CStudent Information > General > Transcript > Transcript Record > Transcript Credit Information > Credits Earned

TranscriptCredit.creditsEarned
numericGrade
Earned
A final or interim (grading period) indicator of student performance in a class as submitted by the instructor.Does not report.

Resource Preferences Continued

The Ed-Fi Configuration tool is used to establish Ed-Fi data resources.

The following describes how to set the resource preferences for the Grades resource. If the Configure or Edit buttons do not display, then the resource does not need to be mapped and the toggle button can be used to turn the resource on or off.

 If a mapping is changed, a resync must be performed on the resource in order for the new mappings to send correctly.
  1. Select the appropriate Ed-Fi Code for the Academic Subject Descriptors. 

     Any item not mapped will not report to Ed-Fi.
    Course SCED Subject Area
    Attribute DictionarySystem Settings > Custom Data and Links > Core Attribute Dictionary > Course > SCED Subject Area
    UI LocationStudent Information > General > Transcript > transcript record > SCED Subject Area


  2. Select the appropriate Ed-Fi Code for the Grading Type Descriptors. 

    Grading Task
    Attribute DictionarySystem Settings > Custom Data and Links > Core Attribute Dictionary > Grading Task


  3. Click Save.