Tuesday, April 6, 2010

Creating Customized Student Subsets in the EDW

Many administrators are asking, "What's the best way for me to put together a classroom-level report, since the state's Education Data Warehouse doesn't include teacher data at this time?"

The new R-611 report in the Data Warehouse can be used to save a roster of students and run any of the other 600-level student reports now or at a later time.

• R-602 Student Item Analysis Graph
• R-606 Student Test Results with Standards
• R-610 Student Test Results
• R-613 Student MCAS History
• R-616 Test Item Analysis Roster

The group of students can be selected either through a series of filters (for example, Grade 3 LEP students) or by copying and pasting a list of SASIDs for the desired group (useful when filters aren't relevant, like a class list.)

While this is still a bit of a manual process, it is much easier than going through each type of student report and "checking off" the students you want to include.

I've put together a handout which will walk you through the 611 report, although it is relatively simple. Please let me know if you find this useful!