My daughter did a distance learning course in Latin. She did two years and then took the SAT Subject test. She scored high enough on it to actually satisfy, not just the foreign language requirements for admission, but also the undergrad foreign language requirement for her BA. We hadn't anticipated that benefit, but it was pretty great!
Rosetta Stone is... meh. You can buy a Spanish textbook or workbook and a few audio CDs and have the language down pat in no time - at least the basics. Spanish is not a difficult language to learn, and certainly an easier language to self-study.
Personally, I hated Rosetta Stone - I was trying to learn Spanish and, for someone with my background(awful at English until I manually learned the grammatical rules), trying to learn grammar through just using it was...ugh, no me gusta. They also don't really explain anything - get something wrong, they just correct it.
Overall, I switched to just book-reading and fidning resources online.
