Match my dandelion child who wants to be a civil engineer, to schools with excellent merit aid [4.0 GPA, 35 ACT]

He has gotten a lot of interest from D1 schools, but he’s pretty sure that’s not what he wants. He liked the idea of playing at an Ivy, but now that it looks like that will cost a lot, he’s saying he doesn’t see a point in that.

What do places like Case or Rochester cost after merit? Any guesses on how much a kid like that would get?