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).
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..
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.
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:
For each Course Relationship found, the Related Courses are added to a list of lower level courses.
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:
For each Course Relationship found, each of the Related Courses is added to a list of potential WPC equivalent courses.
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.
Each potentially equivalent course that passes this validation is then added to the final list of WPC equivalent courses:
When needed, the official mark calculator can then reference this list of equivalent courses.
Consider the following set of course enrolments:
|Course Code||School Year||Mark||Is Approved?|
Consider the following set of evaluated marks:
|Course Code||School Year||Evaluation Method||Mark||Is Approved?|
Consider the following set of diploma exam marks:
|Course Code||School Year||Mark|
Consider the following set of calculated first pass official marks:
|Course Code||School Year||Mark|
The list of passing courses would include:
|Course Code||School Year|
Consider the following Course Relationships:
|Course Code||Relationship Type||First School Year||Last School Year||Related Courses|
The following Lower Level Courses would be considered:
|Lower Level Course||School Year|
The list of potentially equivalent courses would include:
|Lower Level Course||School Year||Equivalent Course Code|
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:
|Lower Level Course||School Years||Potentially Equivalent Course||School Years|
|LLL1111||2017, 2018, 2019||EEE2222||2017, 2018, 2019|
|EEE3333||2017, 2018, 2019|
|WWW5555||2017, 2018, 2019|
|EEE8888||2017, 2018, 2019|
Therefore, the validated list of WPC equivalent courses includes:
|WPC Courses||Equivalent Course|