The word Sophomore comes from two greek words: Sophos, meaning
wise, and Moros, meaning
fool. So it actually means "wise fool."
You can either be a sophomore in High School or College. In High School it refers to the 10th grade (in most school systems anyway). In College it's your second year.
The order of procession goes Freshman, Sophomore, Junior, Senior.