I never cared too much about bing popular. I didn't even realize I was part of the "popular" kids until I switched schools and I didn't know anyone.
The schools I went to actually looked down on the "average" kids. True, there were some popular kids that were athletes, but they were roughly the same as the kids that made 4.0s and above. I found myself right about the middle. It's not that my academic performance was bad, in fact, I was in the top 10% or so, but I simpy wasn't as social as the others. I had my group of friends and the others could disappear for all I cared.
I've been popular, I've been unpopular, but I think the best place to be as far as that goes is firmly in the middle. That's middle and highschool though.
Once you get to college, everyone's too busy either partying or studying to care. You'll probably never see them again anyway, so what does it matter if you show them all up or make a fool of yourself? In my psych course in my first term in college, I was a dual enrollment student. I was one of three in the class. The teacher asked after we took out first test if anyone made a 100% and I raised my hand. I got glares from the rest of the students and smirk from the teacher. He went over the answers and asked if I still thought I had a 100%. I said yes, and the next day I had the class, he handed my my paper and said, "Here's your 100%." loud enough for the whole class to hear.
Instead of being looked down upon by the whole class, a group of the students who did well but not quite the 100% (I was the only one to make a 100% on that test) came to me and we formed a study group. I made some friends out of it and didn't get any more dirty looks from the rest of the class.
Once you get more comfortable in your own skin, you'll realize that being popular isn't all you thought it was. This isn't to say that being liked isn't a good thing. On the contrary, it's easier to get things done when people like you and think you're a nice person. I smile and wave or say good morning to people I see on my way to class, and every one of them does the same. They probably all would say, "Oh that guy? He's nice, always has a smile." or something along those lines even though they've never spoken to me other than "Good morning." I'm not popular per se, but a lot of people now have a positive view of me, which makes things easier in the long run. You never know where the connections you make might take you.