This query report will show the students that have completed the pre-requisite courses for the course they are requesting.
When executing the query:
-
Course Title = Enter the Course Title of the course the student is requesting.
-
School Year = School year requested (ie. next school year 2019-2020)
-
School Profile Sequence = School Name
-
Transcript Course Title = Pre-requisite Course ID numbers (up to 3 courses)
The query report will list the student, the requested course, the completed pre-requisite course(s), and the year the pre-requisite course was taken.
|
Student ID |
First Name |
Last Name |
Requested Course Title |
Requested Course Name |
AcademicYear |
Pre Requisite Course Title |
Pre Requisite Course Name |
|
6508 |
(student1) |
(student1) |
503 |
Entrepreneurship H |
2016-2017 |
501 |
Management CP1 |
|
6508 |
(student1) |
(student1) |
503 |
Entrepreneurship H |
2017-2018 |
500 |
Marketing I CP1 |
|
6508 |
(student1) |
(student1) |
503 |
Entrepreneurship H |
2018-2019 |
505 |
Accounting I CP1 |
|
6658 |
(student2) |
(student2) |
503 |
Entrepreneurship H |
2016-2017 |
500 |
Marketing I CP1 |
|
6658 |
(student2) |
(student2) |
503 |
Entrepreneurship H |
2017-2018 |
505 |
Accounting I CP1 |
|
6658 |
(student2) |
(student2) |
503 |
Entrepreneurship H |
2018-2019 |
501 |
Management CP1 |
