Creating Customized Student Roster Reports

I hear it all the time: "But in TestWiz, we used to be able to run reports by classroom!" While it's true that the data warehouse doesn't technically have this feature at this time, you can certainly produce reports for any list of students (including a classroom roster) with a few extra steps.

The 600-level (student) reports in the Data Warehouse include a feature which allows the user to customize the report for a specific roster of students. This roster can be created in several ways: by choosing students from a list, by using a series of prompts to identify the students, and in some cases, by incorporating a list of SASIDs.

Some 600-level reports will produce one page (or more) per student, which can make for a very lengthy report. Reports that include the word “Roster” in the title (for example, R-616 Test Item Analysis Roster) will produce a compact format report which will include all selected students on a single page (or several pages, depending on the length of the list.)

Attached is a document which explains how to customize these student reports in a variety of ways. It is much more manageable (and secure!) to look at a student report that only contains the desired students...rather than going through, say, an entire grade-level list with a highlighter (trust me, I've been there.)

Save Time! Running Reports in the Background

Many of you have been looking at 2010 preliminary ELA reports in the data warehouse since earlier this summer, and may also have accessed the preliminary roster reports for all subjects from your Security Portal drop boxes.

The Data Warehouse welcome screen informs us that the reports for Math and Science are available as of today. But you're not the only one who's excited and ready to jump in and run reports! Obviously this is a very busy time for Data Warehouse use across the state. Even though upgrades have been made to the Data Warehouse servers over the last year, you may still encounter delays in performance while waiting for reports to run.

The solution? Learn to run reports "in the background" (also sometimes called "batch mode.") In this way, you set your reports up to run, but don't have to watch the hourglass spin on your screen while they do so. Reports are delivered to your My Folders or District Folders area in the desired format (PDF, Excel, or HTML.) This simple instruction sheet (Running Data Warehouse Reports in the Background) will walk you through the process.