Student achievement data is often reported for whole populations (for example: cohorts, year levels, whole class). This is called aggregate data. It is not, however, until the data is disaggregated that patterns, trends and other important information are uncovered. Disaggregating data simply means looking at achievement results or teacher judgments by specific subgroups of students.
School leaders will want to look at assessment data to determine overall trends and to set school-wide goals or targets. Standard ways of disaggregating data for this purpose are by gender and ethnicity. However, for classroom teachers’ goal setting, there will be value in taking that investigation down to groups of students, or to the individual student. It may also mean examining the assessment by types of question or even individual questions to undercover trends in achievement gaps.
To learn how you can display test results disaggregated by gender and ethnicity, using Excel, view the video tutorial below.
You can practise disaggregating data using pivot tables by downloading the Excel spreadsheet below.