Applying+the+Stop+Light+Highlight

=Applying the ‘Stop Light Method’ to Data in Excel =

• __Introduction: __ The Stop Light Method of data organization is used to create a visual guide of student performance. Usually, this is completed by color coding student scores that fall within a particular range. For example, 3rd grade CMT scale scores that fall below 209 are highlighted red, student scores that range from 210-249 are highlighted yellow, and student scores that are 250 or above are highlighted green. The color scheme corresponds to the stop light and implies the same message. • This same method can be completed electronically using the **Conditional Formatting** tool in Excel. While we are using CMT  scores and ranges to demonstrate this, the technique can be utilized for any electronic assessment file. Also, the range of scores that correspond to each color is a user-option (you can modify the range to meet your unique needs).

1. Open a blank excel sheet and then cut and paste your scores into excel. If there is unneeded data delete it from the worksheet.
 * 2. H ighlight the column that contains the scaled scores you would like to analyze **

