Video Resources for StoryTown reading grades 1 and 2

I’m excited for this year and have already begun incorporating technology in a couple of ways: First I am using Excel to house and display my student reading assessments. I needed a little refresher on conditional formatting in version 2007 so I just watched a quick Atomic Learning video. (Don’t forget our new login is at http://www.atomiclearning.com/login/adams14 Just login with your district network login credentials). Next, I’m using the SmartBoard quite a bit for math and literacy. A great resource I also use quite a bit is DiscoveryEducation.com’s video library. Last spring Tara Ward and I put together a list of video resources for first and second grade to accompany the Storytown reading program. These video clips are largely from Discovery education and YouTube. The resources can be found here: http://eslpages.pbworks.com/StoryTown.

How to create a student data sheet in Excel using conditional formatting

Here's a follow up 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

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 (NWF) 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 on Adams 14 Global Learner Blog