This is an excel spreadsheet that calculates the average academic index for a series of three assessments. It's color coded and has adjustable performance thresholds. I use it to calculate my performance for the state's Student Learning Targets (SLTs).
Baseline Your choice. I'm using their first writing assignment, but you could use what best fits your classroom.
Data Tracked Average academic Index of a series of three assessments 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!