Admins, Interventionists, Tech Specialists, and Team Leaders! This spreadsheet will save you HOURS of work and simplify data sharing and analysis as you set up interventions for your students!
Copy/Paste your raw MAP Score data straight from your NWEA downloads into this document. It will create instant color-coded reports based on MAP RIT bands for all students of a grade level in every strand - Reading and Math. It uses a 5-tier system (which you can reduce to 4 or 3) to color-code each student's scores by strand in both Math and Reading based on cutoffs you set. It automatically calculates a summary table for the entire grade level, with pie charts for each strand. It produces a separate printable page for each strand listing the students in each color coded tier. If classroom roster data is entered, you can then filter reports by teacher OR show all students.
You simply copy/paste the raw data download from NWEA directly into a spreadsheet, copy/paste classroom rosters, and set the cutoff scores for each color band using dropdown menus. Spreadsheet magic takes care of the rest! There is a blank column left next to each student to fill in interventions (or other manually entered data, as needed).
You will receive:
*MAP Math Report (blank template)
*MAP Reading Report (blank template)
*Sample Data to practice with
*Example of a Completed Math Report
*Example of a Completed Reading Report
*These spreadsheets work best when uploaded and converted to Google Sheets.*
In MS Excel, all aspects will function correctly EXCEPT for some color-coding individual student scores on one page. Summary table, pie charts, and strand break-outs still function as expected!*
*Please contact me for details and workarounds if using Excel.*
Future versions *may* include an option to import interventions and auto-populate interventions per color-band and strand.