I know there are many folks who would like to create customized MCAS student roster reports "by classroom" or a variety of other groups - intervention group, performance level, subgroup, etc. This type of reporting is not currently available in the Data Warehouse. However, there are a few different options you can look into if you'd like to run reports this way.
The first option is to use the R-616 report (only available at this time in EDW 2.6, not EDW 3.0) to create a custom report either using filters or by choosing students from a list. This can be a bit tedious if you're creating reports by classroom but it's probably the quickest option at this time.
The second option is to start with the roster spreadsheet report from the Dropbox, and use Excel to add in a column for teacher or intervention group. The Filter option in Excel can then be used to create lists based on various criteria AND then Excel could be used to calculate group statistics such as median SGP (>20 students). However, entering the information into the teacher/group column could take a while.
For more advanced Excel users only: There is a function in Excel called VLOOKUP which would allow the automation of the addition of teacher/group data to a column in the roster spreadsheet. In order to do this, you'd need your Dropbox roster spreadsheet PLUS a spreadsheet that lists students (by SASID) by teacher/group. The SASID field will serve as a common data point between the two spreadsheets and allow you to bring data from one spreadsheet into another. Someday I'll write a tutorial for this, but for now, here's a link to a great VLOOKUP tutorial online for anyone would like a reference.
