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/
Showing posts with label conditional formatting. Show all posts
Showing posts with label conditional formatting. Show all posts
Saturday, September 6, 2008
Saturday, August 30, 2008
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.
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
Subscribe to:
Comments (Atom)
