I'm going to Newcastle University in September; that's if I get the grades.
Basically, I have some friends up there that I visit quite a lot. They are in Richardson Road accommodation - typically known to be the party halls. If you want to be completely sociable and find it easy to block out a lot of noise when you are trying to work then they are perfect. In Ricky, the music never stops and there will nearly always be noise and parties so be warned.
Opposite Ricky is Marris House. Admittedly, it's basically a quieter version of Ricky. I have another friend in Marris and she says that they go to Ricky every night for parties, but then have the luxury of going home to Marris where there isn't endless music and loud noise.
The rest... I've no clue. But they are the two I suggest for the party halls.