Maybe this will offer encouragement. I graduated from high school, went off to a big school, and flopped around in different majors for years. I finally ended up studying rhetoric and graduating with a BA in communications. My GPA was a measly 3.0, but I was good at natural sciences and had no business being in the social sciences. had worked as a PCA/STNA all through school, so I went back to a local community college to pursue a nursing career. I got a 4.0 in my year of prereq's, which maybe brought my GPA up to a 3.2ish. I tested well on the TEAS, anything over an 89 or 90 is a "99th percentile." My school is competitive entry, so my scores and science GPA won me admission. I am now 4/5 of the way through a 1+1 LPN&RN program. I hope this offered some motivation for you.
Just remember, each school focuses a different amount on testing vs. overall GPA vs. science/prereq. GPA. That being said, if you're average in some areas, you can still blow them out of the water in others. The schools
want people who can pass standardized tests, because their NCLEX pass rate is a deciding factor in their accreditation. Hang in there, and remember, there aren't too many schools in this country that would turn down a 3.5 GPA, and 90th+ percentile in standardized tests. Best of luck, and I hope this has been of some help to you!