Skip to main content

PenCHORD training courses

In partnership with the Aneurin Bevan Continuous Improvement Team at Cardiff University, PenCHORD have developed a training programme aimed at supporting staff within the NHS to:

  • Recognise the potential and limitations of modelling.
  • Understand modelling techniques and concepts.

  • Develop practical skills to enable them to develop Excel-based models within their own organisations.

  • Understand some key tools and techniques used to structure problems and be able to use these to develop structured questions to answer real-world complex problems.

As part of PenCLAHRCs capacity building initiative, this training is being offered free of charge to NHS staff within Somerset, Devon and Cornwall. To date, three connecting modules have been developed, along with a standalone problem structuring module (details below). Future modules are also planned and these will build into a complete suite of courses. For a brief introduction to our courses, download our flyer (pdf)

Watch our video for an overview of how modelling can benefit the NHS. 

MODULE 1 – Introduction to Excel-based Modelling in Health and Social Care

This is a full day module that introduces the concept of modelling, its potential and limitations, and guides participants through a hands-on practical session to build a simple model of an outpatient clinic.  Participants are then introduced to concepts such as “what if” analysis, in which models are reconfigured to predict the impact of different real world scenarios and the importance of considering variability in systems.

Learning Objectives:

  • Understand the concept of modelling, the broad range of applications of models and their limitations

  • Explain the potential role of models for decision making in health and social care

  • Develop and test a simple decision model in MS Excel

  • Understand how to use a simple Excel-based model for “what-if” analysis

  • Appreciate the importance of capturing variability when modelling systems

MODULE 2 : Geographic Modelling

Geographic modelling techniques provide vital decision support when deciding where to place services, or to predict the impact of service closure or geographic reconfiguration. Simple but effective geographic models can be built using a combination of Microsoft Excel and freely available software. In this module, students will learn how to build a geographic model to predict the impact of theoretical Minor Injury Unit closures in Cornwall.

Learning Objectives:

  • Understand the role and potential applications of geographic modelling

  • Obtain a batch of shortest driving distance and time calculations from a dataset containing patient and provider postcode data

  • Build a geographic model in Excel of the current service scenario

  • Use “What If” analysis to predict the impact of service closures

  • Visualise the results of geographic modelling using Google Fusion Tables

  • Understand how a geographic model could be built to assess the best place to locate services amongst a number of alternative options

Contact us

Upcoming Events

Feb
27

'Creating Engaging Oral Communications'

Exeter South Cloisters 3.06, Plymouth JBB MR8, Truro KSpa F1.

This seminar aims to explore how to create engaging oral presentations. Jointly delivered by Michelle Ryan from the...
More information

Mar
06

PPI Advice Clinic

The University of Exeter, St Luke's campus, South Cloisters

Patient and Public Involvement Clinic What? These clinics have been set up to help the PenCLAHRC PPI Team manage and respond...
More information

Calendar

News

Partner In Focus - South West Academic Health Science Network

17 January 2018

As a partnership of NHS Trusts across Devon, Cornwall and Somerset, plus the Universities of...
Read more

Members of PenCHORD team makes switch to Open Source working

15 December 2017

Members of PenCLAHRC's operational research team, PenCHORD, have been working towards transferring their work to Free Open Source Software (FOSS). Dr...
Read more

Using Implementation Science to drive health care change: The ASPIC project

14 December 2017

Understanding how to put effective health care into practice is an important part of the...
Read more

News

Research Projects

What are the effects of 'robopets' on the health and wellbeing of residents in care homes? A systematic review of qualitative and quantitative evidence

Theme: Mental Health & Dementia

A systematic review that aims to create a state-of-knowledge synthesis on the impact of robopet-human...
Read more

Supporting older people to manage their medicines: a scoping review of medicine self-management tools

Theme: Person-Centred Care

A scoping review that aims to identify what tools or resources are available for older...
Read more

Research Projects