The third Zero Net Energy Homes online course has just finished up. I have about 30 Capstone projects to review - very cool! If you'd like to get a sense of the course, which will begin again in February, there's a Test Drive module posted, complete with a couple of videos, some reading, and a homework problem with a Excel-based Heat Loss Calculator:
http://blog.heatspring.com/passive-house-heat-loss-calculations/