Stick A Fork In Me - I'm Done!

Just handed in grades for the semester. As usual, there was a pretty broad range of performance, and many of the usual cast of characters (the names change every semester, but the acts never do):

• The obviously extremely bright student who doesn't take proper care on his assignments and does them at the last minute. This results in a low score on 20% of the total grade, which along with his poor attendance (class participation is another 20% of the grade) makes it difficult to do well in the class. Then on the exam he gets one of the highest grades in the class (Final Grade: "B", when he was clearly capable of an "A").
• The not-so bright kid who is more passionate about finance than any student I've seen in the last five years. He ends up getting one of the highest grades in the class on the exam (Final Grade: "A", when I thought at the start that he'd probably be lucky to get a "B-").
  
• The charming one who tries to be my buddy, but doesn't do the hard work necessary to grasp the material on more than a surface level (Final Grade: "C"). Then he can't understand why he got such a poor grade (I guess math is also not his strong point).
  
• The student who failed the class last semester and retakes it this semester. She "Gets Religion" and works her tail off this time around (Final Grade: "B-"
• The student who failed the class last semester and retakes it this semester. He learns nothing from the experience and approaches it the same way he did last time, with the same results (Final Grade: "D+").

So, it was the usual mixed bag, with some surprising performances on both ends of the distribution. Either way, I can now put paid to this school year, and start on a couple of research projects that need my attention.

Now, all I have to do is get out of town before the emails and calls start coming in. I need to figure out how to put an autoresponse on my email that says "Dr. XXX is currently out of the office. He is recuperating from the stress of grading your papers on a dry (no alcohol permitted) campus. He will be back in a couple of weeks after recuperating and getting all the sand out of his swim trunks."

No, I'm Not Changing Your Grade

I just handed in grades for one of my classes. Not 20 minutes later, I got an email from a student asking why I couldn't give her a "B" because she "tried really hard and worked harder than most of the class". She's let me know repeatedly that she "really needs a "B". I considered sending her this cartoon:


But that would be wrong. Funny, maybe. Satisfying, definitely. But definitely wrong.

HT: Marginal Revolution.

All Hail The Mighty Excel For Grading

As a finance guy, I'm pretty good with Microsoft Excel. MOst of my immediate peers use it for grading. But if you do, here are a few functions that you might find useful:

1) The IF function is useful if you have two different weighting schemes. For example, to give the poorly performing students incentives to push hard in studying for the final, I often tell the students that I will grade them using two different weightings on their grades - in one I put greater weight on the exams and quizzes that take place throughout the cours, and in the other I put more weight on the final (I assign them the higher of the two grades).

Use the syntax =IF(Scheme1>=Scheme2, Scheme1, Scheme2) where Scheme1 and Scheme2 reference the cells containg the scores under the two weighting schemes, and you'll get the higher of the two cells.

2) The LARGE function is very helpful when you want to pick N out of K scores (for example, if you calculate the average of quizzes after trhrowing out the lowest N scores). The Syntax LARGE(A1:J1,2), will identify the 2nd highest score out of the 10 elements soted in the array from A1 to J1. To calculate the average of the 8 largest scores in the cells from A1 to J12, I'd use the following syntax:

=(SUM(A1:J1) - LARGE(A1:J1,10) - LARGE(A1:J1,9)) / 8

In other words, I calculate the sum of all ten, then subtract the two lowest scores,and then divide by eight (make sure you keep track of the parentheses).

Tis The Season To Be Phlegmmy

Unknown Son has had intermittent fevers for the last couple of weeks - one day he has one, the next he doesn't. Finally, we took him to his pediatrician.

Turns out he has a mild case of pneumonia. So, it's back on antibiotics (nasty tasting stuff, there) for a couple of weeks.

The good news it that I have yet another excuse to avoid grading my last few projects - I have to be home with my son.

Of course, I could have just taken the projects home with me, but that wouldn't be any fun...

On the bright side, I've just about finished reviewing the Quantitative Methods section of CFA Level 2. Good thing, since I teach it in a few weeks.