Can Rosetta stone help me for Spanish?

Actually, a college cl will not help you except to understand the language in a technical way. It would be wiser to invest your time in speaking with native Spanish speakers. Rosetta Stone will help you increase basic vocabulary, but it will not make you semi-fluent. The only program I know that can make you semi-fluent is Michel Thomas' Spanish course.