Has anybody found alteration spells? If so, where? Which alteration spell is it?

I have only found the one where you have the ball of light (candlelight).

Sorry if this is considered a spoiler:
I think in Riverwood the trader had spell tomes like Clairvoyance, Oakskin (or oakshield cant remember).

There's an Oakflesh spell at the Riverwood Trading shop (or something)...Which it 40 points of armour for 60 seconds...But from what I've read, it doesn't work that well...Not noticed meself...There's at least one more Armour up from that which I found from a wizardy dude in the Dwarven ruins - "Summat Underkeep" in Markath...I believe they're mostly of that type...NO EASE BURDEN...DAMMITT!!!...

Oakflesh. It's basically the same thing as shield from Oblivion and Morrowind. You can find it by purchasing a spell tome at the Winterhold college.

There's also Magelight, which works like Candle Light, just a bit differently. I haven't found any of the cool things like walk on water or breathe underwater yet. I'm hoping that there are also unlock spells, but I haven't seen any.

I hope to find an underwater breathing spell as I didn't see any meter showing how much breath I had. Just swam until my health started taking a hit. Though since it doesn't seem like you can fight while underwater I guess there isn't much use for it except maybe getting to locations you have to go thru underwater tunnels to get to.

Whiterun.

If you haven't noticed, there are actually a ton of treasures and whatnot hidden underneath the water. It's also fun to explore now that the underwater sections are actually fleshed out and beautiful looking. I'm having a hard time finding any sort of spells right now, after the basic spell tomes at the College of Winterhold, I can't find anything. I'm hoping that their inventory will scale with my levels, but they haven't yet.

did you kill a chicken?...

what do alteration spells do? I heard its 'fear', 'calm'

Fear, calm, frenzy are illusion.

Alteration has shield type spells (armor, frost, fire, shock), light spells, water breathing/walking and feather (increasing your carrying capacity). Though i have only seen light and shield so far i think. In oblivion alteration used to have open locks as well, but dont know if that is still around.