To identify WPC 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 Enrolment, Evaluated Mark, Diploma Exam Mark, and Calculated First Pass 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.

• Passed Course . Course Code = Course Enrolment . Course Code
• Passed Course . School Year = Course Enrolment . Section . Section School Year

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.

• Passed Course . Course Code = Evaluated Mark . Evaluated Mark Course Code
• Passed Course . School Year = Evaluated Mark . Evaluated Mark School Year

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..

• Passed Course . Course Code = Diploma Exam Mark . Diploma Exam . Course Code (Diploma Exam)
• Passed Course . School Year = Diploma Exam Mark . Diploma Exam . School Year (Diploma Exam)

For each Calculated First Pass Official Mark, if the Official Mark includes a passing mark, the course code is identified as a course that the student passed in the achieved school year of the official mark.

• Passed Course . Course Code = Official Mark . Course Code
• Passed Course . School Year = Official Mark . Achieved School Year

Once all the passed courses have been identified, the calculator identifies a list of lower level courses for which the student may be eligible for WPC. This is done by iterating through the list of passed courses. For each course the student passed, the calculator identifies the course that is the typical progress into the course the student passed. This is done by finding Course Relationships that meet the following criteria:

• Course Code is the same as the Course Code of the course the student passed.
• Relationship Type (Course) is Typical Progression (TYP)

For each Course Relationship found, the Related Courses are added to a list of lower level courses.

• Lower Level Course . Course Relationships . Related Courses . Course Code
• Lower Level Course . School Year = Passed Course . School Year

As WPC awarding can be chained, if a Typical Progression relationship is found, then the lower level course for that course must also be considered. For example, if the student passed English 30-1, then the lower level courses would include English 20-1 (the typical progression into English 30-1) and English 10-1 (the typical progression into English 20-1). The school year for both lower level courses would be the same.

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

• Course Code is the same as the Course Code of the lower level course.
• Relationship Type (Course) is for a Regular Equivalency (REG) or WPC Equivalency (WPC).
• First School Year (Course Relationship) is the same as or earlier that the School Year in which the student passed the course.
• Last School Year (Course Relationship) (if provided) is the same as or later than the School Year in which the student passed the course.

For each Course Relationship found, each of the Related Courses is added to a list of potential WPC equivalent courses.

• Potential WPC Equivalent . WPC Course Code = Lower Level Course . Course Code
• Potential WPC Equivalent . School Year = Lower Level Course . School Year
• Potential WPC Equivalent . Equivalent Course Code = Course Relationship . Related Courses . Course Code

The resulting list is a list of potential WPC equivalent courses. In order to be considered a valid WPC equivalent course, the equivalent course must be applicable for each school year in which the student passed the course.

• The list of { Lower Level Course . School Years } for each { Lower Level Course . Course Code } should be the same as the list of { Potential WPC Equivalent . School Years } for each { Potential WPC Equivalent . Equivalent Course Code } that has a { Potential WPC Equivalent . WPC Course Code } that matches the { Lower Level Course . Course Code }.

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

• WPC Equivalent Course . WPC Course Code = Potential WPC Equivalent . WPC Course Code
• WPC Equivalent Course . Equivalent Course Code = Potential WPC Equivalent . Equivalent Course Code

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

Consider the following set of course enrolments:

Consider the following set of evaluated marks:

Consider the following set of diploma exam marks:

Consider the following set of calculated first pass official marks:

The list of passing courses would include:

Consider the following Course Relationships:

The following Lower Level Courses would be considered:

The list of potentially equivalent courses would include:

Validating the school years compares the list of school years for the lower level courses against the list of school years for the potentially equivalent courses:

Therefore, the validated list of WPC equivalent courses includes: