The majority of Year 10 pupils did not do any work experience last year, a report has suggested.