I think it's about doing your homework.
I know this will undoubtedly get me kicked off the Dis, but my kids aren't A students. My oldest, a HS senior, is barely a B. Knowing that, and our financial circumstances, guided the schools to which he applied.
He's currently sitting on 6 acceptances. We're still waiting to get the final numbers from the schools, but none of his schools will be much over $30K including room and board.
I went to community college, and am well aware of what a great deal it can be--- for the right kid. But my son isn't the right kid. He needs a small school, not one with a student body of 23,000. He'll fall through the cracks at our local CC.
But what I tell my students, over and over again, is this: when we bought our house in 1991, it cost a little over $150,000. It came with a THIRTY YEAR MORTGAGE!!! Borrowing that sort of money for an education will significantly impact the choices you're able to make as an adult.
What goes on your diploma is the name of the school from which you graduated, not the one where you started.
A great site is collegenavigator.gov
It will tell you not only stats like tuition and fees, but also the percentage of the student body that receives institutional aid, and the average amount awarded.