You are here: Home / Archives for Projects

UK Aspirin Survey supported by 2and7 Limited

January 23, 2012 By

Members of 2and7 Limited have recently delivered a form for testing for a UK wide census on the use of aspirin and clopidogrel in orthopedic surgery. The form was coded in Microsoft InfoPath 2010 and is implemented using the latest version of Microsoft’s SharePoint cloud solution, Office 365.

Although relatively simple, the form required the development of a number of bespoke rules to ensure that all required fields were completed and to hide/show form elements depending upon previous answers. 2and7 Limited also developed specialised workflows to undertake a number of post processing tasks once the forms were submitted and notifying the census leaders of the existence of new forms.

The final part of the equation will be collating the form results into a single Microsoft Excel 2010 spreadsheet for subsequent analysis as well as feeding the data into a back end Microsoft SQL Server database to provide the potential for a longitudinal study.

2and7 Limited are experts at the delivery of electronic data collection, records management and document management systems for all sizes of business.  Specialising in medical research and healthcare, our systems are scaleable to cope with any size of business using a mixture of hosted, on site and cloud hosted systems.

Share
Filed Under: Data Collection, SharePoint Tagged With: , , , ,

Lipoma Questionnaire

August 26, 2011 By

We have recently designed and published a bespoke data collection form for surgeons at Leeds Teaching Hospitals NHS Trust.  The data collection form was written in Microsoft InfoPath 2010 as a browser based form utilising a cloud based SharePoint solution provided by Microsoft Office 365.

Once development costs have been paid, the system costs £15.75 per user per month to run and makes use of Microsoft’s cloud based services to guarantee availability of the system.  The results XML forms will then be transformed and combined into a Microsoft Excel 2010 workbook for analysis, though we can also offer hosted Microsoft SharePoint solutions that shred data directly into a SQL Server database.

The system is currently under testing and should be available to the survey group within the coming weeks.

Share
Filed Under: Data Collection

Data Cleansing and Validation

April 9, 2011 By

As well as developing data collection systems, 2and7 Limited are also experts in data entry, validation and cleansing. An often overlooked aspect of any research project, we can undertake a number of exercises to determine the degree of data validation required to ensure the validity of your research project findings.

Team members have previous and current experience of working within clinical and academic environments, being full conversant with medical terminology and having many years experience in this field across a number of organisations.

Services offered include:
* Transposing data from paper to electronic forms
* Validation of electronic data sets against original data workbooks
* Validation of data capture forms against the original ethics approval and project protocol
* Patient matching across multiple data sets to enable longitudinal data analysis
* The merging of seemingly disparate data sets into a cohesive patient data warehouse

We also offer a range of bespoke services depending upon the individual need of your project or department.

Share
Filed Under: Projects Tagged With: , , , , ,

Cardiovascular Research Data Collection System

April 9, 2011 By

2and7 Limited have been asked to support a new medical research project which is looking to improve the lifestyles and health of patients with cardiovascular disease (CVD). The system will support the electronic collection of data directly within the clinical consultation and the subsequent presentation of this discrete data in a longitudinal view thereby allowing the investigation of the individual patient disease pathway and wider condition development.

The system also provides a patient portal through which clinicians and patients recruited onto the study can share information and patients can keep an online exercise and dietary diary which will feed into the clinical information system.

There is also the potential to publish data back to the patient portal from the clinical information system to encourage self management and to allow patients to view the study data currently held about them.

The system will be delivered via a combination of Microsoft InfoPath, Microsoft SharePoint Server 2010, SQL Server 2008 and bespoke web site/web service development.

Share
Filed Under: Application Development, Projects, SharePoint, Web Site Development Tagged With: , ,

Stadium Entry System

April 9, 2011 By

2and7 Limited have recently completed a project to make amendments to an existing gate admissions system developed using Microsoft Visual Basic for the user interface and Microsoft Access as the database engine.

The system was no longer fit for purpose, as it was not possible to co-ordinate and share information across all entry gates, raising the possibility of using the same card to enter the ground on multiple occasions. The system was also unable to support any flexibility in season ticket subscriptions.

The first stage of the process was therefore to migrate the backend database onto Microsoft SQL Server Express, removing unnecessary fields and improving the performance of the database. The improved capabilities of SQL Server also provided a more robust database engine through which to co-ordinate all entry gates.

The next stage was to increase the functionality of the system to allow a number of credits to be associated with a particular season ticket record, thereby enabling special offers to be introduced and partial season tickets to be sold throughout the year thereby increasing revenue. There are plans to further enhance this aspect of the system by also allowing the system to differentiate between league and cup games to allow for league only season tickets to be sold.

The final improvements were to the administration and reporting systems. The administration console was improved to allow the management of credits plus the application used on the gates was also extended to show the number of credits left on the card. Finally, ODBC links were created to expose the underlying data to Microsoft Excel for analysis whilst formal reports were requested via SQL Server Reporting Services.

Further improvements in the pipeline include the aggregation of data into a formal customer relationship management application which will be provided under our SPLA licencing model, allowing the business to control their expenditure by only committing to licences on a monthly basis rather than having to purchase server and client access licences for all users.

Share
Filed Under: Application Development, Projects Tagged With: , ,
« Older Posts