The University of Bradford has been rated as the second-worst in the North and North East, according to a prestigious guide