Donna & Scott,
Firstly welcome, and secondly, some key points in getting started.
1. When you book courses the first thing to ignore is the cost. Cost is pretty much irrelevant. there are some very good instructors that don't do it comercially. You mention a community college - the guy teaching here will probably be doing it because he enjoys it rather than for the money.
2. Avoid gimicky extras. Things like free dive computer use on OW courses is a gimick to get you to buy computers, it is probably better to learn the tables first, and get yourself happy with them before you go into computers. (we've debated this in some depth here!)
3. Some people teach more than the minimum necessary, the program I learnt with had us all helping with boats etc.. when we went out to dive, there are others that expect you to be just customers and have nearly everything done for you. I suspect you will see this kind of difference between a Community college and a dive store. Having to be involved with more has probably made me a better, more aware diver. More is good.
4. Agency is pretty much unimportant nowadays. The big US ones (PADI, NAUI, SSI, NASDS) all follow the US RSTC guidelines and their programms are almost identical. There are others (mainly in europe) with curriculums that are more in tune with local conditions.
5. Instructor is the key. Find an instructor that you get along with. Some operate on a production line basis, others are far more into treating people as individuals. There are plenty of horror stories about unsympathetic instructors. Find out how the instructor will treat people that have a problem with a particular skill. - Find an instructor you feel happy with.
6. How is the course taught? Some people now teach using computers and CD rom only, others will still do the old fashioned lectures for you. make sure they are using a method you are happy with.
7. How long is the course? It is possible to do the PADI O/W in less than 15 contact hours, this is IMO a bit TOO short, probably 20+ is good.
There are probably more, and If I think of them I will addd them
Hope you enjoy your course, and let us know how things go.
Jon T