Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Contents
Table of Contents |
---|
Sample Course Transcript Mapping
View file
Image Added
- Student → Student.FirstName and Student.LastName
- Street Address → StudentEducationOrganizationAssociationAddress.StreetNumberName
- City/State/ZIP → StudentEducationOrganizationAssociationAddress.City, StudentEducationOrganizationAssociationAddress.StateAbbreviationDescriptor, and StudentEducationOrganizationAssociationAddress.PostalCode
- Phone → StudentEducationOrganizationAssociationTelephoneNumber.TelephoneNumber
- Date of Birth → Student.BirthData.BirthDate
- Place of Birth → Student.BirthData.BirthCity
- Gender → StudentEducationOrganizationAssociation.SexDescriptor
- Credits Earned →
- Weighted GPA →
- Unweighted GPA →
- School Year →
- Semester →
- Course →
- Grade →
- Credits →
- GPA →
- Cumulative GPA →
Student Transcript Use Cases
Capturing Historical Records for Transfer Students
Often, when students transfer into a new school and/or district, they will have a history of completed courses from past grading periods and school years that need to be documented in the new district's SIS for earned credit. 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 ODS. Therefore the required CourseCode and EducationOrganization references may be missing.
In this case, there are two recommended solutions:
- If credit is being given for a course taken in a previous school year, an equivalent course may be found in the current ODS and the Course Transcript 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.
- Alternatively, the concept of "potentially logical" has been added to the model to denote when a reference may not be valid. In this instance, a CourseCode that does not necessarily exist in the Course records for the new ODS may be used to match the CourseCode on the student's transcript.
Ticket reference:
Jira Legacy server Ed-Fi Issue Tracker columnIds issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId e04b01cb-fd08-30cd-a7d6-c8f664ef7691 key DATASTD-1559
Capturing Course Transcript Data for a Course with Multiple Parts
Students who take multiple parts of the same course within the same term are unable to keep multiple transcript records because the data submissions would being overridden. 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").
A long-term solution to this problem would be to pull in a Course's NumberOfParts to be part of the identity for Course. This would allow a course with multiple parts to record credits per part, even when those course parts fall within the same Session. This would be a breaking change to the model and so is not expected in the next Data Standard release.
In the interim, proposed workarounds for this issue are:
- When the issue is an online course that has a single "Year Round" Session, create more granular Session records that can "roll up" to the Year Round StudentAcademicRecord. In this instance, cumulative credits would be added to the Year Round StudentAcademicRecord and credits for individual course parts would be spread across Semesters, Grading Periods, Marking Periods, etc..
- Alternatively, if a student is truly enrolled in multiple parts of the same course at the same time (i.e., in the same more granular Session), the CourseTranscript could be used to only reference the credit-bearing course (i.e. the CourseCode for the LEA) for which the student received credits, and not the parts by which that course was satisfied. Those other parts might be captured elsewhere in the model as Sections.
Ticket references:
Jira Legacy server Ed-Fi Issue Tracker columnIds issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId e04b01cb-fd08-30cd-a7d6-c8f664ef7691 key DATASTD-1073 Jira Legacy server Ed-Fi Issue Tracker columnIds issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId e04b01cb-fd08-30cd-a7d6-c8f664ef7691 key ODS-4612 Jira Legacy server Ed-Fi Issue Tracker columnIds issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId e04b01cb-fd08-30cd-a7d6-c8f664ef7691 key DATASTD-1442 Jira Legacy server Ed-Fi Issue Tracker columnIds issuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId e04b01cb-fd08-30cd-a7d6-c8f664ef7691 key DATASTD-1555