How can I see who a student has come into contact with?

You may wish to see who a student has come into contact with at school (in situations such as COVID exposure, for example). Using a bit of creative query building, this information can be easily retrieved using the following steps:

A Class Enrollment query tailored toward searching for Sheila Abbott's classes. Subtotaling has been removed for ease in the copying process.

  1. Run a Class Enrollment query, applying the criteria to the Student field of "is" {Last Name, First Name} of the student in question.
  2. Type in "Ctrl+Shift+C" to bring up the "Copy Results Data" tool. Learn more about copying query results here.
  3. Select Class, All Rows and Copy Display Value, and then click Copy Data to Clipboard.
  4. Begin a completely new Class Enrollment query and paste the value copied during step 3 into the Class field's criteria. Change the criteria operator to "is" and run the query.
  5. This is a list of all students who have classes with the original student.

From here, it's up to you to decide how to proceed with this data, such as exporting this data to a CSV file or beginning a Composer message to email the parents of all students in this list.

Other helpful articles: