What is Query 2.0?

Query 2.0 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 2.0?

  • Identifying students for ELL services.

  • Middle school and high school placement.

  • Qualifications for programs of extra curricular activity.

Example Report:

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


Generating a Query 2.0 Report

  • Step 1: Enter the Analytics module. 

  • Step 2: Select Reports.

  • Step 3: Select the Query 2.0 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. 


Video Tutorial


FAQ

  • How often is data synced to Query? Monday-Thursday at 8:00 pm

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


Next Steps

Did this answer your question?