Reporting Services integration in SharePoint 1 of 6
Filed under: Reporting Services, SharePoint, Twynham School
One of the tools I have most wanted to talk about over the last few months but haven’t got to is Reporting Services. This is an astonishingly powerful tool for sharing and communicating key data in a school. At Twynham we have been using Reporting Services 2005 for 3 years to provide a rich stream of data which enables both teaching staff and middle and senior leaders to ensure our students are on track to fulfill their potential and make maximum progress. Since last summer we have taken our use of Reporting Services even further, fully integrating it within SharePoint. By publishing through ISA which we installed in October 2008 we are now able to access this tool both within school and externally over the Internet. Over the next 6 posts I will take you through the pyramid system we use in Reporting Services which enables us to move from analysis of whole school results to analysis of departments, classes and students in just 5 clicks.
From our staff home page all staff can directly access the data home page (see above) which ensures every teacher is free to look at any data without having to go to an administrator or middle/senior leader. This instant availability of data means all teachers take responsibility for their target setting within groups and are always aware of how students are performing. This week we have revamped the Home Page to dramatically reduce the number of clicks by using SharePoint lists. This is a work in progress and so only the most recent data and preparation for this summers results appears.
As a senior leader in a school having access to the headline figures from GCSE and A-level results or internal reviews the moment they appear on the system is a massive advantage. Senior Leaders simply click on the GCSE Headline or GCE Headline button for the relevant year and within a few seconds they have the following data at hand.
This table gives a rich range of data without being overwhelming so that Senior Leaders have an instant snapshot of how results look minutes after they have been downloaded from the exam boards. From this table you are faced with two options for further analysis without leaving the page. You can select a previous year from the drop down bar at the top of the page to compare current results over time. Alternatively you can drill into this current year group’s results to look at how all departments are performing. In part two I will cover the drill down into departments.