HI LUKE!
Can't say anything about UBC, or UofC. I got to SAIT, so yea...Still taking post-secondary in Calgary though, and I did also look into BCIT. I can't give you any insight into either universities, which is what you came here for. But this thread just turned into a shit show about Calgary vs. Vancouver....
Student scene in Calgary? Pretty good actually, I don't go out a ton, but the Den at UofC is greasy, cheap and full of babes if you want something easy (teehee). There are plenty of schools here, so a ton of places offer student discounts and deals. As said before, Calgary is pretty spread out for it's population, compared to Vancouver. This can be a problem, but there are tons of pubs and bars in each little suburb. I take it since you're a skier, you're not into the club scene. If you do care about them, they are downtown, knock yourself out kid.
As for skiing, Calgary offers tons of areas. COP is great, ignore the case of the punk ass snowboarder beating a kid up, you're an adult, I'm sure you can deal with anyone that comes up to you like that. COP is dope though, I just started park last year, and I love going to COP. I go every night or so, even if it's just for an hour. Along with COP, we have Castle, Sunshine, Nakiska, Norquay, and Lake Louise all within a 2 hour drive (and all in Alberta). Another hour west or south, you have Fernie and Kicking Horse, and another hour west of Golden, you have Revy. So plenty of skiing to be had, and plenty of skiers to meet.