You can alter which way you look at data – by year, class, sex, teacher etc etc without changing the structure of your spreadsheet. Think of a pivot table as a layer of analysis on top of your data.
However, I find that I can’t explain the benefits of a pivot table without demonstrating them….. so, here’s a link to a Youtube clip I made for CPD at school.
(BTW, the names of students are not real before anyone contacts me )
Using pivot tables can shave hours off your exam analysis and can throw up relationships that you did not see before.
Putting this clip up made me think: What CPD can you share with the wider world?