MN v3.3 - Grading Periods

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 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 and a resync is completed.

DeleteWhen the Grading Period is removed and saved in Resource Preferences and a resync is completed.
DeleteWhen the Grading Period is removed from Resource Preferences.
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

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

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

This table describes scope year logic of this object.

Logic

Reports the grading periods in the configured year they are 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
Schools/Calendars/Schedule Structures/Term Schedules
Grading Period Detail

Identity Mapping Object Key

campusObjectType

Object Key Data Source

EdFiGradingPeriodedFiGradingPeriodID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table

Ed-Fi Action

Fields

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

Object Data Elements

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

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source 

GUI Path

Database Field
idThe unique identifier of the resource.


M

gradingPeriod
Descriptor
The name of the grading period.
  1. Report the code value from the Grading Period Name selected.
MEd-Fi > Configuration >
Resource Preferences >
Grading Periods > Grading Period Descriptor
edfigradingperiod.
name
periodSequenceThe sequence of the grading period.
  1. Report the period sequence for the Grading Period being reported.
  2. The sequence will be 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.
  3. 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 will report.
MEd-Fi > Configuration >
Resource Preferences >
Grading Periods > Grading Period Sequence
edfigradingperiod.
sequence
schoolReferenceProvide user information to lookup and link to an existing school record.
  1. Reports the natural key of the School resource to which the grading period is aligned.
M

schoolYearType
Reference
A reference to the related SchoolYearType resource.
  1. Reports the end year from the calendar the term is reported.
    1. Reports 'XXXX'
M

beginDateThe start date of the grading period.
  1. Report the start date from the Grading Period being reported.
MEd-Fi > Configuration >
Resource Preferences >
Grading Periods > Grading
Period Start Date
edfigradingperiod.
startDate
endDateThe end date of the grading period.
  1. Report the end date from the Grading Period being reported.
MEd-Fi > Configuration >
Resource Preferences >
Grading Periods > Grading
Period End Date
edfigradingperiod.
endDate
totalInstructional
Days
The total number of instructional days in the grading period.
  1. Count the number of instructional days on the Days tool that occur during the start and end date for the grading period. This field will update when the Instructional Day checkbox is checked/unchecked.
    • If there is more than 1 calendar or schedule structure, report the distinct number of instructional days from all calendars/schedule structures.
    • Instructional days will not send an update if changed after original post unless a resync is completed.
    • If all days are marked as non-instructional, the field will report 0.
MScheduling & Courses > Calendar Setup > Calendar Information >
Days

_etag

O


Type/Descriptor

Click here to expand...

Grading Period Descriptor

Code ValueDescriptionNamespaceShort Description
First Nine WeeksFirst Nine Weeksuri://ed-fi.org/GradingPeriodDescriptorFirst Nine Weeks
Second Nine WeeksSecond Nine Weeksuri://ed-fi.org/GradingPeriodDescriptorSecond Nine Weeks
Third Nine WeeksThird Nine Weeksuri://ed-fi.org/GradingPeriodDescriptorThird Nine Weeks
Fourth Nine WeeksFourth Nine Weeksuri://ed-fi.org/GradingPeriodDescriptorFourth Nine Weeks
First SemesterFirst Semesteruri://ed-fi.org/GradingPeriodDescriptorFirst Semester
Second SemesterSecond Semesteruri://ed-fi.org/GradingPeriodDescriptorSecond Semester
First TrimesterFirst Trimesteruri://ed-fi.org/GradingPeriodDescriptorFirst Trimester
Second TrimesterSecond Trimesteruri://ed-fi.org/GradingPeriodDescriptorSecond Trimester
Third TrimesterThird Trimesteruri://ed-fi.org/GradingPeriodDescriptorThird Trimester
First Six WeeksFirst Six Weeksuri://ed-fi.org/GradingPeriodDescriptorFirst Six Weeks
Second Six WeeksSecond Six Weeksuri://ed-fi.org/GradingPeriodDescriptorSecond Six Weeks
Third Six WeeksThird Six Weeksuri://ed-fi.org/GradingPeriodDescriptorThird Six Weeks
Fourth Six WeeksFourth Six Weeksuri://ed-fi.org/GradingPeriodDescriptorFourth Six Weeks
Fifth Six WeeksFifth Six Weeksuri://ed-fi.org/GradingPeriodDescriptorFifth Six Weeks
Sixth Six WeeksSixth Six Weeksuri://ed-fi.org/GradingPeriodDescriptorSixth Six Weeks
First Summer SessionFirst Summer Sessionuri://ed-fi.org/GradingPeriodDescriptorFirst Summer Session
Second Summer SessionSecond Summer Sessionuri://ed-fi.org/GradingPeriodDescriptorSecond Summer Session
Third Summer SessionThird Summer Sessionuri://ed-fi.org/GradingPeriodDescriptorThird Summer Session
Summer SemesterSummer Semesteruri://ed-fi.org/GradingPeriodDescriptorSummer Semester
End of YearEnd of Yearuri://ed-fi.org/GradingPeriodDescriptorEnd of Year

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 Grading Periods 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. Complete the Grading Tasks Grading Period Descriptor, Sequence, Start Date, and End Date field for each school. The filter option at the top of the section can be used to filter by school and/or grade level. The various filter fields determine which information displays. The Fill options can be used to fill the Grading Task, Grading Period Descriptor, Sequence, Start Date, and/or End Date fields.

     Any item not mapped will not report to Ed-Fi.
    Grading Period Descriptors
    Attribute Dictionary

    System Settings > Custom Data and Links > Core Attribute Dictionary > Grading Task > Ed-Fi Grade Type

    FieldDescription
    SchoolUsed to filter by school.
    Calendars
    Used to filter by calendar.
    Schedule Structures
    Used to filter by schedule structure
    Term Schedules
    Used to filter by term schedules.
    Grade LevelsUsed to filter by grade level.
    Grading TaskThe Grading Task that is being mapped. Only Grading Tasks that are mapped to a Grade Type Descriptor in the Grades Resource Preferences appear in the Grading Task droplist.
    Grading Period DescriptorThe name of the grading period.
    SequenceThe sequence of the grading period.
    Start DateThe start date of the grading period.
    End DateThe end date of the grading period.
    Fill EmptyThe selected option will create a new record for any school that does not have a record with the same Grading Task, Grading Period Descriptor & Sequence combination.
    Fill AllThe selected option will create a new record for any school that does not have a record with the same Grading Task, Grading Period Descriptor & Sequence combination AND will overwrite the Start Date and End Date for any existing record with the same Grading Task, Grading Period Descriptor & Sequence combination.

  2. Click Save.


Additional Information for Grading Periods

Grading Period Scenarios

Create a Grading Period record for each Grading Task that you want to send a grade to in Ed-Fi.

The Grading Period reports in the Sessions resource where the end date of the Grading Period overlaps that terms start and end dates.

Sessions Resource:


School reports a Quarter Grade at the end of each term:

Create four Grading Periods

Grading Task

Grading Period Descriptor

Start Date

End Date

Sequence

Sessions Reference

Quarter

First Nine Weeks

08/23/2017

10/20/2017

1

First Quarter

Quarter

Second Nine Weeks

10/23/2017

12/22/2017

2

Second Quarter

Quarter

Third Nine Weeks

01/03/2018

03/09/2018

3

Third Quarter

Quarter

Fourth Nine Weeks

03/12/2018

05/23/2018

4

Fourth Quarter


School reports a Semester Grade at the end of the Second and Fourth Quarters:

Grading Task

Grading Period Descriptor

Start Date

End Date

Sequence

Sessions Reference

Semester

First Semester

8/23/2017

12/22/2017

1

Second Quarter

Semester

Second Semester

01/03/2018

05/23/2018

2

Fourth Quarter