Ideas are plentiful, too bad Beth just don't get some people too explore this part of the forums :/ People with their in-depth posts about Magic and werewolves...
Ok, my turn
Magix
Destruction
Novice-
Bolt, is the simplest type of spell. it is a shot of elemental magic. The bolt spell can only be a harmful element, such as lightning, fire and frost.
Push is a method to win you some time or change weapons. It utilizes all elements, but is the most effective when using air and water- it pushes the furthest.
Apprentice-
In-case is a sort of bubble like attack. It uses all elements, but...
If water- the victim cannot move AT ALL and is in water, so unless Argonain, drowns.
If fire/ice/frost- victim cannot move and takes damage based on spell.
If air- Victim cannot move.
Journeyman
Blast- A touch version of bolt and push, it does strong damage and throws the enemy backwards, can only be a single element, so only fire dmage and push, not fire and lighting/frost.
Expert
Earthquake is an attack with none of the elements; depending on your destruction level does exceedingly good damage and effects all enemies in an extremely large radius.
Tornado is an attack that uses air as an element and drags anything into the middle of a huge tornado that is a constant drain on the user's magicka so has no fixed value.
Master
Lightning strike; is a single bolt of lightning that strikes from the sky; it causes the weather to turn rainy automaticly.
Lava is a fire version of LS and causes the ground IMMEDIATLEY next to the victim to spurt with lava.
Torrent is the same move, put forces a jet of water from the sky to hit the enemy.
Freeze is a move that turns surronding landscape into snow and ice until the enemy dies. It is the only master spell that can be used in doors.
Alteration
Novice
Open is the one we all know and love. At novice it only opens basic locks... in fact it opens all locks, but you won't have enough magicka at such a low level to open Very hard.
Night eye is a infra red spell that shows living things deep red and nearby things with a small shade of blue, but only nearby things.
Apprentice
Teleknises is the same one, only carries objects.
Gills, adds, um, gills. Lets you breath under water.
Journeyman
Mark & Recall is one I don't know well, but people want it, so there it is.
Levitate is the wonderful spell from Morrowind :')
Expert
Human teleknises is the same spell, for carrying people.
Bind forces roots out of the ground to entangle the enemy so they don't move; permanent unless taken back.
Master
Expell forces the player and the user onto the clouds for a one on one match, with the death of the first person being the ticket out for the other.
Weather turn is a spell that changes the weather to the player's desire.