Are you looking to build a Query report in the Analytics module? You've come to the right place.

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.

Example Report:

Data for Query is synced at 8:00pm Monday - Thursday.

Article Table of Contents

➡️ Are you looking 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.


FAQ

  • 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.


Next Steps

Did this answer your question?