Purpose
This document provides a step-by-step guide to identify students who have not taken specific courses.
Procedure
Objective:
- Identify students who have not taken Course number "Course A" or "Course B".
- List the 10th-grade students who are left after excluding those who have taken the specified courses.
Steps:
- Step 1: Skip the students who have taken Course number Course A or Course B.
SKIP STU HIS IF HIS.CN = 'CourseA' OR HIS.CN = 'CourseB'
- Step 2: List the 10th-grade students who are left
LIST STU ID NM GR IF GR = 10
- Step 1: Skip the students who have taken Course number Course A or Course B.
Expected Outcome:
- A list of 10th-grade students who have not taken Course number "Course A" or "Course B".
Notes
- Ensure the students' Transcripts are up-to-date before running the queries.
- Verify the course numbers and grade levels as per the latest curriculum.