The academics: challenging and generally top-notch. The students: interesting and provocative. The location: bustling, with all positive and negative connotative strings attached. The athletics: well, they try hard. The administration: they don't try so hard.
Let me explain. I have enjoyed nearly every class I've taken. The only ones I haven't are those that suffer because your teacher is insane. However, you can always look out for those professors with the very handy Columbia Underground Guide to Professor Ability. www.culpa.info. An invaluable site.
The people I have met with have nearly all been engaging in some way. They come from a unique background, or are seasoned world-travelers, or have incredible ambition, or just have quippy things to say. Most of them are broad in their perspective and broader in their understanding. It's a setting that incubates the best in you.
I love the city, most of the time. The place I came from was a fraction of the size. And while I loved it there, coming to such an exciting and busy place was a breath of fresh air. On the flip side, I am overcome on occasion with fits of what I can only describe as claustrophobia--moments when I have to leave, have to see real foliage and maybe even some mountains. If you come from a place that is enriched by natural geographic beauty, Central Park isn't gonna cut it. Sometimes you just have to get away.
The athletics can be a fun time. We're certainly not a school that focuses highly on athletic development, so don't expect anything spectacular, but people get into the games, especially during basketball season. The student body is also small enough that you'll probably associate with a lot of athletes, which prevents the formation of an elite upper-class based on the height of your vertical.
The administration is the only aspect of the university with which I have had a significantly negative experience. Probably the easiest way to explain it in simple terms is to say that if you lined up all the pieces of red tape surrounding the administration end to end, they would wrap around the equator 5,678,902 times. Not that Columbia has ever claimed to hold your hand and make you feel special when you need help, but it doesn't seem ridiculous to ask an administration to care at least a little bit about their students' needs. Perhaps you're wondering what happened. Well. Once upon a time...there was me, and a cute boy. We dated for a while, and then we decided to get married. So we got engaged, which is usually what people do upon deciding to get married. My fiancee is also a student at Columbia, and while we were motivated to make this decision by many different factors, one thing that made it seem plausible at this stage in our lives was the fact that we would be able to live in campus housing for at least one year, and possibly two, after getting married. In Manhattan, that was an amazing option because campus housing is so much less expensive than renting an apartment. Considering that undergraduates are guaranteed housing all four years of their education here, we assumed there wouldn't be a problem. So I set up an appointment with the people in charge just to let them know that this was happening and clear our names for joint registration in the housing lottery, and that's when things fell apart. Peace out, girl scout. Nothing, I was told, would be done for me. Why not? Essentially, the answer they gave me was "just because." After all, it is outrageous to request that my fiancee and I, who you will recall are both still undergraduates at this institution that so highly values diversity of lifestyle, be allowed to live together after being legally married to one another. So I moved up the chain, and after a great deal of hesitance and deliberation (of which we were a very limited part), they decided that oh, maybe it was okay after all. So I guess in the end we lived happily ever after, but getting there was a tense, unreasonable, and at times bitter experience. To her credit, one housing dean in particular was a driving force behind everything good that happened for us. She at least had both sympathy and common sense, and I primarily attribute our success to her. I tell this story not to frighten you or vindicate bitter feelings, but primarily so that you, as a potential incoming student, will know that this is a generally great place where you sometimes have to fight to get what you want. Don't take no for an answer, and you'll be fine. Coming in to the university, I never expected that I would need to work in close contact with any administrators. But you never know what can happen sometimes, and as long as you're willing to defend your cause in the case that you do have to work with the administration, this particular experience should not deter you from applying to an otherwise satisfying and engaging institution.
So there's the big picture. *snap* Or maybe more a photo album of little collaborative pictures. *snap* *snap* *snap* Whichever works for you. And for the Columbia administration, of course.