I received my ADN in May 2009, graduating with my BSN in December of this year. I'm shopping around and looking at different NP programs (primary PMHNP) in the area, with UAB being one of them.
I'll give you my situation in a nutshell -
I made all C's in my ADN program (grades were all above an 80, but not at the "B" nursing school mark. bummer). In my RN-BSN program, I'm fairly certain I'll be getting all A's. I have so far, so I don't anticipate any differently through the end. Some programs look at pure cumulative (I know Vanderbilt does off hand), some programs look at the last 60 credit hours, some look at your BSN gpa if you received an ADN like me. Some schools even do a funky scoring system of your GRE x your GPA to achieve a benchmark score (Western Kentucky University), and there's one other school I can't think off off hand that does a variant of that.
My expected cumulative GPA after my BSN is 2.8. Not great, and I even told schools that upfront. The MAJORITY of the ones that I'm interested in told me that they look at the overall package, and GPA is just a small piece. Obviously, the more competitive ones (Vandy, insert high-end school here) will look at the GPA with more scrutiny. Some schools look VERY closely at references and interviews, and weigh them heavily (good in my situation). I also plan to do extremely well on the GRE, so it will help my gpa (im sure your gpa will be fine).
Also, for NP tracks, more schools require you to have one year of experience by the time you start a clinical rotation, preferably in the field of your interest (ie: psych nursing for PMHNP, med/surg for FNP, ICU/CCU/ER for ACNP)
I second other people on this threat: take the time to develop meaningful friendships and develop GOOD, SOLID contacts and references, and work a year or so before you dive into an NP program. Also, you're only on your first year of nursing school itself. Focus on whats immediately in front of you before you worry about the future
And remember, clinicals are a great opportunity to network for future job opportunities! Throw yourself out there and make friends with clinical instructors and people that work on the floor where you have clinicals! You're only hurting yourself if you don't.