Everyone can learn any spell if his level is high enough and he/she has a point in the proper school.
Intelligence makes the AP cost go down and the damage go up (if the spell has damage)
Points into Air, earth, etc lets you use more than 3 spells of that school and more points in those schools unlock abilities (e.g. ice king for hydrosophists)