Focus on the learning, not on the grade

Good news. My chairperson liked the Methods section of my concept paper. I am pleased (and embarrassed) to report that she praised my paper effusively, using words like “fantastic work,” and “absolutely wonderful research, detail, and thoughtfulness.” She's “thrilled” with what I'm doing. After barking up so many stunted trees, at last I seem to have found one that will bear fruit. Praise whatever higher power is in charge of scholarly pursuits.

Now the Literature Review section is hanging over my head. Unfortunately, I didn't get anything done on it this week. Friday was the make-up day for the Labor Day holiday, and it's testing time in my computer applications courses. I've ranted on that whole thing previously, so I won't bore you again with the pressures of reviewing for tests that few students are prepared for. I see the results of my labors when I grade the tests. That was my mission tonight. I spent some hours grading the Excel tests, and all I can say is, I'm really hopeful I may have a career as a scholar, because I suck as an Excel teacher.

I blame myself. Then I blame them. Then I blame the workbook format that we are stuck using for the time being. Then I blame Microsoft (why not?). And as long as I'm blaming things, ummm, how about Republicans and global warming? Okay, maybe not. Still, there are many variables at play here, and each student is different. For example, the guy who threatened to bring a shotgun to class got the lowest test score (not surprising), but the one multiple choice answer that everyone else in the class missed—he got right. Go figure. So in my defense, I would say it isn't a matter of blaming the teacher or the students. That's just the easiest thing to do. But it's not helpful, nor is it entirely accurate.

It's not normal for my students to fail tests, but Excel is one of our trouble spots: we throw brand new students into Excel in their first term, and then give them Word, Introduction to the Internet, and Keyboarding. Even for computer-savvy students, this is a lot of computer time. Imagine how it feels for the ones who have little experience with computers. (How do I select a range of cells, again? How do I save to my flashdrive?)

What cracks me up (in a rather fatalistic way) are the students who type in values instead of formulas and assume I won't notice. I download their test files right off their computers onto my flashdrive. I open their test files, and I see exactly what they have done. Their printouts may look accurate, but their file shows the story.   These are usually the students who bring in the homework from home (did someone else do it for them?), who spend their time in class surfing the Web, who rarely ask questions, who leave class early. I can't prevent a disaster if it is the natural order of things. Not everyone is ready to succeed. Some of us have to crash and burn a few times before we are ready to do the work.

Now I'm trying to imagine how I am going to face them on Tuesday morning, how I am going to tell them I have to take more of their precious class time to explain what they missed, where they went wrong, when so many of them are lagging behind on the homework. Which, of course, goes a long way toward explaining why several of them failed the test. I ran a little regression analysis using Excel to compare test scores to amount of homework completed. I'm no statistics wizard, but all signs point to there being a strong and significant correlation between the two. In other words, the students who did the homework had the highest test scores. Duh.

They are going to rip me a new one come Tuesday. I must do what I admonish them to do: keep my focus on the learning and not the grades. I must remember that their grades are not about me. Excel is not something you can tell, or even show... they must do, over and over and over, until they finally understand it. That is how I learned. There are no shortcuts, either in Excel or scholarly research. Not everyone gets it the first time. But if we keep at it, eventually we persist and succeed.

For those of you who think, yay, now Carol has time to meet for coffee or talk on Skype, it might be too soon to celebrate. I still have a lot of work to do to get this concept approved. But there's hope for the malcontent. At least for today. By tomorrow this time, I will have convinced myself the praise never happened, and everything still sucks.