Stress in relation to the subject is still an issue but attitudes are improving, a survey of almost 6,500 pupils has found