Chris Turnbull is another forum poster who has done a lot of visualization of GCSE data, hopefully this will ping him and he can help.
Alternatively, posting either a spreadsheet or a package workbook (.twbx) with some sample data would be useful.
I have done a fair bit of work with School Data and have achieved quite a lot due to the help of Jonathan and Richard Leeke.
If you can wait till later in the week I can Pass on that help (I have a deadline on Tuesday - where I will be demonstrating the Tableau Tools we will be using next year to the SLT).
The above example is easy enough in Tableau but may not be the best way to put it together as you could have 20 or so subjects as columns with some of them blank as the student do not study that course. We can discuss the options later this week if that is ok.
What MIS are you using? Where do you get the above Data from?
We use SIMS and I drag the Data straight from Assessment Manager.