ivy league schools, to my knowledge, do not excel in the hard sciences.

That just not right. Harvard, Cornell, Penn and others have outstanding Chemistry departments, for example. Cornell also has one of the best micro/nanofabrication facilities in the World. This is on the Graduate level; I have no idea about their undergrad programs. But those are not important for ranking programs, at least as the rankings are usually performed.

(FWIW, I did my doctoral work at Berkeley, so I have no dog in this fight.)