Our district has just adopted i-Ready, an online diagnostic and instructional program. For all its great features, it current has teachers go to each individual student’s report to find the student’s Lexile Level. Now I may not be in the classroom this year, but I do know how ridiculous it is to ask teachers to click through so much to find a Lexile Level and then make them find a correlation chart to find out what approximate Fountas & Pinnell Guided Reading Level the student is reading.
So, after a few days of learning about the amazingness of Google Spreadsheets from none other than Alice Keeler, I thought I’d make my own spreadsheet to help teachers out a little, given that I can’t make the i-Ready people create the batch reports we need. I learned a lot about nested if statements and basically was told by Alice and Roni Habib that I need to learn about vLookup, since I used way too many nested if statements. Wanna see?
Yikes, right? Anyway, I had a lot of fun creating this, and since it might be useful for more people than just the teachers in our district, I thought I’d share it with the world.
Please, log in with your Google account and make your own copy, so you can manipulate and save the data. Remember that it’s only an approximate level, but share this with anyone you’d like!