This Excel pre and post assessment data form includes drop down menus that are set up to automatically color code cells to show students' benchmark level. Great for setting up intervention, differentiation, and supplying required baseline and target data. An "How to Guide" is included to help you change the options in the drop down menus as well as the automatic color coding if desired. Current menus and colors are based on baseline and target scores used in my district and state mandated performance data. The "How to Guide" also describes how to sort cells in excel so that you may sort by performance scores and benchmark levels if desired. I use this tool to help me figure out my differentiated ability groups when beginning an unit.
Current drop down menu options (can be edited):
Baseline Range on Pre-assessment
Intensive (0-20), Targeted (21-40), Targeted (41-53), Benchmarked (54-80), Accelerated (81-100)
Target Score on Post-assessment
30 or below (Intensive), 31-45 (Well Below Benchmark), 46-59 (Below Benchmark), 60-84 (Benchmark), 85 or above (Above Benchmark)
A DISCOUNTED BUNDLE of this and other similar assessment data forms can be found AT THE FOLLOWING LINK:
Thank you for looking!
Jen Williams (Teacheropolis)
Positive feedback is appreciated :)
Follow my shop for other data and classroom management tools