UCL (University College London) is London’s leading multidisciplinary university, with 11000 staff, 35000 students and an annual income of over £1bn.

The Brief

Funding from the MRC and the Wellcome Trust enabled UCL to run a project to collect weekly survey data from 10,000 individuals around the UK. The brief was to create an online system to make this data easy to collect and report on.

[vcex_icon_box style=”two” alignment=”center” heading=”What we did:” icon=”fa fa-check”]

Design, develop and host an online survey system for 10,000 UK residents.

[vcex_icon_box style=”two” alignment=”center” heading=”What we used:” icon=”fa fa-cog”]

SQL Server, asp.net, C#, IVR

[vcex_icon_box style=”two” alignment=”center” heading=”The Result:” icon=”fa fa-bar-chart”]

Successful research project delivered and funding renewed.


The Work

We created a system that allows people to take part in the surveys using a web-browser, by an automated phone service (IVR) or from other systems through ‘connectors’. Families are signed up by GP practices and given a login to the system to set up their details. They then system then automatically calls them every week and leads them through a series of questions.

This data is collected in a SQL Server Database, with UCL being able to monitor the results in real time and adjust the survey if needed.

A suite of reports is then available to allow UCL to analyse the results and map how influenza outbreaks spreads across the country over time.

The Reaction

The project was hugely successful in helping researchers understand how influenza spreads. This data is being used to create models for dealing with major outbreaks, particularly of avian flu. Funding was renewed on the back of the work.

Find out more about our SQL server database services.