Grading Periods (Indiana v3.6)

This entity represents the time span for which grades are reported. Quarter, Semester, Final, etc. The Start and End dates must have a calendar event in the Calendar Dates resource before Grading Periods can be sent. The user must perform a day reset before filling out the Grading Periods tab. In Indiana, the Grading Periods resource represents the reporting of progress reports (such as report cards) for a student. It does not represent the reporting of the actual grading periods where credits are assigned to students for their courses. The reporting for this is done in the Sessions resource.

The following Grades resource preference configuration is required to set up the Grading Periods resource appropriately.

  • Grading Task = Semester Grade + Ed-Fi Code = Semester
  • Grading Task = Term Grade + Ed-Fi Code = Grading Period

Object Triggering Logic

This table describes the logic for triggering the syncing of this object.

ActionTrigger
Post

When a new Grading Period is created and saved in Resource Preferences and a resync is completed.

  • Do not send if the School is marked as Exclude.
  • Do not send if the Calendar is marked as Exclude.
  • Do not send if there are no days for that school.
Put

When the Grading Period Start or End Date is updated and saved, a resync is completed.

PutWhen the Instructional checkbox is checked or unchecked, the Total Instructional Days field updates with the correct number of instructional days.
PutWhen the Period Sequence is changed.
DeleteWhen the Grading Period is removed and saved in Resource Preferences and a resync is completed.
DeleteWhen the last day record is deleted from the days table.
Delete/PostWhen the Grading Period’s Grading Period Descriptor or Sequence is edited and saved in the Resource Preferences and a resync is completed.

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.
ResyncWhen doing a resync, look to make sure the Grading Task is still mapped in the Grades Resource Preferences prior to sending. 

Natural Key Changes, Cascading Updates, and Deletes Logic

ActionTrigger
Delete/Post

If the Natural Key changes: If the School Number/Ed-Fi School Number changes, a delete/post will occur with the cascading deletes from the School ID Change triggers.

Delete/PostIf the Grading Period Descriptor or Sequence changes and a resync is completed.
Delete/PostIf the natural key changes or the record is deleted, the Sessions Grading Periods reference will be updated.
Delete/PostIf the natural key of Grading Periods changes, all existing dependent data will be deleted or moved to the correct Grading Period. If a grade has not been posted yet and a Grading Period changes, a resync on the Grades resource will need to be completed.
Dependent ResourcesSessions Reference, Grades


Scope Year Logic

Logic

Reports the grading periods in the configured year to which they are aligned.

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

Resource Preferences

Data Element LabelMapping Needed
Schools/Calendars/Schedule Structures/Term SchedulesGrading Period Detail

Identity Mapping Object Key

campusObjectType

Object Key Data Source

EdFiGradingPeriodedFiGradingPeriodID

Event Queue Detail

Campus Table

Ed-Fi Action

Fields

edfiGradingPeriodsPost/Put/DeleteThe primary table used for sending data for this resource.

Error Log

ErrorPossible Causes/Resolutions
Student Over, 57744 does not have a Student Section Association record for the course 1014 ACP English 9. This record must exist before Grades can be sent.

Causes: Student has a grade for a course section that attempted to send during a resync of gradingPeriods. Student did not have a studentSectionAssociation on record.


Resolution: Resync studentSectionAssociation for this student to send studentSectionAssociation and grade to Ed-Fi.

Object Data Elements

This table describes data elements sent within the Grading Periods resource.

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Location

idThe unique identifier of the resource.


M
gradingPeriodDescriptorThe name of the grading period.

Reports the code value from the Grading Period Name selected.


MSystem Administration > Ed-Fi > Configuration> Resource Preferences > Grading Periods > Grading Period Descriptor

edfigradingperiod.name
periodSequenceThe sequence of the grading period.Reports the period sequence for the Grading Period being reported.
  • The sequence is auto-generated based on an assigned value. This value can be overwritten if necessary.
  • The sequence can be changed in the individual record as long it is unique to the Grading Period Descriptor and School combination.
  • Two Grading Periods in the same school can have the same sequence as long as the Grading Period. Descriptor is not the same.
  • Two Grading Periods in the same school can have the same Grading Period Descriptor as long as the Sequence is not the same.
  • Two Grading Periods with the same Grading Period Descriptor can have the same sequence as long as they are assigned to different schools.

The sequence is determined based on the name of the 'number' in the Grading Period Descriptor up to 6. Example 'First Semester' will have a sequence of 1, 'First Nine Weeks' will have a sequence of 1. If the Grading Period Descriptor number is over 6 or cannot be determined, a default value of 1 reports.


MSystem Administration > Ed-Fi > Configuration > Resource Preferences > Grading Periods > Grading Period Sequence

edfigradingperiod.sequence
schoolReferenceProvides user information to lookup and link to an existing school record.

Reports the natural key of the School resource to which the grading period is aligned.

M
schoolYearTypeReferenceA reference to the related SchoolYearType resource.Reports the end year from the calendar the term is reported
  • Reports 'XXXX'

M
beginDateThe start date of the grading period.

Reports the start date from the Grading Period being reported.

  • If there is more than 1 grading period with the same School, Descriptor and Sequence, reports the earliest start date.
MSystem Administration > Ed-Fi > Configuration > Resource Preferences > Grading Periods > Grading Period Start Date

edfigradingperiod.
startDate
endDateThe end date of the grading period.

Reports the end date from the Grading Period being reported.

  • If there is more than 1 grading period with the same School, Descriptor and Sequence, reports the latest end date.
MSystem Administration > Ed-Fi > Configuration > Resource Preferences > Grading Periods > Grading Period End Date

edfigradingperiod.
endDate
descriptorThe name of the grading period.Report the code value from the Grading Period Descriptor selected.MSystem Administration > Ed-Fi > Ed-Fi Configuration > Resource Preferences > Grading Periods > Grading Period Descriptor

edfigradingperiod.
name
totalInstructional
Days
The total number of instructional days in the grading period.Counts the number of instructional days on the Days tab that occur during the start and end date for the grading period.
  • If there is more than 1 calendar or schedule structure, reports the distinct number of instructional days from all calendars/schedule structures that have that specific grading period (same school, descriptor, and seq).
MSystem Administration
> Calendar > Calendar > Days
_etag

O


Type/Descriptor

Click here to expand...

Grading Period Descriptor

Code ValueDescriptionNamespaceShort Description
First Nine WeeksFirst Nine Weekshttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlFirst Nine Weeks
Second Nine WeeksSecond Nine Weekshttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlSecond Nine Weeks
Third Nine WeeksThird Nine Weekshttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlThird Nine Weeks
Fourth Nine WeeksFourth Nine Weekshttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlFourth Nine Weeks
First SemesterFirst Semesterhttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlFirst Semester
Second SemesterSecond Semesterhttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlSecond Semester
First TrimesterFirst Trimesterhttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlFirst Trimester
Second TrimesterSecond Trimesterhttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlSecond Trimester
Third TrimesterThird Trimesterhttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlThird Trimester
First Six WeeksFirst Six Weekshttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlFirst Six Weeks
Second Six WeeksSecond Six Weekshttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlSecond Six Weeks
Third Six WeeksThird Six Weekshttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlThird Six Weeks
Fourth Six WeeksFourth Six Weekshttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlFourth Six Weeks
Fifth Six WeeksFifth Six Weekshttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlFifth Six Weeks
Sixth Six WeeksSixth Six Weekshttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlSixth Six Weeks
First Summer SessionFirst Summer Sessionhttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlFirst Summer Session
Second Summer SessionSecond Summer Sessionhttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlSecond Summer Session
Third Summer SessionThird Summer Sessionhttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlThird Summer Session
Summer SemesterSummer Semesterhttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlSummer Semester
End of YearEnd of Yearhttp://doe.in.gov/Descriptor/GradingPeriodDescriptor.xmlEnd of Year