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.
Convert your Lexile Levels to Approximate Guided Reading Levels
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!
attempts at using tech effectively in education 
Do you have a spreadsheet made for RIT scores that will convert to Gudied Reading levels?
Hmm, not sure what RIT scores are, but if you get me the scale, I can make it pretty quickly!
-Robert
Do you have one for below H in F & P levels? This is a great tool.
Hi Carolyn,
Late I know, but no I don’t. For two reasons.. Lexile generally doesn’t go that far down and if they are that low, it’s really important to do a running record to accurately know how to support them.
Hope that helps,
Robert
Looks very useful to share with staff, thanks. Could you reverse engineer this, to generate approx Lexile if my staff know F&P?
Yes, probably… Although I much prefer the F&P levels. š
Pingback: Daily 07/20/2013 | READINGPOWER
Hey Community:
My fiance asked me to make just such a spreadsheet. I used the scale version shared in the above version with a few improvements.
1. Included an average GR and Lexile score for your entire roster of students.
2. Included the number of students at each level.
3. For you formula junkies, I’ve simplified the long conditional formula.
You can copy and paste this link into your browser navigator to create a copy:
http://goo.gl/BCBkAt
Enjoy!
Jesse
Pingback: My (@pronovost’s) Top 5 Viewed Posts in 2014 #endofyearreview | attempts at using tech effectively in our classrooms
It’s worth knowing that Fountas and Pinnell levels do not always match up with the predicted Lexile Level, given the chart and any given text. In other words, two texts that both are listed as level N on F&P levels can have very different Lexile scores. My best-guess-accounting for this discrepancy is that Fountas and Pinnell take into account qualitative measures, while Lexile is not designed to do that. It only counts things that can be quantified, such as sentence length and number of words and word frequency (though I suspect there may be some room for error in that last, since a word can have more than one meaning for a given spelling, and some meanings are more common than others, such as bat (the baseball equipment)/ bat (the animal)/ bat (the verb meaning to take one’s turn at the plate in baseball)/ bat (the more general verb meaning to lightly hit at something, such as “the cat batted the toy off the table”). So there’s that.
Hi Sarah,
Thanks for mentioning that. They definitely don’t work very in sync with one another.
Hi can i know your source of the lexile range to the approximate F&P level?
Hi Patricia,
I think this could have been it, but it’s not a clear-cut thing.
Thank you so much for this!