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 or extra curricular activities.
❗ Data for Query is synced at 8:00pm Monday - Thursday.
Article Table of Contents
➡️ This article describes how to build a query. For instructions on how to analyze, clone, send a copy, edit, or delete a query, scroll to the bottom and check out the links for Next Steps.
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.
➡️ Query Population
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.
➡️ Query Criteria
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
➡️ Matrix Values
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.
Otus Live Video
Below is a video from our Otus Live series on how to build a Query report.
How often is data synced to Query? Monday-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.
Do changes to class names reflect automatically? No, they require the nightly sync to update in query.