savageinfidel

I'm teaching the investments class this spring, and it's been a couple of years. I'm trying to add a few things to the class, and have pestered my colleagues at Unknown University (and other schools) for some advice. So, I thought I'd use y'all likewise to see what suggestions you might have. Here's my goal: I want to embed more Excel assignments in my class, since Finance Majors can't have too much Excel exposure. So, I'm trying to add some assignments that expose them to the following concepts (note- those in bold type have been suggested by readers) Data Tables Pivot Tables & Pivot Charts IF (and Nested IF) statements Macros and basic VBA Solver and Goal Seek Regression Analysis Conditional Formatting Using some of the auditing tools Keyboard shortcuts VLOOKUP/INDEX/MATCH My goal is to get them comfortable with at least some concepts that can be used to signal to potential employers that they're at least a cut above the typical student....

Yesterday, I thought I was coming down with something - I had a sore throat when I went to bed, and I woke up this morning feeling kind of blah. So, I thought I'd muddle through my classes (unfortunately, it's my long teaching day), and then come home and go to bed. By the end of the day, I felt like I'd been beaten with a stick - sore and feeling heavy-limbed all over. But, it was the Unknown Daughter's birthday, so we had festivities first. Then, I thought I'd put in a little work on before going to bed. Big mistake. I started working on some spreadsheet models for my Fixed Income class at about 9 (just for an hour or so, I thought). Before I realized it, it's 3 a.m., and I've stayed up too late once again. So far, I've made two spreadsheet models. One calculates duration and convexity for any combination of coupon, maturity, frequency, and yield, along with some graphs. The other calculates the average life of a mortgage pass-through based...