I have been working with a fellow data specialist to create a how-to guide on Creating Student Growth Rosters for Instructional Groups. If you're interested in generating growth/performance reports in the EDW for a specific classroom, intervention group, team, etc., this is the process to follow. Basic knowledge about the use of the Education Data Warehouse and Microsoft Excel are required to complete this process.
The document focuses on the G-602 Student Growth Roster (in the older EDW) which provides three years of MCAS performance data (scaled score) and the most recent student growth percentile (SGP) for each student for both Mathematics and ELA. The report also provides a median SGP for the group, if there are 20 or more students with SGPs in the group.
Please refer to my previous blog post on Examining MCAS Growth Data by Classroom for more thoughts about the opportunity to engage staff in discussions about growth data now as we move toward the new educator evaluation system.
I shared this process with a district colleague earlier in the week, and she sent me an email the next day saying, "I think I love you!!!!...Our secretary was able to get 3 years
instructional groups for me with state IDs. The reports are soooooo easy
to do and save!!! You saved me tons of time. I am very excited." So I hope there are other readers out there who will have the same reaction.
Happy Holidays to all!
