Simply put, how does alteration armor look like in Skyrim, haven't tried a mage yet. Just curious

Aesthetically? The armor spells are basically a shimmer on your character's body. The wards under Restoration look like a shield of energy held in front of your character.