Your statement is wrong. You are about pedigree. You mean - a “high ranked” university. You’ve been sucked in by marketing.
Most universities will be good - if you take advantage of their offerings. You have so many fine universities in your state, low cost ones out of state, and high cost.
I pulled the last paragraph below off the web - and this tells me, where you go undergrad will matter little (and it’s the same for law school) but how you do undergrad and in the GRE/LSAT and possible post college work experience will matter much more so.
Don’t let US News trick you into making the wrong decision. Find the right school for you - you already have motivation issues - and going into big freshman classes with multiple choice tests likely isn’t going to change that.
You can enter a Master of Social Work program with a bachelor’s degree in virtually any field. The degree usually takes two years of classroom work along with at least 900 hours of internship work, also called “field work.” MSW workers who engage in counseling or similar activities must be licensed by the state in which they work. That licensure in turn will require graduation from a school that has been accredited by the Council on Social Work Education (CSWE).