Creating school websites with SharePoint part 5. Using the power of SharePoint lists.

In this final session on SharePoint websites I have used an extract from a paper I did with Chris Mckinley, one of our developers. This looks at how SharePoint lists are used to create Prospectus and Open Morning bookin and the 6th Form Application process.

The request prospectus page and the book an open morning page are custom SharePoint lists. The prospectus request form sends the data to then list then takes them to the pdf download. The page itself was created using the site actions menu. A layout was select with a content region on the left and a webpart zone on the right. This allows the text to me modified quickly from the browser. The form the end user fills out was created as an xslt data view in sharepoint designer and then exported as a webpart. Unlike the latest news where the whole page was created in sharepoint designer and rendered one list the approach of creating a form webpart was used to enable easy editing of the text on the left of the page.  

The book an open morning page is very similar to the prospectus request page. One extra feature is the inclusion of a lookup column in the custom list. The field looks up date values from another list. This allows easy management of the dates as more can be added by admin staff simply by adding items to a list. The other way to do this would be to use a choice data type for the list but this approach would require the lists column settings to be modified each time a new data is added, editing the lists setting is something we wanted admin staff to avoid. Adding an item to a second list is a much easier and safer way of managing things.

We also use the SharePoint Alerts feature on the lists to notify the 6th form office staff that someone has expressed an interest in the 6th Form. This integration with Exchange 2007 means that the information is presented quickly to the relevant people without the need to constantly check another admin page for new content. By emailing out the alerts rather than relying on one member of staff to check an admin page gives us some human fault tolerance. If prospectus requests were only added to a list and the staff member dealing with the list was long term absent then data could be added to the list and not auctioned. With email alerts, an absent staff member would usually have mail redirected to a colleague, instantly bring the colleagues attention to the data in the list enabling it to be dealt with immediately.

Open morning back end

The application form opens in a new window. The application form is a custom SharePoint list containing many of the useful column types such as rich text areas for personal statements as well as date formatting to ensure reliability of data. There are also lookup fields with other lists such as the ‘Current School’, again allowing for admin staff to maintain the lookup data. The ‘Ethnic Origin’ column reads data directly from our MIS, this enables the dropdown list to be dynamic and contain only valid data. The application form was built in sharepoint designer and many of the fields could be simply dropped in. The ethnic origin field, as mentioned above, reads directly from our MIS. This is done by an SQL connection on the field to our MIS server where the data is pulled across. The data is pulled across using a stored procedure running as a specific user with very low privileges, just enough to read the required data, this ensures that the database connection cannot be used for malicious traffic.

We chose the approach of reading this data from another database because the MIS system automatically keeps the list of ethnic origins and the identifier codes up-to-data, something that would be impossible to manage with other sharepoint lists or lookup values. If the person filling out the form is a current Twynham student then we ask for their computer login number. This will then allow us to tie the person into our existing systems for viewing pupil data, this is done during the interview process.

Try and Download SharePoint Add-ons

Creating school websites with SharePoint part 4. Creating subject portfolios and student rich media.

Click here to see the first part in this series on creating SharePoint websites

Click here to see the second part in this series on creating SharePoint websites

Click here to see the third part in this series on creating SharePoint websites


 In the last session we finished with a shot of the courses carousel which is shown below and can be seen live here

When students select a subject from the carousel they are taken to the subject home page which consists of a brief introduction, more detailed course information and a video which are all shown below. These videos were taken for every subject showing a year 13 student giving an overview of the course and explanation the Twynham 6th Form experience.

This post and the rest of our work at Twynham School is available in an E-book called

Twynham School Learning Gateway 2007-10 which can be downloaded here

The subject home page

The subject course information page


The subject student feedback page

Creating school websites with SharePoint part 3. Creating beautiful ‘non-sharepointy’ looking sites.

Click here to see the first part in this series on creating SharePoint websites

Click here to see the second part in this series on creating SharePoint websites

One of the real challenges with SharePoint is how do you make it look beautiful like many normal websites? This is an area we wanted to develop and the decision to make a new, more visual and edgy site to engage older teenagers in June 2009 gave us an opportunity. As with our main site the 6th form site was designed by an external agency but this time there was a greater focus on working with our existing A-level students to find out what would appeal to them. The results are shown below and the site can be found at

This post and the rest of our work at Twynham School is available in an E-book called

Twynham School Learning Gateway 2007-10 which can be downloaded here

The site is far from traditional with a top and bottom navigation with a large central zone for high quality visual images. These images rotate in a loop covering the key areas shown in the bottom navigation. The top navigation is largely administrative, allowing students to book open mornings, request prospectuses and most importantly apply to the sixth form.

The main engine of the 6th Form website is the subject areas which allow students to make decisions on their A-level choices. The start of the process is the carousel shown below which displays the subject list visually.

Creating school websites with SharePoint part 2. Easy editing of pages.

Click here to see the first part in this series on creating SharePoint websites

Perhaps the most powerful argument for schools who have SharePoint as a Learning Platform to move their website over is the benefits of cost and time. Using SharePoint to produce websites means that key areas such as latest news can be updated without any technical skill. The image bellows shows a simple interface for adding text and images which is as easy as adding to a word document.

When this is completed the latest news appears instantly on the page. This role has recently moved over to the Headteachers PA instead of a member of staff from the IT team which ensures that valuable technical expertise is not used on administrative tasks. In addition to latest news, job vacancies can be added in minutes without waiting for a response from the technical team.

This post and the rest of our work at Twynham School is available in an E-book called

Twynham School Learning Gateway 2007-10 which can be downloaded here

Creating school websites with SharePoint part 1

During 2008 and 2009 we have moved beyond the creation of internal Learning Gateways to the creation of external anonymous access websites. The first project was our main school website which was being redesigned in the summer of 2008. Moving the site into our SharePoint set up was a big challenge but the benefits for many schools are clear as they can save in hosting costs. More importantly moving websites into SharePoint allows them to be updated by chosen end users without the need for developers. As soon as the design was completed by an external team our SharePoint team set about creating master pages to produce the website which can be seen below.

This post and the rest of our work at Twynham School is available in an E-book called

Twynham School Learning Gateway 2007-10 which can be downloaded here

The main changes to the website design were aimed to create a much more visual site with a greater use of images. At the same time, with the creation of gateway and in particular the Parent Gateway it was possible to slim the overall content of the site out and move this to the internal gateways. The key change within the school was to move from seeing the website as a place for all information to seeing the website as an extension of our prospectus for future parents and students.

In addition to this the site is the key point of entry to the internal gateways. Staff, students and parents click on their relevant site and are taken to a login page which takes them directly to their personalised page. The website can be found at

The student zone contains a video tour from current year 7 students for year 6 students to get a feel for what life at Twynham School is like.

Key processes for the school including the admissions process are all made available to parents through the website.

The importance of Student Design in shaping your SharePoint Learning Gateway- E-book serialisation.

The other recent example from the Student Council is the recent work they have done on the design of our reward system. Student’s recently presented their views on how we could use the Learning Gateways to make the system more relevant, engaging and appealing. The image below shows a balsamiq mock-up they have completed to show how the system should look and work.

This post and the rest of our work at Twynham School is available in an E-book called

Twynham School Learning Gateway 2007-10 which can be downloaded here

This second image shows the navigation for the system.

Try and Download SharePoint Add-ons

The importance of Student Voice in building your SharePoint Learning Gateway- E-book serialisation.

One of the reasons we have been able to keep making progress with our Learning Gateway has been the continual evolution of the system. Central to this has been the constant feedback from staff and parents but, most importantly, the students. As you will have seen earlier we run Student Council groups throughout the year focusing on culture, teaching and learning and technology. All three of these groups have impacted on the Learning Gateway throughout the last three years. Very recently the Headteacher of Twynham School, Dr Terry Fish and myself were given presentations by the culture and technology group to make two key recommendations.

The first was from the technology group with a series of recommendations of how we can further improve the Student Gateway. The document they produced from 6 thirty minute meetings is below and it shows the level of thought they have undertaken.

This post and the rest of our work at Twynham School is available in an E-book called

Twynham School Learning Gateway 2007-10 which can be downloaded here

These recommendations where produced by between 12 and 20 students at each meeting but in turn they use tutor captains to take feedback from all students. This process ensures that the information coming back from students effectively reflects their views as a whole. We are able to further support this process by using surveys within SharePoint which can be named or anonymous and compulsory or voluntary. During the last three years we have used these for a wider number of issues including decisions on study leave and feedback on the quality of learning within departments. The regular reflection allows us to ensure that the Learning Gateways are always evolving in line with student expectations.
Try and Download SharePoint Add-ons

Speaking on SharePoint and the Learning Gateway at SharePoint Saturday DC #SPSDC

I am pleased to announce that I will be speaking at SharePoint Saturday in Washington DC with my good friend Dave Coleman on Saturday 15th May. We will be speaking on ‘Creating an effective and highly developed Learning Gateway for education with SharePoint 2007 and 2010′.  We will be picking out most of the themes from my recently released E-book and also launching our SharePoint 2010 demo site which we hope will be useful for both educational and non-educational institutions.

As well as this I hope to have a few new web parts to give away so try to come along and say hello.

E-book version 1.1 now available with slideshare and webparts details!

Version 1.1. 25th March 2010 available here

Just a quick blog to update you on the development of the E-book which I launched on Monday. Thank you for all the feedback I have received so far which has been really helpful. I have made some minor updates and cleaned out a few spellings and font changes. In terms of the two biggest changes they are as follows:

The E-book is now available through Slideshare.I am conscious that many people have come back saying to download from Scribd they need an account and it is not as popular as Slideshare. It now appears on the E-book v1.1. page in both Scribd and Slideshare.

Details on the free Picture Viewer web part. In January we made our Picture Viewer web part available at BETT for all visitors. This is now available to anyone who via the blog. See page 43 of the E-book for further details!

E-book launch and three year anniversary of Twynham School SharePoint Learning Gateway

As a number of you will know over the last month I have been serialising parts of an E-book I have been writing. The E-book entitled Twynham School Learning Gateway 2007-10 is launched today, exactly three years from the first piece of work we did with SharePoint at Twynham School.

Over the last three weeks I have managed to cover the first 5 Chapters of the book which now reaches to 7 Chapters and 6,000 words. With over 60 screen shots the E-book is very much a visual illustation of our work so far.

To download or read the E-book simply click here

I hope you find it of some use and please do pass it on to others as one example of what schools are doing with a Learning Platform.