If you have loads of data to analyse then PowerPivot may be of use to you. It is a plugin for Excel 2010 and allows you to analyse very large sets of data, very rapidly, in real-time. The documenation suggests that you think of it as Excel PivotTables on steroids! The main advantage that it has over PivotTables is its ability to pull data from one database and match it against data from elsewhere.
So, if your school has pupil data in lots of different files and formats this may be the tool for you. It’s free, you just need to learn to use it and find its potential!