In high-school I was a super-nerd as well, but I think there were more nerds than pretty "popular" kids at my high school, so it's not like I didn't have friends. I was serious about, and good at my studies, and it was a good lesson to learn early that friends that respect that and don't require you to dress a certain way, or have a certain "look" to be likable are the best kind.
College is less cliquish, so I made friends with lots of people (I will admit most of my oldest friends did all come from the same Hapkido class, though), although I got a lot less reasonable at the school part of school. It was quite a shock to go from straight A's to mostly B's and C's (and my first ever F almost killed me #_#) and even worse, when I'm actually *trying* . Going to an engineering school for a pure science is brutal, and I would not suggest it to anyone ever. Just don't do it. Go somewhere right for your major, where you actually get to study that major and your department gets funded (/rant)
In any case social and extracurricular stuff, even though I have less time for it, went from something I could take or leave to outright essential in college. If I had been more reasonable at picking my school though, I may not have learned to rely on and just be with people the way I can now , so I guess it was still a good learning experience, just not the one I particularly expected or wanted at first.