Reporting: What reports are you using to start analyzing subgroup data in Illuminate?

Comments

3 comments

  • Avatar
    Kristin Town (Edited )

    Multiple Assessment Subgroup Summary is a great way to ask those big questions about whose needs we are meeting and whose needs we are not. It allows teachers to look more specifically at their assessments and their student results to see if there are adjustments that can be made on an instructional level. You can generate it quickly following these steps:

    0
    Comment actions Permalink
  • Avatar
    Casey Mirch

    Going back to before Illuminate, Leadership Public Schools has had a practice of looking at all sorts of data disaggregated by subgroups that are involved in accountability reporting or just important to us. So the most direct answer to the question is: potentially everything. That has engendered a generalized approach to building reports about subgroups.

    In Illuminate, that's implemented as a Summary Assessment or non-core Student Demographic repository. The columns are subgroup type (e.g., gender, reporting race/ethnicity, English proficiency status, SPED status, etc.), subgroup membership (e.g., female, Hispanic, RFEP, not SPED), and an abbreviated subgroup membership for sorting or terseness. We periodically import data for all of our students, ensuring that each student no more than one subgroup membership of each type. In other words, we go a step farther in normalizing student subgroup data compared to what you might get in a Custom Report with the relevant student fields, transforming a wide list into a taller one.

    That Summary Assessment with student subgroup memberships can be added to a Custom Report, with the subgroup type and subgroup membership fields used as grouping levels. Then whatever other measures of interest are included in the Custom Report can be summarized/disaggregated by subgroup, with each student contributing no more than once to each of their relevant subgroups. It tends to avoid situations where filters about the measures of interest conflict with filters and related records needed to identify subgroup membership. It definitely reduces the number of Custom Reports needed to examine an assessment or other information from a subgroup perspective.

    This approach can sometimes result in a big table full of an overwhelmingly large quantity of data points. On the other hand, it makes it very easy to take any metric of interest and provide disaggregations by subgroup. Teachers and administrators seem to get familiar with this presentation format and engage readily with recurring reports and new metrics.

    In hopes the table renders legibly, here's an example of the structure of the type of report I'm describing.


    Subgroup Type Subgroup Code Subgroup Name Unduplicated
    Student Count
    Average of some metric
    Socio-Economic Status true Low SES 243 ...
    Socio-Economic Status false Not Low SES 157 ...
    ELD Status RFEP Redesignated Fluent Eng Profic 212 ...
    ELD Status EO English Only 107 ...
    ELD Status IFEP Initially Fluent Eng Proficient 50 ...
    ELD Status EL Eng Learner 31 ...
    Special Education status false not eligible 374 ...
    Special Education status true SPED eligible 26 ...
    Race/Ethnicity 105 Hispanic 279 ...
    Race/Ethnicity 101 Asian 37 ...
    Race/Ethnicity 107 Filipino 25 ...
    Race/Ethnicity 104 Black or African American 19 ...
    Race/Ethnicity 103 Native Hawaiian or Other Pacific Islander 11 ...
    Race/Ethnicity 106 Two or More Races 9 ...
    Race/Ethnicity 100 White 8 ...
    Gender M Male 213 ...
    Gender F Female 187 ...
    Grade Level 11 11th Grade 144 ...
    Grade Level 10 10th Grade 141 ...
    Grade Level 12 12th Grade 115 ...
    All Students 1 Student 400 ...


    0
    Comment actions Permalink
  • Avatar
    Kristin Town

    Wow, Casey! Thank you for providing such a great resource for those administrators willing to dive deep into subgroup data!

    0
    Comment actions Permalink

Please sign in to leave a comment.