A sweeping review of Scotland’s school qualifications system has recommended significantly reducing how many exams students take, and giving more weight to non-academic achievements.