Identifying Regular Course Equivalencies

Throughout the Official Mark Calculator, courses that are deemed equivalent to other courses are used in various contexts. To ensure the right equivalencies are considered, the calculator first identifies the equivalent courses that may need to be considered.

To identify Regular Equivalencies that should be considered, the Official Mark Calculator first identifies a list of courses the student has passed (along with the school years in which they passed the course). This list of passed courses is built by iterating through the Course Enrolments, Evaluated Marks, and Diploma Exam Marks for the student.

For each Course Enrolment, if the Course Enrolment includes an approved passing mark, the course code is identified as a course that the student passed in the school year of the associated section.

For each Evaluated Mark, if the Evaluated Mark includes an approved passing mark, the course code is identified as a course that the student passed in the school year of the evaluation.

For each Diploma Exam Mark, if the Diploma Exam Mark includes a passing mark, the course code is identified as a course that the student passed in the school year when they wrote the exam..

Once all the passed courses have been identified, the calculator identifies a list of courses that are deemed equivalent to the passed courses. This is done by iterating through the list of passed courses. For each school year in which the student passed a course, the calculator identifies the courses that are deemed equivalent to the course the student passed. This is done by finding Course Relationshipss that meet the following criteria:

Based on the Course Relationship found, a list of potentially equivalent courses is created by adding each of the Related Courses is the Course Relationship to the list of potentially equivalent courses.

  • Potential Equivalent . Passed Course Code = Passed Course . Course Code
  • Potential Equivalent . School Year = Passed Course . School Year
  • Potential Equivalent . Equivalent Course Code = Course Relationships . Related Courses . Course Code

By matching the list of { Potential Equivalent . Passed Course Code } against the list of { Passed Course . Course Code }, the potentially equivalent course will be considered a valid equivalent course if the list of { Passed Course . School Years } for the course code is the same as the list of { Potential Equivalent . School Years } for the same course code.

Each potentially equivalent course that passes this validation is then added to the final list of equivalent courses:

  • Equivalent Course . Passed Course Code = Potential Equivalent . Passed Course Code
  • Equivalent Course . Equivalent Course Code = Potential Equivalent . Equivalent Course Code

When needed, the official mark calculator can then reference this list of equivalent courses.

For Example

Consider the following set of course enrolments:

Course Code School Year Mark Is Approved?
ABC1111 2020 80% Yes
ABC1111 2021 85% No

and the following set of evaluated marks:

Course Code School Year Mark Is Approved?
ABC1111 2018 55% Yes
ABC1111 2019 60% Yes

The list of passing courses would include:

Course Code School Year
ABC1111 2018
ABC1111 2019
ABC1111 2020

Considering the following course relationships for ABC1111:

Course Code Relationship Type First School Year Last School Year Related Courses
ABC1111 Regular 1905 ABC2222, ABC3333
ABC1111 Typical Progression 1905 ABC4444
ABC1111 Regular 1905 2019 ABC5555
ABC1111 Regular 2019 2019 ABC6666
ABC1111 Regular 2019 ABC7777
ABC1111 Regular 2017 2021 ABC8888

The list of potentially equivalent courses would include:

Passed Course Code School Year Equivalent Course Code
ABC1111 2018 ABC2222
ABC1111 2018 ABC3333
ABC1111 2018 ABC5555
ABC1111 2018 ABC8888
ABC1111 2019 ABC2222
ABC1111 2019 ABC3333
ABC1111 2019 ABC5555
ABC1111 2019 ABC6666
ABC1111 2019 ABC7777
ABC1111 2019 ABC8888
ABC1111 2020 ABC2222
ABC1111 2020 ABC3333
ABC1111 2020 ABC7777
ABC1111 2020 ABC8888

When comparing the school years for the passed courses against the list of school years for the potentially equivalent courses:

Passed Courses School Years Potentially Equivalent Course School Years
ABC1111 2018, 2019, 2020 ABC2222 2018, 2019, 2020
ABC3333 2018, 2019, 2020
ABC5555 2018, 2019
ABC6666 2019
ABC7777 2019, 2020
ABC8888 2018, 2019, 2020

Therefore, the validated list of equivalent courses includes:

Passed Courses Equivalent Course
ABC1111 ABC2222
ABC1111 ABC3333
ABC1111 ABC8888