Dynamic Reporting Basics

Here we have an example dynamic report on the Smarter Balanced test, allowing users to see which students of all grades and schools for that district, that are at or above proficiency in an organized form.

This is only one of many examples of reports you can get from the dynamic reporting section, as there are thousands of combinations depending on what options you have, don’t worry, if that seems like a lot, well it is, but it’s not as scary as it sounds trust me.

Here we see in the first box, where you can select which type of test you want reports for, in this case, we’re going to select the Smarter Balanced test. This selection box determines what test report you get for your dynamic report, and just like the other boxes, it can be changed as a dynamic report, so while seeing your report, you can change one of the options and get a completely different report.


Here we have where you can select the class roster of students and teachers you want to compare, based on year and what data has been provided to Multiple Measures.  Rosters are used only for producing teacher-level reports. We’re going to select 2015-2016 just for an example.

Now, as you’re getting the hang of clicking boxes and choosing options, I’m just going to start explaining the options if there are not enough to warrant a picture. So in the next selection box that should say “select reports”, there are two options, Pupil Results, which gives individual pupil results all together, and a Summary Results, which gives a single summary/aggregate report of what you choose.  We’re going to go ahead and choose Summary results, just to give you an idea of what it will look like.


After you choose either Pupil or Summary, you will go on to choose what report you want, for this example, we have the JUX report (which we’ll get into later) and for our example, we have a year-by-year report, which is the one we’re going to stick with for now.


After I select my year-over-year report, I get another box that allows me to choose non-matched students, or grade cohorts, and we’ll get into that later, but for this example I’m going to choose the non-matched students.


After we’ve selected those options, we get even more options to select from! This is where your actual report selections are, where as before we were just pulling data to make a report from. I’m going to go ahead and select all of everything, along with both subjects, just to show you the report and what it looks like.

So here we can see the summary report of our average smarter balanced scores for Hometown USD, in the 2015 school year, from all schools. We can also print the report, or export it to excel if you so choose to.


Here’s where we get to see the “dynamic” part of Dynamic Reporting, you can change one option, such as school, and you’ll get a completely different report, such is the dynamic part of a report, you can see different iterations of a summary with real-time refreshing of the chart.


For example, we’re going to change the school from all schools to Palm Middle School


As you can see, the report has changed, after we changed one option, the report transformed in real time into a completely different report! This is the main aspect of dynamic reporting, as you can change reports dynamically without having to labor over the same process of clicking and choosing all over again just for one different option.

Now that you’ve seen me do it, try messing around and make your first report!