grapeoochola -
hi there - i went to MHCC and graduated in 2006. i loved the program. i should note that when i went through, it wasn't OCNE like it is now, so i can't speak for that part of it.
the instructors are great - very helpful and knowledgeable. it was 6 terms and the 1st 2 terms were spent in LTC clinical. term 3 was OB and peds (for me, not everyone did peds). terms 4,5,6 were all med/surg with term 6 being your senior practicum.
as far as tests go, it seemed like we had at least 3 exams per class and then a comprehensive final. and be prepared to write nursing care plans

i have not written one since school ended...
no community service, just clinicals. there were a couple opportunities to volunteer with local schools and provide vision screens and stuff, but nothing required.
hope that helps and good luck and congrats!