^ I agree with the 5th semester (advanced) instruction. However, I wouldn’t say a course in translation (which are not so common) is necessary unless you actually plan to become a translator/interpreter. Of course this is based on the understanding that you want to learn CompSci while also becoming fluent in French or German. If on the other hand, you want to build a career on foreign language(s), then minimize CS (do a minor and pick up some programming) and try get into Middlebury if you can (and then a masters at the Monterrey Institute). These are two somewhat different paths.