To list students not enrolled in a specific course, create two queries. The first query includes all students. The second query includes only students enrolled in the course.
  • Create a query of all students
    1. Create a new Student, dynamic query
       
    2. To include all students regardless of school, grade, or status, do not select an filters on the Criteria tab. To narrow the students included, you can select filters. For example:
      1. Expand the Student category and the Bio 1 subcategory
         
      2. Select Current school and set the operator to equals
         
      3. Select Current grade and set the operator to equals
         
      4. Select Current status and set the operator to equals
         

       
    3. Select the Output tab to select the fields in the results. For example, expand the Student category and the Bio 1 subcategory, and select Full name.
       
    4. Select the Sort tab to define the order of the results. For example, expand the Student category and the Bio 1 subcategory, and select Last Name (Asc).
       
    5. Select the Results tab
       
    6. Select File, Save from the menu bar
       
    7. Name and save the query
       
    8. Select File, Close from the menu bar
       
  • Create a query of students enrolled in the course
    1. Create a new Student, dynamic query
       
    2. Expand the Schedule category, and select Academic year. Set the operator to equals.
       
    3. Expand the Course subcategory, and select Course ID. Set the operator to equals.
       
    4. Select the Output tab to select the fields in the results. For example, expand the Student category and the Bio 1 subcategory, and select Full name.
       
    5. Select the Sort tab to define the order of the results. For example, expand the Student category and the Bio 1 subcategory, and select Last Name (Asc).
       
    6. Select the Results tab
       
    7. Select File, Save from the menu bar
       
    8. Name and save the query
       
    9. Select File, Close from the menu bar
       
  • Merge the queries
    1. Select File, Merge from the program shell
       
    2. On the Merge Queries screen, in the Query 1 field, search for and select the query of all students created above
       
    3. In the Query 2 field, search for and select the query of students enrolled in the course created above
       
    4. Mark Select records included in Query 1, but exclude records in both queries
       
    5. Click Merge Now
       
    6. On the New Student Query screen, on the Output tab, select the fields to include in the results. For example, expand the Student category and the Bio 1 subcategory, and select Full name.
       
    7. Select the Sort tab to define the order of the results. For example, expand the Student category and the Bio 1 subcategory, and select Last Name (Asc).
       
    8. Select File, Save from the menu bar
       
    9. Note the Description box includes the names of the queries and the operator selected, such as SUB. You can edit this description.

      Description box
       
    10. Name and save the query.
       
    11. A message appears letting you know this is a static query so results will not be updated to reflect new or deleted records when the query is used in the future
    12. Click OK
       
    13. The Merge Queries processing screen appears
       
    14. When processing is complete, the results screen appears listing the number of records that met the specified criteria
       
    15. Click OK
       
    16. Select the Results tab
       
    17. The Issuing Query screen appears until processing is complete