Psychology

Hi Jahnavi,
To apply for undergraduate courses in Stanford, you must take the SAT or ACT with writing as part of the application process. In addition to these, you must have excellent grades in your 11th and 12th and be an all-rounder. The university you are talking about is the world's most selective universities and admits very few students. Check here, read the requirements, see the kind of students they prefer and prepare:
https://admission.stanford.edu/apply/freshman/index.html.

To be eligible for librarian course, you need to have a Bachelor's degree in library science.

Please check the eligibility criteria of the institution wherein you want to study as different universities/institutions have different eligibility criteria.

The college offers the above-mentioned course. For details refer: https://www.shiksha.com/humanities-social-sciences/course/b-a-in-economics-psychology-optional-english-st-claret-college-jalahalli-bangalore-272835.
Request you to contact the colleges official for any further clarification.

It is not a bad choice per se, but do have a word with someone experienced in this course and then only, go ahead with your decision.