Work-based content

Competencies

# Learning outcome Competency Action
# 1 Learning outcome 1,2 Competency

Creation of a relational database in 3rd normal form, including appropriate data typing, precision

and the use of structured coding schemes

Action View
# 2 Learning outcome 2 Competency

Analyse requirements and produce database schema, understanding information access profiles and indexing

Action View
# 3 Learning outcome 1 Competency

Implement a disaster recovery strategy, including resilience security backup and production of both Disaster Recovery (DR) and Business Continuity (BC) plans

Action View
# 4 Learning outcome 1 Competency

Risk assess a commercially supplied database supplied as part of a clinical system, including Disaster Recovery (DR) and Business Continuity (BC) planning

Action View
# 5 Learning outcome 2,3 Competency

Through use of data mining or modelling tools on a large or complex data set critically evaluate their potential value to the clinical service

Action View
# 6 Learning outcome 2,3 Competency

Summarise data from a large or complex data set and present the results

Action View
# 7 Learning outcome 4 Competency

Construct a computational model of a physiological or biological process and interpret the output

Action View
# 8 Learning outcome 4 Competency

Validate the operation of a commercial/open source physiological or biological model

Action View

Assessments

You must complete:

  • 4 case-based discussion(s)
  • 3 of the following DOPS/ OCEs:
Create a script to parse a large text file and output a small specified subset of data. DOPS
Write a set of unit tests to evaluate whether the output of a script (or set if functions) is correct, including edge cases. . DOPS
Construct a script using OO methods to parse data. DOPS

Learning outcomes

  1. Develop a database structure to meet a clinical need
  2. Implement SQL and data mining strategies on a large data set
  3. Summarise and present data from large datasets
  4. Develop models for biological systems, eg compartmental modelling in Nuclear Medicine