Well its amazing how if you want something badly enough you will do what you have to do to get there. If you REALLY wanna be a nurse, you will just have to step up and get over the nervousness. I didn't wanna be a waitress or a salesperson for the rest of my life. I found nursing and I reallyyyyyyyy wanted to do it. But I have had to overcome extreme nervousness. One of the pre-req's was Speech class. I have a bad phobia about public speaking. I was sick to my stomach, sweating profusely, heart pouding, and face was red as a beet. BUT I knew that I had to pass the class to be a nurse. So I bit the bullet and did it. First one not so good. But I tried harder and got A's on a couple of the speeches. I ended up with a B for the class. Only because I didnt study for the exams. An exam on speech giving... go figure!
I got nervous when nursing classes started because I didn't want to be watched while I was 'doing things'. But you have to do it to be a nurse. SO again, I bit the bullet and did it. I am so comfortable with it all now. I even gave a speech to the entire junior and senior classes, and faculty for the class elections. I didnt even get nervous. On clinicals my classmates watch me doing procedures all the time. It doesn't bother me anymore. I just got comfortable and confident.
But you should really figure out why you dropped out of CNA classes. CNA is much different than RN. You will be responsible for much more as an RN. Only you can figure out what is right for you. For nursing school you have to be very dedicated.
Good Luck with what you decide... Let us know!