This is a google sheet designed to automatically color code your benchmarking data! This is perfect for AIMSWEB, F&P, MAP, or any other data that is collected.
The sheet is conditionally formatted to change the following colors as you enter in student’s scores:
RED - if the student is below the 10th percentile
YELLOW- if the student is between the 10th and 25th percentile
GREEN - if the student is between the 25th and 75th percentile
BLUE - if the student is above the 75th percentile
There are also columns to categorize students based on a group (GenEd, IEP, ELL, etc.) or Tier (1, 2, or 3).
You do need to input your district’s benchmarking goals. This is explained within the PDF document attached.
If you like this resource, please provide a review!
You Might Also Like…
Google Sheet for Setting Goals, Tracking Data, and Graphing Data
Special Education Evaluation Google Spreadsheet
Connect with SchoolPsychologist
Be sure to follow my TpT store by clicking on the red ‘Follow Me’ next to my Seller picture to receive notifications of new products and upcoming sales.
Follow me on Instagram