This Excel file can be easily customized for use in your classroom. It contains three worksheets with tables for individual student data, data for students broken into groups, and colorful charts and graphs. This is a great way to keep track of where your students started at the beginning of the year or at the beginning of a given unit and track their progress over time. It is also a useful tool in assessing student needs and sub-group performance. As we all know, standardized test data is often broken down into sub-groups, and administrators ask us to focus on sub-groups who, according to the data, are at risk. Instead of waiting for test scores to come to learn how your students are doing, you can keep track of them throughout the year and through each unit, enabling you to focus on those students and sub-groups who need more instruction or practice.
The first worksheet contains a table that teachers can use to enter data on individual students. The fields provided are student name/initials, race/ethnicity, gender, pre-test scores, post-test scores, gain/loss, lunch choice, and language/language preference. These fields were included because it was required for a research project I was doing, but you may add or delete columns as you wish. Please note that several columns/fields contain formulas and automatically calculate (e.g. gain/loss).
The second worksheet contains a table that breaks down the student data on the first worksheet by group. The table breaks students into groups based on gender, race/ethnicity, socio-economic status, special needs, and language/language preference. The table further breaks students down into sub-groups based on gender and race/ethnicity. There are several columns and fields that contain formulas and pull information from the first worksheet.
The third worksheet contains a few colorful charts and graphs I made from my own data. You can use this Excel file to easily and quickly make your own charts, or you can use mine!