Performance Analysis - How do you do it?
We currently have to break out to excel for our exam result analysis. This is because we have a high percentage of student who can legitimately be dis-applied from the headline statics, (High SEN, EAL and Mobility). As a result our MIS cannot give us A-C% (A-B% and A*-E% at KS5) from the perspectives we need and doesn't cope well with the complexity of the BTEC, OCR Nationals, Cambridge Technical. The MIS provider has also failed to solve this for us within their system.
We also have this problem for progress tracking throughout the school and need to filter / report against FSM, EAL, CATs, number of students in current cohort tat started in year 7 (i.e. a mobility metric). How do others build their reports?
This is not my specialist area, I've been asked to support our new data team and number one on our hit list is is a new MIS, however I suspect that what ever system we choose there will still be a need to break out into Excel. It would be really helpful to hear how others do it (vendors welcome to jump in, but no hard sell please!)