Contents

Current Grade Capture

It is common for systems to want to represent and exchange information on current grades, grades for a grading period that is not yet completed. In the Ed-Fi data model, this is accomplished as follows:

  • Write the “current grade” to the Grade entity for the appropriate GradingPeriod
  • Set the GradeType to “Grading Period” or other appropriate descriptor that represents the current grading period
  • Set the CurrentGradeIndicator flag = True
  • Set the value CurrentGradeAsOfDate, providing "as of" date as marked in the source system, or lacking that, the date the current grade was sourced

This grade should be managed as follows:

  • Systems should overwrite prior current grades as new ones are published (the data model is not designed to do longitudinal capture; that can be accomplished through a separate process).  The CurrentGradeAsOfDate should be updated as appropriate.
  • When the final grade is published for the grading period, the value for CurrentGradeIndicator should be set to False and CurrentGradeAsOfDate set to null / deleted.

Note that "CurrentGrade" terminology is used instead of "InProgress" to avoid confusion with a scheduled "Progress Report."

Standards-Based Grading

The model has the ability to align grades with learning standards.  The LearningStandardGrade common was added as an optional collection in order to allow a collection of learning standards to be referenced on a Grade. The common includes LetterGradeEarned, NumericGradeEarned, DiagnosticStatement, PerformanceBaseConversion. The LetterGradeEarned and NumericGradeEarned allow for different ways instructors use grade values. The model can support both one-time standards (i.e. student learns how to count to 10) and standards that are graded multiple times in a school year.

Sample Course Transcript Mapping

The following is a sample course transcript showing mappings to the Ed-Fi data model. Each circled number corresponds to an element in the Ed-Fi Data Standard; elements are listed below by number.


#DescriptionEd-Fi EntityEd-Fi ElementCondition(s)
1StudentStudent

FirstName

LastSurname


2Street AddressStudentEducationOrganizationAssociation.AddressStreetNumberNameAddressType = [SIS Default]
3City/State/ZIPStudentEducationOrganizationAssociation.Address

City

StateAbbreviationDescriptor

PostalCode

AddressType = [SIS Default]
4PhoneStudentEducationOrganizationAssociation.TelephoneTelephoneNumberTelephoneNumberType = [SIS Default]
5Date of BirthStudent.BirthDataBirthDate
6Place of BirthStudent.BirthDataBirthCity
7GenderStudentEducationOrganizationAssociationSexDescriptor
8Credits EarnedStudentAcademicRecord.CumulativeEarnedCreditsCreditsStudentAcademicRecord.SchoolYear = [Most Recent School Year]
9Weighted GPAStudentAcademicRecord.GradePointAverageGradePointAverageValue

StudentAcademicRecord.SchoolYear = [Most Recent School Year]

GradePointAverageTypeDescriptor = 'Weighted'

IsCumulative = TRUE

10Unweighted GPAStudentAcademicRecord.GradePointAverageGradePointAverageValue

StudentAcademicRecord.SchoolYear = [Most Recent School Year]

GradePointAverageTypeDescriptor = 'Unweighted'

IsCumulative = TRUE

11School YearStudentAcademicRecordSchoolYear
12SemesterStudentAcademicRecordTermDescriptor
13CodeCourseTranscript.CourseReferenceCourseCode

CourseTranscript.StudentAcademicRecordReference → StudentAcademicRecord.SchoolYear = '2019 - 2020'

CourseTranscript.StudentAcademicRecordReference → StudentAcademicRecord.TermDescriptor = 'Fall Semester'

14CourseCourseTranscript.CourseReference

CourseTitle

CourseTranscript.StudentAcademicRecordReference → StudentAcademicRecord.SchoolYear = '2019 - 2020'

CourseTranscript.StudentAcademicRecordReference → StudentAcademicRecord.TermDescriptor = 'Fall Semester'

15GradeCourseTranscriptFinalLetterGrade

StudentAcademicRecordReference → StudentAcademicRecord.SchoolYear = '2019 - 2020'

StudentAcademicRecordReference → StudentAcademicRecord.TermDescriptor = 'Fall Semester'

16

Credits

CourseTranscript.EarnedCreditsCredits

CourseTranscript.StudentAcademicRecordReference → StudentAcademicRecord.SchoolYear = '2019 - 2020'

CourseTranscript.StudentAcademicRecordReference → StudentAcademicRecord.TermDescriptor = 'Fall Semester'

17GPAStudentAcademicRecord.GradePointAverageGradePointAverageValue

StudentAcademicRecord.SchoolYear = '2019 - 2020'

StudentAcademicRecord.TermDescriptor = 'Fall Semester'

IsCumulative = FALSE

18Cumulative GPAStudentAcademicRecord.GradePointAverageGradePointAverageValue

StudentAcademicRecord.SchoolYear = '2019 - 2020'

StudentAcademicRecord.TermDescriptor = 'Fall Semester'

IsCumulative = TRUE



Student Transcript Use Cases

Historical Records for Transfer Students

When students transfer into a new school district, they will have a history of completed courses from past school years that needs to be documented in the new district's SIS, in order to document graduation requirements, provide for transcripts for postsecondary school applications, and other reasons.

A common issue that arises when pulling this data into the ODS is the course records are associated with schools and districts that are not present in the new current data store. Therefore the required CourseCode and EducationOrganization references may be missing.

In this case, there are two recommended solutions:

  1. If credit is being given for a course taken in a previous school year, an equivalent course may be found in the current data context. In this case, the CourseTranscript record should include the equivalent CourseCode in the Course reference. The new district or school applying the credit would then become the EducationOrganization reference as it is the entity accepting those credits towards the student's transcript.
  2. Alternatively, the CourseCode can be set to not resolve. Ed-Fi has introduced as of Data Standard 3.2 the notion that certain references may be  "potentially logical" only – i.e., that the entity referred to may not exist in the current context and may only be a "logical" reference. This status applies to CourseTranscript.CourseCode

Users of the Ed-Fi ODS can set this entity to not resolve. Please consult the ODS documentation for details.

Ticket reference:

Course Transcript Data for a Course with Multiple Parts

The common element PartialCourseTranscriptAwards was included with the v3.3-b release on CourseTranscript as an optional array. This allows Students who take multiple parts of the same course within the same term to track multiple grades and credits awarded within the same session. This is a common use case for online schools that enroll students in multiple parts of the same course. These records will utilize the same CourseCode and TermType (e.g., "Year Round").