Data analytics is at the core of SchoolStatus. We take all the disparate data sets that you rely on as an educator and we put it into one place to make it actionable and measurable, but building reports has always been complicated. Even when your data is in one place, you still have a lot of data to sort through. We have developed enhanced Reporting tools to help you explore your data in ways that are faster, easier, and smarter.
This guide will walk you through the steps necessary to begin exploring your data.
Click on Reporting in the main menu on the left hand side of the screen.
The Reporting home page will load with available data on the left in clickable drop-down menus.
To get a feel for Reporting, let’s answer a basic question about the students in your district. Among girls with 10 or more absences this school year, how many infractions have they received this year?
Choosing a Data Set
Let’s begin with a simple query. To start, click on a data set in the gray field to the left. Let’s choose Students and then Full Name. This will show the Full Name of each student in our query.
Creating a Filter
Let’s create a filter by clicking Demographics. Then hover your cursor over Gender. Click on the Filter icon (the icon appears when you hover over a variable name).
You will see a new Filter displayed at the top of your screen. Type "F" in the blank and choose F (or Female) in the dropdown. Now our query will only show female students.
Filtering on a Data Set
You can also display and filter a Data Set at the same time. We were interested in the total infractions for this year, so we will turn to that data set as our first example.
Click on Infractions and then click on Count. This will add the total infractions for the student as reported in your student information system. Data will only populate after you click 'Run'.
Note that the report will provide a sum for all infractions on a student's record unless we specify a limitation. In this case, we're interested in infractions for the current school year.
Filter the data by hovering on School Year under Infractions and selecting the icon that looks like a funnel:
Pro Tip: In SchoolStatus, a School Year is represented by the graduation or promotion year. Therefore the 2021-2022 School Year is represented as 2022 in SchoolStatus. In the fall of the school year, 2023-2024, the year will be represented as 2024.
Type a value to set the filter to equal this school year; in this example, we're looking at data from 2022.
We also want to know which of these students has 10 or more absences.
Click on the Absences dropdown option.
Since we only want to see students with 10 or more absences, click the funnel icon next to the Count variable under the Absences data table (you may also use the gear icon on the displayed data set).
In the Filter settings, change the “equals” in the dropdown menu to “is greater than or equal to” and then type 10. This will show us students that have 10 or more absences total in your student information system. We will also need to limit the data to the current school year from the absences data table, as we did above with the infractions school year.
Now that you’ve built your query. Click Run to update the information displayed in the report builder.
Learn how to Save and Download your queries here.