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.