Welcome to the board! Remeber to dive your limits! Its often inexperience or not following the buddy rules that get divers into problems. If your new to diving, do some shallow dives first then see if you are comfortable with a deep dive. I personally would do shallow dives if I was a new diver, like go to a loca quarry or something to get experience in the water for a few dives before. I hate quarrys but you have to dive what you can here in Kentucky! Enjoy the trip it should be fun!
Remeber one last piece of advice, if anything makes you uncomfortable, don't dive. Better to sit the dive out and dive the next time! It doesn't matter if you PAID GOOD MONEY for it, wait for the next dive if you have any issues.
I would have to agree with what Pasley said, common sence is calling you!