Foreign Language advice PLEASE!

You can look at section C of the common data set of schools you are interested in (google "common data set XYZ university) and see how many years of foreign language are recommended/required. IMO if you don’t meet the recommendation/requirement you application will be at a disadvantage, especially for a very competitive college. I would not worry about if you are #2 or a few notches lower in class rank.

If you don’t want to continue foreign language in your HS perhaps you can seek out an accredited online class, a summer program, or a CC class (if those options are affordable to your family).