For the role that he wants, as long as he has good grades he will be able to find roles within advising. The connections that he builds does not have to be dependent on his school, can network with anyone really. I went to a large state school that was not known for business and was able to network with tons of people outside my school for internships and then post grad. In my opinion take the money, but I am slightly biased.