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 extracurricular activities.
Example Report:
🔁 Data for Query is synced at 8:00pm Monday - Thursday.
Build a Query Report
Queries are generated from the Reports tab of the Analytics module. When you generate a query, you will create criteria for the query and define the population (students) you'd like to view.
Once you've selected Query from the above tiles, follow the steps below:
Step 1: Title your Query.
Step 2: Determine the Query Population
The options you choose here will determine the pool of students to pull the data from; it is essentially building a cohort. You have options to choose from:
Sites (schools)
Teachers
Classes
Grade Level
Ethnicity/Race
Gender
Students (individual students or student groups).
School Year
The default School Year Is set to "Current Enrollment". You can select a different school year from the drop down menu if needed. Current Enrollment refers to student groups.
Once at least one value is selected in a single Population category, you toggle on , excluding anything within the values you set for the category.
💡 Tip: Do you need to exclude a certain group of students from the query? You can do that by selecting "Exclude" for that category.
Step 3: Set the Criteria
This can be a single criterion or multiple criteria.
Each time you make a selection from a dropdown, additional drop downs may appear depending on what you've selected, as some assessments have many possible criteria to choose from.
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 4: Assign Matrix Values (optional)
By toggling on the matrix value, a point value, chosen by you, will be awarded to the students who meet these specific criteria.
When you have completed the steps above, select Run Report.
Analyze a Query
Once you generate a Query, you are presented with data in many forms, from pie charts, to bar graphs, to tables.
Summary Pie Charts
At the top of the query will be four summary pie charts for sites (schools), grade level, ethnicity/race, and gender.
As you hover over any section of any pie chart, you will see a summary of that section indicating the number of students and what percentage that section represents.
Summary Bar Graphs
The next section contains summary bar graphs for student groups, teacher groups, and classes.
As you hover over any section of any bar graph, you will see the number of students in that section.
❗ How is it determined which groups and classes show? The selections are based on population. The query will display the 10 student groups, teacher groups, and classes with the highest populations based on the results of this query.
Individual Student Data Table
Student Groups (1): You can create or add students to student groups using the Flag icon. Select the students you wish to add to a group, then select the Flag icon.
Sorting (2): You can sort any column by selecting its header.
Download (3): Download this table into an excel spreadsheet
Change View (4): You can change your view to see 10, 25, or 50 student at a time.
Pages (5): Click from page to page to continue the list of students.
You will see that the matrix values are given to the students that qualify for that particular criteria. The very last column will total all of the values the student was given.
Using the Filters
Selecting any filters from the left will further narrow down the results of the query. You will notice the pie charts, bar graphs, and table change as you select and deselect filters.
❗ How is it determined which options for filters you are given?
Filters that remain static from query to query are Grade Level, Ethnicity/Race, and Gender. Those three filters will have the same options each time you run a query.
The filters that will fluctuate based on the results of the query will be Student Groups, Teacher Groups, and Classes. These filters will have the 10 options based on highest population; the groups and classes with the highest number of students generated by this query will be listed here.
Edit, Delete, Clone, or Send a Copy of a Query
You can edit, delete, clone, or send a copy of a query. Select the eliipsis to the right of the Query and select the desired option.
Information Regarding Sending a Copy:
Type the user's complete email address into the Recipient Email field.
Select Send.
A green confirmation message will appear on your screen in the upper right corner.
❗ Please note: copies of queries can only be sent to other administrators in your district. You are unable to send copies of queries to administrators in other districts.
Otus Live Video
Click to see a video from our Otus Live series that provides an overview of how to build Query Reports.
Click to see a video from our Otus Live series that provides an overview of how to build Query Reports.
FAQ and Troubleshooting
Click to see FAQ and troubleshooting details.
Click to see FAQ and troubleshooting details.
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.