September 21, 2011
Color Coding Data in MS Excel
At the middle school we have been using a data template that color codes the student scores on CFAs. Several teachers have approached me about using that same formatting for other data that they use in their classroom (e.g. CMT, CAPT, Grades). It is really a simple function of conditional formatting in Excel. Check out the video below to put it to use in your data collection.