Purpose

This document provides a step-by-step guide to identify students who have not taken specific courses.

Procedure

  1. 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.
  2. 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
  3. 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.