Case 3

Boy, Case 3 was a blast!!
Seriously, though, I really liked it. I felt it was the first case in which there were moments that I had to focus intently to follow the instructions propperly. Evidently, I didn't start focusing intently until I reached step #5, as I neglected to use the TODAY function to insert the date, and I accidently included too many columns in step #4 computation. No matter, as soon as I saw the grade summary, I quickly resubmitted the corrected file.

Note: I particularly liked using the IF function.