A combination of a dweeb and nerd. The individual isn't quite as socially awkward as a dweeb and not nearly as smart as a nerd. Although said person tends to usually think they are a know it all, when in fact they are not.
Billy's knowledge on music wasn't only poor, but also awkwardly pretentious. Which is why most of the people at the party referred to him as a dwerb.