College of Winterhold

Who hasn't wished that Harry Potter was real (ehm...I mean...for all those muggles out there)?

The College of Winterhold sits at the North tip of Winterhold sitting on top of great column of stone with the treacherous bridges being the only way to reach it.
After climbing up the first ramp, you will be greeted by Faralda who guards the entrance to the college, and is a trainer and seller of Destruction spells. Upon asking her if you may enter the college she will ask you why you want to. It's your choice which answer you give and all except the "I just want to see what it looks like" will continue the conversation to where she will require you to perform a spell. She will request either a firebolt spell, conjure a flame atronach spell, a fear spell, the healing hands spell, or the magelight spell. If you do not have the one she requests you can buy it from her for a cheap price.
After performing the spell she will lead you across the bridges, lighting each of the beacons as you go. and direct you to Mirabelle Ervine the Master Wizard. You will first see Mirabelle getting a lippy with Ancano, a Thalmor agent who serves as an "advisor" to Arch-Mage Aren (high five to Mirabelle). When you speak to her she will welcome you and give you your novice robes and a tour of the grounds. First she'll take you to the Hall of Attainment and show you your quarters (first doorway to the right). All the wardrobes are safe for storage. She will then lead you back to the Hall of Elements where you will attend you first lessons with Tolfdir, a master trainer and seller of Alteration spells, who also resides in the Hall of Attainment.

Tolfdir will already be addressing your four other classmates, who will be dogging him about actually doing some spells. He will ask you what you think, either way he will continue by doing a ward demonstration in which he will ask you to help. If you don't know any ward spells he will give you Lesser Ward for free. Stand on the sigil to the West of him and cast the ward, keeping it up until he casts a destruction spell at you. After this, he will talk about the ruins of Saarthal and the quest "Under Saarthal" will begin.

Other people at the College
Hall of Countenance:
Colette Marence- a nervous and paranoid instructor (up to Expert level) and seller of Restoration magic, she can be found in her quarters on the second floor.
Drevis Neloren- a master trainer and seller for Illusion spells. His room is on the first level.
Nirya- a critical and haughty scholar with a grudge against Faralda.
Phinis Gestor- an expert trainer and seller of Conjuration spells. His room is also on the first level.
Sergius Turrianus- an expert trainer and seller of Enchanting. His room is the second to the left on the first level.

Hall of Attainment:
Arniel Gane- a scholar and conjurer specializing in Alteration. He is involved in several quests. His room is the the first to the right on the second level.
Brelyna Maryen- a defensive dunmer and fellow student, available as a follower after helping her with a minor quest.
Enthir-a scholar that sells mage items as well as a few rare items, and will buy anything. He is also involved in several quests and resides on the second floor.
J'zargo- an arrogant khajiit and fellow student, available as a follower after helping him with a minor quest.
Onmund- another fellow student and nord, and is available as a follower after helping him with a minor quest.

Gelebros- a member of the Psijic Order, who appears during the quest The Eye of Magnus
Quaranir- another member of the Psijic Order, and appears a couple times during the College of Winterhold questline.
Tandil- another member of the Psijic Order, who appears during the quest The Eye of Magnus
Urag gro-Shub- an orc mage and the librarian at the College. He will supply the player with research material for several quests and will collect rare books. He can also make you Blood-Kin after doing a minor quest for him.