Should I choose CSE in a tier 3 college or core branch in tier 2 college?

Students are confused between taking Computer Science in lower-tier colleges or core branches like Mechanical and Civil in better-ranked institutes.