No need to apologize--that's what these forums are all about. The department where I work is unique in my state (MD) in that it has a "generalized" PHN program. Meaning, we do all sorts of stuff! One of the biggest duties is working with Healthy Start patients. Healthy Start is a program for pregnant women and newborns. I visit a pregnant mom *ideally* once a trimester and then after the baby is born to assess the newborn. If there are any problems with the infant I can make additional home visits for up to 2 years. It's a lot of fun and I've learned a lot re: OB/GYN.
I also work STD clinics (pre and post test counseling), immunization clinics, well child clinics (interviewing and educating parents), with TB patients (educating those with +PPD and -CXR regarding INH therapy) and with some children with risk for developmental disabilities (premature birth or other issues). We also have a program called Infants and Toddlers and those nurses work specifically with children who have a diagnosed developmental problem. In addition there is a separate Family Planning program, TB division (working with pts with active TB), long term care, home health (skilled nursing) and many many other programs through the health dept that I could not even begin to list here.
Any second language skill, especially Spanish, will serve you well in public health. 80% of my patients speak Spanish and MD doesn't have that big of a (documented) Hispanic population. If your program offers a Medical Spanish course--take it!
Public health is wonderful and holistic and you can impact a lot of people, specifically those that are most disadvantaged (i.e. no health insurance). On the other hand, it's not very skill based, it's
very education based. Often times a feel like more of a social worker than a nurse, which can be frustrating. These are, however, only my experiences and opinions. Hopefully others will respond so you can get some other points of view. Good luck!
PS Most 2 year RN programs don't have a community/public health rotation. Most health depts will not hire a 2 year RN as well. There are exceptions, but this is generally the case. Since I don't know your background, thought I should mention this...