What is Query?
Query is a report that allows you to identify and compare populations of students matching specific criteria across multiple data sources. It is designed for cases in which you have a set of criteria, and you need to know what students meet that criteria.
What are examples of ways you can use Query?
Identifying students for ELL services.
Middle school and high school placement.
Qualifications for programs of extra curricular activity.
❗ Data for Query is synced at 8:00pm Monday - Thursday.
Generating a Query Report
Step 1: Enter the Analytics module.
Step 2: Select Reports.
Step 3: Select the Query tile.
Step 4: Give your query a title.
Step 5: Select your population by defining your cohort. Once at least one value is selected in a single Population category, you'll be able to toggle on "Exclude" for that category, excluding anything within the values you set for the category.
Step 6: Determine the Criteria. This can be single criterion or multiple criteria.
➡️ Adding Multiple Criteria
If you choose to add more than one criterion, you'll want to choose between And and Or.
And - students have to meet both (all) criteria set.
Or - students have to meet at least one of the criteria.
As you adjust your criteria, it will calculate the number of students that have populated in the query in the upper-right corner
Step 7 (optional): Add a Matrix Value. By toggling on the matrix value, a point value, chosen by you, will be awarded to the students who meet these specific criteria.
Step 8: When you have completed the steps above, select Run Report.
How often is data synced to Query? Sunday-Thursday at 8:00 pm CST
Is there a limit to the number of classes that appear in the results of a query? Yes - 10 classes
Is there a limit to the number of students that can fit the criteria in your query? Yes - 1,000 students - Queries that contain more than 1,000 students will not complete.