Almost two-thirds of teachers said sports stars were the type of celebrity most pupils wanted to emulate while more than half of students wanted to be pop stars.