This is an excel spreadsheet that tracks the academic index on the average score of four tests over the school year. It is color coded and calculates the mean and median for each test, as well as a count of how many students fall in each category. The performance level thresholds are adjustable, although the names are not. If you use a different set of terminology (this one uses Advanced/Mastery/Basic/Approaching Basic/Unsatisfactory), let me know I can create a custom file for you.
Baseline Your choice. I'm using their previous year's test average, but you could use what best fits your classroom.
Data Tracked: Academic Index based on the average score on a series of four tests over the year.
Features Also tracks the median and mean for each test and color codes based on performance level, as well as the difference between your achieved academic index an the previous year's academic index. Performance level thresholds are adjustable.
Feel free to contact me if you need help or have any questions or feedback. Best of luck with your school year!