I have used it for almost the past 2 years and use it for school aswell.
The video quality is good. The built in mic is alright and the video files are pretty small for being good quality. Also the manual focus is not great but it has decent enough other featurs like auto-white balance.
Anyway, that being said i DO NOT reccomend it. Honestly it would have been a great camera to buy a while back but not anymore.
For the same price you can get something like the Panasonic HMC40 which is HD, has better video quality, and is tapeless (imports a LOT quicker)
So overall i would say do not get it and look into an HD camera.