Reporting Services Integration in SharePoint 6 of 6

To wrap up this session on integrating Reporting Services in SharePoint I thought I would run a demo showing all 5 stages of the data analysis package we have produced using a Camtasia video. Below you can see the transition from GCSE Headline to All Department Analysis, Department Level Analysis, Class Level Analysis and Student Level Analysis.

For best viewing of the video please enlarge!
 

Reporting Services is an extraordinarily powerful tool to support teachers and middle/senior leaders in making accurate judgments and reflecting on outcomes in public examinations. It would be interesting to hear from people who are using Reporting Services 2008 to find out how usable it is for the end user. Reporting Services 2005 is definitely something that requires a lot of in-depth knowledge about and we are very grateful to our Senior SQL Developer Chris Mckinley for building this powerful tool.

Reporting Services Integration in SharePoint 5 of 6

Having reached the class level of our data analysis tool created in Reporting Services, teachers are able to complete their analysis in September with a rich vein of data shown below.

Individual Class Analysis

Individual Class Analysis

When teachers look at those students who underperformed in their subject one of the most important questions is why. This could of course be obvious to the teacher as the student lacked motivation, had poor attendance or did not complete the exam properly. One other factor could be that the student underperformed across the board in their exams. How does a teacher find this out? Using our data analysis tool the teacher can simply click on the name of the student whose results they want to look at and the appear as shown below:

Student level analysis- click to enlarge

Student level analysis- click to enlarge

In the table above the student has strengths in Maths and Science but their performance is lower in more literate subjects which may explain their lower performance in History. The key of course is that the Reporting Services tool allows teachers to undertake this form of investigation easily and in a few clicks.

Reporting Services Integration in SharePoint 4 of 6

Moving into Middle Leader and Class teacher analysis, yesterday we were looking at the department table which is pulled through Reporting Services into SharePoint. This is shown below and enables the Head of Department and Line Manager to examine differences in outcomes between individual classes.

At this stage the Head of Department may want to drill into an individual class to look at the reasons for particularly strong or weak outcomes. They can do this simply by clicking on the class code on the right side of the table above. What appears next is a very powerful page for discussion between Heads of Department and Class teacher which can be seen below.

Individual Class Analysis- click to enlarge

Bear in mind that I have cropped out an area on the left side which contained the names of the students from this group. The table pulls through an excellent range of data for reflection including: prior attainment at Key Stage 2 and 3; review data from teacher judgements across KS4; forecast and target grades; GCSE outcomes and student points versus subject points and residuals which are then nationally adjusted. This then forms the basis of a class report written by teachers and is also a key document for Performance Management.

Reporting Services Integration in SharePoint 3 of 6

So far in this series we have being looking at the use of Reporting Services integrated into SharePoint for use by Senior Leaders to examine the performance at whole school and department level. Yesterday we looked at the All Subject analysis we do at Twynham School which is shown in the table below.

All Subject analysis in reporting services

All Subject analysis in reporting services

From here the tool we have produced is particularly useful for looking at differences in performance between classes. This is where the Subject Leader should be able to identify strengths and areas for improvement. By clicking on the department title in blue (image above) on the left side you arrive at the 3rd level of the pyramid of data- Class level.

Class level analysis- click to enlarge

Class level analysis- click to enlarge

From here the Subject Leader can look at the overall spread of grades within each class, gender differences, A*-C and A*-A benchmarks and residuals which are also nationally adjusted. They may then wish to look at a particular class in detail to see where the strengths or weaknesses are coming from. I will show you how they do this tomorrow.

Reporting Services Integration in SharePoint 2 of 6

Yesterday we looked at accessing data directly from within SharePoint using the very powerful tool Reporting Services. At the top of the pyramid of data we had senior leaders (and indeed all members of staff) being able to quickly pull up Headline data shown in the table below.

The next stage for senior or middle leaders when results are in is to look at department level data to see how each department has performed. In the table above the top right corner contains the word GCSE. By clicking on this link a stage down in the pyramid appears- the department level analysis.

All subject analysis- click to enlarge

All subject analysis- click to enlarge

From here senior and middle leaders can look at the overall performance of departments across the A*-U range as well as the key indicators A*-A and A*-C. They can also see residuals which are then nationally adjusted on the far right to give a true reflection of relative performance. From here you can drill directly into individual classes to look at performance across a single department. This is something I will cover tomorrow.

Reporting Services integration in SharePoint 1 of 6

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.

Data home page- click to enlarge

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.

GCSE Headline- clcik to enlarge

GCSE Headline- clcik to enlarge

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.