smartard

noun, a person who is smart in some things and retarded in others

a smartard may be very good in school however have no common sense