Online Reporting to Parents-Attendance Web parts

February 3, 2009 by · 1 Comment
Filed under: Online Reporting, SharePoint, Twynham School 

Yesterday I introduced our work developing Web parts for SharePoint 2007. After our first Web part, The ‘My Timetable’ Web part we moved on to looking at student attendance at school. This is a crucial area with government statistics showing a 15% drop in attendance (from 100%-85%) reduces a student’s GCSE outcome by 1 grade on average. To start with we wanted to show student attendance in morning and afternoon registration. Having learned a lot from their early Web part development Chris and Darren our developers managed to create a ‘My Tutor Time Attendance’ Web part within weeks. We have developed this work with Richard Willis from Salamander Soft to include headline statistics and the final product is here.

'My Attendance' Web part

As well tutor time attendance in June 2008 we had a request from our Sixth Form to produce a Web part for lessons. The main driver for this was the fact that our year 13 students are not always required to attend tutor time and so keeping tracks on them was proving difficult. Although most students were attending all the time some were slipping through the cracks and so an easy way of monitoring lesson attendance was essential. The result is shown below- ‘My lessons’ attendance.

My Lessons Attendance

My Lessons Attendance

The impact of these Web parts has been significant in the school. Tutors and Heads of Year as well as teachers are able to track students in the school and measure how often the attend lessons. Now that we have rolled this work out to students and parents we are able to encourage them to take responsibility for ensuring they are successful at school.

SharePoint Web Parts for Online Reporting to Parents

February 2, 2009 by · 4 Comments
Filed under: Online Reporting, SharePoint, Twynham School 

While I was at BETT in early January I was chatting to Alex Pearce from Great Barr School. He has a great blog and so I asked him for tips on my recent venture into writing a blog. He rightly pointed out that I really didn’t speak enough about SharePoint in Education which is my blog title! He is of course right and I do tend to get side tracked by technology in general but I hope to put his constructive criticism right during February. To start this I thought it would be good to share some of our work on creating Web Parts in SharePoint. In case you don’t know what a Web Part is and are new to SharePoint have a look at this handy guide in Wikipedia but in essence it is Microsoft’s version of a widget.

Twynham School started creating Web Parts all the way back in September 2007 soon after we had set up SharePoint 2007. Dave Coleman was (and is) a wise man and knew that this was the best way to help us develop our School Gateway and overcome data integration issues. He felt the challenge was really to make SharePoint the one-stop shop for staff and students to access everything they would need online. As a result we started work on pulling staff and students timetable data out of our MIS (Managment Information System) and into SharePoint. This was a mammoth undertaking for our two SQL/SharePoint developers Chris McKinley and Darren White but within half a term we had our first Web Part- The ‘My Timetable’ Web Part which can be seen below.

'My Timetable' Web part with subject highlight

The view above is a timetable for s student in year 11. The Timetable Web part appears on both the staff and student gateways and is driven by active directory. As a result it recognises the user logged in and pulls their timetable. We have made a number of refinments in the year since this Web part was made. Students and teachers can now hover over any class and it will highlight the other linked classes. You can also view the timetable in single day and one week/two week cycle. This Web part has been the first of many which we have made in 2008 and I will run through some of the others ones during this week. If you would like to look at all the work we have done take a look at our showcase site

« Previous Page