Student data worksheets in Excel using conditional formatting

Here's a follow up video to last weeks post on creating a student data sheet in Excel using conditional formatting. I posted an example file in the Global Learner Wiki under Elementary Reading: http://globallearner.wikispaces.com/Elementary+Reading

Cross posted on http://MrFisherGlobalLearner.blogspot.com/

Organizing student data in Excel

Since our district has adopted DIBELS as a literacy measure I would like to share how I use Excel to help me organize and analyse my student data. The Dynamic Indicators of Early Literacy Success tests has an online feature that is helpful but I like to keep student data in a format that allows me to group students more meaningfully.

First I create a spreadsheet with the DIBELS Benchmark measures. I add a column for nonsense words recoded. Then I add columns for data from the core phonics survey.

I select each column and then apply conditional formatting to populate the cell with a specific color based on a number range to indicate if the student skill is considered benchmark, strategic, or intensive. I use the DIBELS ranges for the DIBELs measures but I have my own set of cut-off ranges for Core Phonics data.

I then sort the data by Nonsense Word Fluency and NWF words recoded. Letter Naming Fluency is also a good indicator of reading ability for first graders (though sometimes not a good measure for ELL students). This gives me a general layout that allows me to make general groupings. I use the more specific Core Phonics data to fine tune my groups.

Finally, I set up additional worksheets within the Excel document for progress monitoring and for Winter and Spring Benchmark data. I add a worksheet that details what letter sounds and letter names have not been mastered for each student so that I can differentiate my instruction at the individual level. I add district writing scores and CELA scores so that I can have a very robust data set at a glance.

Cross posted at Mr Fisher's Global Learners