Wisconsin Ed-Fi Data v3.1 - Grades

Tool Search: Ed-Fi

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:

  • Do not send records if the Ed-Fi Configuration Profile = Choice + Opt in.
  • Do not send records if the Ed-Fi Configuration Profile = Choice ONLY.
  • Do not send records if the Calendar is marked Summer School.
  • Do not report if the Course is marked as Inactive or State Excluded.
  • Report only report from Grading Tasks marked as State Reported and the Exclude from Ed-Fi checkbox is unmarked with an Ed-Fi Grade Type = Final.

    * Note:  Do not report if the Exclude from Ed-Fi is checked on the Course Grading Task Detail for the course (Scheduling > Courses > Course > Grading Tasks).

  • Do not send records is the student's enrollment is marked as No Show, State Excluded, or WISE Exclude.
  • Only report if the student has an enrollment in State Grade level 9-12.
  • Report only if the State Enrollment Type is Primary or Coursework Only on the student's enrollment.
PutWhen a grade is updated on a Grading Task that is mapped to an Ed-Fi Grade Type.
PutWhen a student CTE Program Participation record is created or deleted for a CTE Program in the same cluster as the Course the grade is for.
PutWhen a Student CTE Program Participation record in the same cluster as the course for the grade is updated and status is added, changed, or removed.
DeleteWhen a grade 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.
DeleteWhen the Course is marked Exclude from State Reporting or the Active box is unchecked.
DeleteWhen the No Show or State Exclude or WISE Exclude check boxes are checked on the Student's enrollment.
DeleteWhen the State Enrollment Type is changed on the student's enrollment.


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.

Data Element LabelBusiness RequirementBusiness RulesM, C or O

Data Source GUI Path

Database Field
idThe unique identifier of the resource.


M

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



gradingPeriodReferenceA reference to the related GradingPeriod resource
  1. 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.
  1. Reports the fields that are part of the Natural Key for the Student Section Association resource. If the student has multiple enrollments in the same class, report the id for the most recent studentSectionAssociations resource.
M

diagnosticStatementA statement provided by the teacher that provides information in addition to the grade or assessment score.
  1. 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.
  1. 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.
OGrading & Standards> Score Groups & Rubrics> Scoregradingscore.score
numericGradeEarnedA final or interim (grading period) indicator of student performance in a class as submitted by the instructor.
  1. Determine if the posted score is an integer or not:
    • If the posted value is an Integer, then report the posted score.
    • If the posted value is not an Integer, then report in Letter Grade Earned field above.
OGrading & Standards> Score Groups & Rubrics> Scoregradingscore.score
performanceBaseConversionDescriptorPass/ Fail/ Incomeplete Indicator is expected to be submitted  for 'CTE' courses and all courses associated to 'CCR'.
  1. Report the Ed-Fi value mapped to the grade given.
  2. If there is no Ed-Fi value mapped, do not report a record.
M Grading & Standards > Score Groups & Rubrics > (Score Group) > Ed-Fi Grade Type

certificatedProgramStatusDescriptor (wi_gradeExtension)

This status is an indication of student's progress towards earning a 'certificate' within the 'certified Career Education Programs (Program Type)}.

This field is required only when the student is participating in a 'certifiedCareerEducatonProgram' that is associated to a course.
  1. If the course the grade is being reported for has a Cluster/ Career Program Pathway entered
  2. And the course  has a Certified Learning Method entered.
  3. And the student has a CTE Program record for the same Cluster,
  4. Then report the Ed-Fi Value for the Status from the student's CTE record.
    • If the status = 'a', Student met the requirements, AND there are grades posted for multiple grading periods within the database config year for the same Cluster/ CTE program, report 'a' on only the last record by date of the grading period.
      1. On previous records, report 'b'.
  5. If the course does not qualify or if there is no matching CTE record, report blank.
  6. If a student is in two different courses, then report the status for each.
CStudent Information > Academic Planning > Career Tech Program > Status


Type/Descriptor

Click here to expand...

Grade Type Descriptors

Code ValueDescriptionShort Description
ConductConductConduct
FinalFinalFinal
SemesterSemesterSemester
ExamExamExam
Grading PeriodGrading PeriodGrading Period
Mid-Term GradeMid-Term GradeMid-Term Grade
Progress ReportProgress ReportProgress Report

Performance Base

CodeShort DescriptionDescription
PPassPassing grade earned for coursework based on local standards and policy.
FFailFailing grade earned for coursework based on local standards and policy.
NNot CompletedNo grade earned for a course in which a grade may be earned. The student is ineligible to receive a grade earned or course credits.
NGNot GradedCoursework for which no grade(including pass/fail) may be earned.

Certified Program Status

CodeShort DescriptionDescription
ACompleted with CertificateStudent met the requirements of the certificated program and was or is to be awarded a certificate
BContinuingStudent is continuing in the certificated program
CExitedStudent has left the certificated program before completion
DCompleted without CerificateStudent completed program but did not meet the requirements for the certificate