Friday, February 25, 2011

Data Visualization

Students Regents Performance Breakdown Term-to-Term 


Students Regents Performance Breakdown January-to-January

OK, first a confession: I'm a bit of a data geek. Every term, after the Algebra Regents results come back, I spend a solid week grinding through the data. I do this until it gets in the way of the day job (read: teaching the next crop of Regents test-takers). At that point, I generally file away all my charts and spreadsheets until the next end-of-term data tsunami.

The depth of analysis is hindered somewhat by my status as a software Luddite. Back in 2006, the year I became a public school teacher, I took a class at Brooklyn College that finally forced me to learn how to use Microsoft Excel. Since then, I've gotten a little better at not just presenting data but in thinking about data in a way that makes it easier to analyze. A half-decade later, I find myself at the point where I should be moving up to bigger and better tools. Alas, the same hesitation that kept me from opening my first spreadsheet file now keeps me from taking off the training wheels.

Fortunately, there's Google which, if you haven't been keeping up with current events, has been ramping up its data visualization apps via Google Docs. It's still a little clunky compared to Excel, but it works if you're patient. Besides, they've got the "cloud" on their side. Having navigated my way through more than a few Excel crashes, I've learned to prize that Google Docs autosave feature.

Anyway, enough advertising. Inspired by a recent Slate article on data visualization and in a post-Madison spirit of teacher transparency, I decided to post some recent creations. The above is a "stacked" column presentation of my students' term-to-term Regent performance. 

ANALYSIS:   

The above two charts differentiats students who passed the Regents with a 65 score or better (green layer) from students who failed the Regents (yellow and red layers) and, finally, students who failed to show up to take the Regents (black layer). The top chart tracks results term-to-term. The bottom chart, meanwhile, tracks only those students taking the January Regents exam, an off-track test generally reserved for students who failed or failed to take the exam when it was regularly administered at the end of the school year.

Differentiation between students who came within 10 points of passing (yellow layer) and students who fell below the 55 level (red layer) is based on two concerns: First, the state uses the 55 score as a graduation threshold for certain (read: special ed) students. Secondly, as a teacher who works primarily with remedial students, I generally find that a term's worth of algebra review adds, on average, 5 to 10 points to a student's Regent score. In other words, rather than seeing a kid who moves from 45 to 55 as a failure, I'm trying to view it as a success.  

Including the absent students in this analysis is based on the rationale that each student who ducks the test is a vote of no-confidence in either the teacher, the school or the method of in-class instruction. Granted, a lot of these no-shows are no-shows in the classroom, long term absences the school has been forced to keep on the books whilst various city departments (education, corrections, social services) come to a basic agreement on where the student truly belongs. In such cases it's pretty hard for even the best teacher to have an improving impact.

Of more concern, however, are the kids who will sit through 18 or 36 weeks of a class and yet, on the day of the test, decide to stay at home. As the chart shows, I've been largely successful in reducing test-day absence cases -- until this year at least. Alas, a blizzard on the morning of this years January Algebra Regents compelled at least a dozen of my regularly attending students to stay at home. For next go-around, I have only Freshman classes, with a day-to-day attendance rate in 90% range. Barring a freak June snowstorm, I expect the black no show column to continue its downward drift.

SO WHAT'S THE DEAL WITH JANUARY, 2010?

Good question. Here's what happened: During the fall term of 2008-2009, my second year as a high school teacher, we offered ME33, a Regents Review courses for students who'd failed the previous June Regents exam. Because students had already gone through a year (at least) of the Freshman algebra curriculum, the teachers who taught this class were free to choose their own textbook and set their own pacing calendar. My assistant principal gave me 4 of those classes with a test-day roster of 123 students. Of those 123 students, only 34 passed scored a 64 or better. Tossing out the 28 no shows, that still only gave me a 35 percent passage rate. Pretty weak. Especially when you compare it to the roughly 50 percent passage rate the two other teachers handling the other six ME33 courses posted that same term year. 

Long story short, the reason the January, 2010 totals dip so precipitously is that my supervisor, remembering that 36% passage rate, shifted me to the back of the line up, reducing my total number of ME33 courses to two instead of four. I can't fault him for this decision in retrospect as I was able to use the opportunity to focus on raising both my Regents day attendance rate (83% from 77%) and my attending cohort passage rate (51% from 36%). 

Anyway, in reward for that performance, I was given a third class and a bigger average class size (34 students per) in this year's ME33 go-around. Though I let things slip a bit on test-day attendance (back down to 70% with partial blame going to Mother Nature), I was able to keep the passage rate moving upward (58%). What's more, I was able to grow the share of "on deck" students (31% from 20% in 2010), making things that much easier for the next review class teacher.

Which leads to a final point of analysis: When the next math teacher is you, it helps to differentiate the instructional strategy in a way that the student who didn't reach the 65 passage threshold comes into your next class feeling like a success as opposed to a failure. While the January 2011 results shows the usual downward dip that occurs during the algebra off-season, I'm pleased to note the even faster decline in "red state" students, i.e. students unlikely to pass the Regents exam on the next go around and thus very likely to be sitting in (or cutting) the exact same ME33 class next fall.

LESSONS LEARNED?

Lesson 1: It helps to look at data. Back in 2007, a year after moving up from the middle school ranks, I thought teaching math in high school was a snap. After all, 60 percent of the kids I had who sat for the first Integrated Algebra Regents exam wound up passing the exam -- compared with a schoolwide passage rate in the 40-45 percent range. Six months later, however, the tables turned. Suddenly I was the department goat. In an effort to bring my numbers back in line, I've been forced to watch other teachers in action and admit that I'm not the smartest guy in the room. The process has been humbling but also illuminating. One thing I noticed is that the teachers who were beating were dealing with the same classroom issues (spotty attendance, mouthy students, cellphones, iPods, etc.). The only real difference between them and me was the level of overall consistency and patience those teachers demonstrated when it came to navigating the 18 week curriculum. Hence my growing mania for classroom routine.

Lesson 2: Experience helps. While I don't have the same data for other teachers' classes, the limited amount of analysis I've done on the department-wide stats shows an interesting trend: Where I am right now, statistically, tends to be where the leading teacher in the department was two years ago. How many additional years of teaching experience does that teacher have on me? Two years. Exactly. While our stats drew pretty much even over the last term, I still have to give her the edge as she had one more class (30+ students) and a much more sizable IEP cohort (40+ students, vs. 15 on my part). True, she had a co-teacher with a special-ed license in the room, but I'm not in a rush to trade places with her.

Anyway, I bring this lesson up only because it coincides with the ongoing debate about seniority privilege, especially when it comes to hiring and firing. As much as I want to paint myself as exactly the kind of "young" and "energetic" teacher reform advocates like Mayor Michael Bloomberg have been championing in recent years, the numbers so far appear to be making a pitch for "experience" and "consistency," especially when it comes to lower performing students, of which we have an abundance here in New York City.

Lesson 3: Test lightly. One thing I found out pretty quickly way back in 2008-2009 is that students with a history of failure on the Regents tend to view the test as an un-motivating exercise. Sure, they'll take each test seriously but the moment that first negative test score comes back, you've pretty much lost that student for the rest of the term. As a result, a lot of my instruction has focused on delaying that first negative test score as long as possible. This last term, I went even farther, borrowing another teacher's system of giving weekly quizzes and giving those quizzes equal cumulative weight to the 5 tests offered during the same term. What's more, I made sure to score each quiz in a way that set a 40 percent "floor" for students who missed every question and that rewarded effort (backing up a multiple choice answer with sideline work, say) over mere knowledge retention. 

Granted, there is a sizable faction within my school's math department that views this type of an assessment strategy as yet another sign of the educational apocalypse. Still, the resulting data shows a significant uptick in off-term Regents performance. 

Lesson 4: We're making progress but it's slow progress. A 42 percent failure rate is nothing to crow about,I know,  but it sure as heck beats the 65 percent failure rate I was staring down two Januaries ago. Reducing that failure rate to something a little more tolerable, 33 percent say, will require an equal, if not greater multi-year effort, I think. For one thing, there's only so much training you can give a student in 18 weeks. For another, there's only so much education you can truly impart in a culture where most students a) blow off homework, b) miss an average of 4 school days per month and c) don't exactly have the home support structure compelling them to aim higher in education or life. Simply put, there are many phases in this conflict. The classroom is just one theater. A key theater, no doubt, but theater nonetheless. Until the other theaters show change, I expect to see a few more ups and downs in each chart. 

Monday, January 3, 2011

Back to the Grind

Not bad for a Monday. After Christmas.

I write that knowing full well that not one lesson today met or even approached what I would have considered a satisfactory engagement level in mid-September, but then sometimes you have to be willing to take a bad day in exchange for a couple of good ones down the read -- sort of like knowing when to take a sack when you're a quarterback with no play in front of you. 

Anyway, it all goes back to the routine issue of the previous week's posting: If you step back and view things from a kid's perspective, coming into the classroom, talking to your friends for 10 minutes and then wondering why the guy with the tie in the room is gesticulating so wildly has become sort of the daily classroom routine, at least over the last 2 weeks or so. A lot of today's work revolved around reminding kids how to perform a warm up task, how to keep pace with the note-taking and how to shut up when I need them to shut up. 

Most importantly, it was about patience. I'll admit, I'm about 6 weeks past the point where I can summon the patience at will, but today was proof positive that the reservoir had been noticeably replenished over the 9 day break. How long that reservoir will stay full is anybody's guess, but I get the feeling that tomorrow will be even better. We'll see.

Sunday, January 2, 2011

(Teaching) Resolutions for 2011

1. Keep up with homework. Here in NYC, we break each semester up into three marking periods. We're currently in the third and final marking period of the first term, which means I'm staring down a mound of paper collected in the final 10 days before the Christmas break. This despite the Scarlet O'Hara-like vow that, God as my witness, I'll never fall behind on grading again that I made just before the Second Marking Period grades came due (Dec. 2).

To make this resolution stick, I need to harden my philosophical stance on the purpose and meaning of homework. I work in a department where the teachers take homework super-seriously.

2. Yield to the hands-on imperative.