Interesting Question...
...but I don't know if my HS or College experience exactly fits.
I attended what was called a "Magnet" HS in the U.S. I don't know if they have those in Canada, but the point is that you were admitted via testing - there were no "dumb jocks" or dumb people period at my HS. If you were to divide the school population into fifths, the lowest 5th at my HS would have still been average to above average students at any "regular" HS in the city. Besides that, the school drew (hence the term "Magnet") kids from all over the city...many of us had long commutes (mine was 90 minutes on public transit). You don't do that sort of thing as a teen unless you take school fairly seriously.
The social cliques....well, there were the REALLY smart kids...the ones who went on to Ivy League and similar type universities, some on full scholarships. They were maybe the top 10% of the class. Some of those folks...maybe half...were what you would think of as stereotypical nerds....real social introverts who mostly hung out with their own kind. But about half were also pretty social....pretty popular. They were really kewl kids...who happened to be really smart. Since it was a school of "smart kids" (we weren’t all geniuses, but no one was stupid), you didn't get made fun of for being smart. So if you had social skills...you did well.
The next 25% were pretty smart kids...kids who were going to go on to a top notch college, but didn't really have the grades or test scores to go Ivy League. This is where I fit in; as did all of my friends except one (he was in the top 10%). Most of us were modestly popular...some more than others (for example, one of my buddies in the group was the school "DJ / MC"...very popular guy....was asked to all the parties so he could "spin"). This was probably the group that was the most socially diverse and that looked most like a "regular" HS. My best female friend was immensely popular...as about as popular as you could be without being a cheerleader. Indeed, she was more popular than the cheerleaders because she got respect from the top 10% kids for being smart as well as the rest of us for being smart and kewl. She was pretty, she was smart, but she was also very kewl and friendly. Everyone liked her, and she wasn't an elitist at all. Me, I was pretty popular as well because I kinda traveled in two social circles...I was both a "smart" kid (not a rocket scientist, but in this 25% group) and a jock. So...I hung out with the jocks a lot, but not constantly, and I hung out with my friends. I used to say I was "king of the nerds" because a lot of people (in my circle) kinda looked up to me since I was a jock, plus I dated the head cheerleader, but really, it wasn't like that. We were all kewl with each other.
The next group...say 50%...were kids who were smart enough to get into the school, but didn't take AP classes or anything like that (I don't know if they have AP here in Canada). Most of the party types came from this group...some were extremely popular, some were not. Again, a whole social spectrum.
The bottom 15% was where you found most of the social outcasts. See, at my HS school, if you weren't SMART you didn't fit in. So this is where the kids who struggled to get by academically fit. Some of course were popular socially because they were very kewl, but most just didn't fit in....no one knew them or about them.
University for me was kinda similar. I went to an engineering school...not quite MIT standards, but pretty tough to get in. No stupid kids at my University. So, even the "jocks" (like me), were half way decent students...took school seriously at least some of the time, etc. There WERE lots of total geeks (as you can imagine at an engineering school), but there were so many that they weren't really social outcasts...they just hung with their own kind. And the "party kids" were geeks too. We all were geeks to some degree. Again, no one made fun of anybody for being smart....but you could see how some people just were not developing socially....by age 21 you really should be able to meet and greet people, hold a conversation, etc. Those folks did kinda get ostracized...
Insofar as the "jocks become losers, nerds rule the world" characterization...I can't say that was true for me. I don't know anyone from my HS who didn't do ok...as in has a job, pays their taxes, etc. I don't know all 1500+ kids of course, but whenever we have a reunion of my class (about 350+) there are only a handful of sad stories...people who just caught really bad breaks. Mostly everybody is doing ok. Again, no dumb jocks. Indeed, the two wealthiest people I know from my class were both "jocks"...one gal went on the become a minor tennis star...I think she broke the top 20 in world rankings...and the guy went on to become an NFL number 1 pick (not just first round...first pick in the draft). I knew both of them, neither were stupid people...but they made their money in sports. Insofar as college, not many failures there either…most of us were studying to be engineers or architects or computer scientist or something similar. I met both my two best friends in University…one is a very successful doctor, the other is the chief engineer for a medium sized technology firm he works for. Neither are hurting – trust me.
Bottomline - I understand the stereotype, but it doesn't always apply...