 If you liked
Zero no Tsukaima
|
 ...then you might like
Juuou Mujin no Fafnir
|
One of the female main characters is an absolute ZERO in doing magic, spells and all things you should naturally own and acquire if you're in a magic school.
Although both girls try their best to fit in the magic high school where they're basically nothing compared to the other students, they still fail, but the comedy is guaranteed.
Also both anime are ecchi and harem, so I'm pretty sure you'd enjoy both