MODM Clinical Database Management
THE COURSE PROVIDES DUAL SKILLS IN CLINICAL RESEARCH AND PROJECT MANAGEMENT. IT TRAINS MANAGERS SPECIALIZED IN CLINICAL RESEARCH: CLINICAL DATA MANAGERS
OBJECTIVES
The aim is to train managers specializing in Clinical Data Management, and to promote their rapid employability through academic and work-study training. Specialization in Master 2.
SPECIFIC KNOWLEDGE PROVIDED BY THE COURSE
- Clinical trial monitoring and logistics
- Essential ICH documents for the conduct of trials (before, during and at the end of the trial). RGPD in Clinical Research
- SAS, SQL and R programming
- Designing the database from the CRF
- Quality control, data validation, coding and dictionaries, laboratory data, base gel
- CDISC and SDTM standards, Risk Based Monitoring
- Outsourcing in Data Management
- Use of professional software
SPECIFIC SKILLS PROVIDED BY THE COURSE
- ARC competence in M1
- Set up a clinical database in compliance with CDISC recommendations and regulations
- Ability to define the necessary consistency checks to guarantee a reliable database that complies with the test protocol
- Program these consistency checks using professional SAS software.
- Identifying and managing risks
- Plan and carry out all the quality control steps required to obtain a clean database
TEACHING RESOURCES AND PROFESSIONAL EXPERIENCE
- Since the start of the 2021 academic year, practical teaching and the APP have been carried out on the Viedoc eCRF, thanks to close collaboration between the course and the Viedoc team.
- Educational space for 3D printing in healthcare. Learning Lab, flipped courses, interactive seminars, company visits, project-based learning...
- Numerous professional guest speakers
- M1 + M2 open to apprenticeships, schedules adapted to optimize practical training
CAREER OPPORTUNITIES
DATA MANAGER IN: CRO - Pharmaceutical laboratories - Academic structures
IN THE SECTORS: Pharmaceutical, veterinary, nutrition or medical devices
Students in the Master 2 MODM Clinical Database Management program explain their educational choices and their vision for the future.
MASTER 1
- SEMESTER 1
COMMON CORE (S1)
TU PAM1ARFQ - Regulatory and financial aspects, Quality and safety
Number ECTS = 5 - Responsible TU : Béatrice BAÑULS
Prerequisites:
Introduction to Law desirable but not required
The essential principles of Quality Management
Marketing
Understanding the role of marketing and the analytical aspect (various market studies)
Financial analysis
Know at least the company's accounts and the role of related items (balance sheet and income statement).
Content and objectives ofTU :
Pharmaceutical law(18h CM in common with Master Sciences du médicament)
Environnement Juridique du Médicament (1h)
Les Produits de Sante : Notions et Régimes (1h)
Etablissements Pharmaceutiques (2h)
AMM UNION EUROPEENNE (médicaments particuliers) (3H)
AMM HORS TU et CTD (3H)
Pharmacovigilance (2H)
Prix remboursement (2H)
Publicité (2H)
Propriété industrielle (2H)
Know the different texts applicable to the field of drugs, their origin, their legal value, their articulation.
Understand the concepts of different health products
Understand the basic framework for protecting innovation, manufacturing, marketing and monitoring drugs.
Marketing: 9h CM
The global marketing approach
Reminder of market research
Diagnostic tools and strategic orientations
Integrate the global marketing approach
Know the diagnostic tools and strategic orientations
Financial analysis: 6h CM + 3h TD
Introduction to financial analysis
Principle of comparative analysis
The different ratios: financial, economic, cash flow
Know how to analyze the profitability, solvency and liquidity of an economic activity (industrial company).
Quality Management: 12 hCM + 3 h TD (in common with Master Sciences du médicament except course 3)
Within the framework of quality management in companies, based on Good Practices and ISO standards:
1. Reminder of the basics of Quality Systems and corporate organization and documentation (3h)
2. Quality Control and Quality Assurance (2h)
3. Qualification and Validation: Control of equipment/software and production processes (2 X 1.5h as for Master IS)
4. Management of deviations and non-conformities (2h)
5. Continuous improvement: Corrective and preventive actions (2h)
3h TD: Non-conformity - CAPA
Safety: 6 hrs CM
Introduction to ICPE
Corporate social responsibility: protecting workers and the environment
Safety data sheets and classification of hazardous substances and products: key elements of CSR
Teaching methods:
Marketing and Financial Analysis
Lectures with student interaction through the content and examples provided.
Specific questioning on each part covered.
TU PAM1BADO - Databases - Epidemiology and Health-Environment
Number ECTS = 5 - Responsible TU : Hélène FENET -Aurélie ESCANDE - Patrice RAVEL
Epidemiology:Health indicators, descriptive, etiological and evaluative epidemiology
Health-Environment:Structuring of public health, national and regional management of environmental health through public health plans, corporate social responsibility, description and behavior of different types of pollutants at environmental and health risk, examples of problematic contaminants for health.
Databases:Relational model, simple SQL queries, table creation, constraint management, data import, form creation, report creation, macro creation and use of VBA in ACCESS™.
The student must acquire the skills to be able to
→Apprehendepidemiological studies:
Identify epidemiology as a public health tool
Know the tools of epidemiological surveillance
Know the different types of epidemiological surveys
Know how to interpret descriptive epidemiology indicators
Know how to calculate and interpret the results of risk calculations (RR and OR) from analytical epidemiology
Know how to describe and criticize strategies, study protocols used in epidemiology
Be able to assess the validity of screening tests
→Knowthe behavior and impacts of pollutants on health and the management tools in legislation (through examples)
Discover public health management in France,
Recognize the stakes involved in environmental health
→Discoverthe basics of database management
Understand how Information is structured using the relational model
Recognize the different ways of using databases (Administrator/client)
Build a database with a few tables
Be able to define the main constraints on a database
Be able to use the main SQL language commands.
Be autonomous on the ACCESS data management system (Microsoft)
TU PAM1SDPS - Healthcare Product Development Strategy, Project Management and Clinical Development
Number ECTS = 5 - Responsible TU : Xavier GARRIC
Prerequisites: General knowledge of biology, chemistry and galenic pharmacy
Content and objectives of theTU : 44H C
Healthcare product development strategy and industrial environment: 29h CM :
- General knowledge of the pharmaceutical, cosmetology and medical device sectors
- Knowledge of the regulatory and socio-economic specificities of the pharmaceutical, cosmetology and medical device sectors
- Ethics in healthcare
- Functioning and culture of healthcare companies
Project management: 3h CM
- Introduction to health product development project management
Clinical development: 12h CM
- Introduction to the conduct of clinical trials in compliance with Good Clinical Practice (GCP)
- Drug development
- Clinical trial methodology
- The standard design of a clinical trial protocol
Teaching methods:
Lectures focusing on popularization, with the emphasis on exchanges with students
Tutorials using computerized project management tools
TU PAM1BIAP - Biotechnologies applied to health
Number of ECTS = 5 - Responsible TU : Armelle CHOQUET & Arnault GRAINDORGE
Prerequisites: Knowledge of molecular and cellular biology (L3 level)
TU : 22h CM + 6h TD + 22h TP
CM
- Identification of molecular or cellular targets (Introduction=2h, -omics approaches=2h) and notions of biomarkers=2h (6h)
- Recombinant DNA technology=2h, CRISPR-Cas=2h, synthetic biology (2h): (6h)
- Industrial applications/examples: proteins, antibodies and vaccines (5h); optimization of biomedicines (2h), contemporary biotechnologies (3h). (10h)
TD
- Recombinant DNA, virtual cloning (6h)
Practical work
- TP1 => Cloning, production, purification and characterization of a recombinant protein (12h)
- TP2 => Setting up a cell model for medium-throughput screening (10h)
Objectives:
Learn about the various health products derived from biotechnologies
Acquire notions of therapeutic targets and biomarkers
Acquire notions of medium- and high-throughput screening
Learn about recombinant DNA, molecular biology and synthetic biology technologies
Gain a practical insight into the conditions for producing a recombinant protein and developing a cellular model compatible with medium-throughput screening (practical work).
Teaching methods:
The format of this TU course, with its strong emphasis on practical workshops and examples, should enable students to acquire a fairly precise vision of the use of biotechnologies in healthcare and industry in general.
TU PAM1LVCO - Modern Languages and Communication
Number ECTS = 5 - Responsible TU : Gregory NICKSON and Béatrice BANULS
Prerequisite: BAC level
TU Content and objectives:
Modern languages: 40h TD
Develop communication skills in a foreign language.
Specialized vocabulary.
Knowledge of companies and health issues in the target language countries.
Cultural approach.
Communication: 9h TD
Know how to work in a team and position yourself within a group.
Notion of group dynamics and team cohesion.
Communicate effectively, listen actively and share ideas (techniques, modes and networks).
Establish constructive professional relationships (attitudes and postures); collaboration and consultation.
Negotiation techniques
TD Bibliography: 3h TD
Use the bibliographic resources of a university library
Produce a relevant bibliography on scientific subjects
Teaching methods:
Job interview simulation, oral presentation with PowerPoint, meeting simulation, letter and e-mail writing, debates, document reading etc....
Practical work on the different skills (written and oral comprehension/expression)
TOEIC practice
Methodological aspects (according to group needs)
Exercises on digital platform to review and consolidate knowledge of the language.
Communication: test, exercises, role play
TU SPECIFIC: CLINICAL OPERATIONS MANAGEMENT and DATA MANAGEMENT (S1)
TU PAM1AXET: THERAPEUTIC APPROACHES - PHARMACOKINETICS - PEC
Number of ECTS = 5 - Responsible TU : Patrice Ravel
Prerequisites: Physiology program (Bachelor's degree), knowledge of clinical trial procedures
Modalities: 43.5h CM + 6h TD
Objectives
- Provide students intending to work in clinical research with a basic knowledge of the various therapeutic areas covered by clinical studies.
- Understanding the pharmacokinetic file
- Oral and written presentation skills
CONTENTS of theTU
THERAPEUTIC APPROACHES
Oncology, Cardiovascular, CNS, Pneumology, Thrombosis, Diabetes, Hypertension, Hematology, Rheumatology, Psychiatry, Analgesics, Malaria, Infectiology, Vaccine trials, Medical device trials
PHARMACOKINETICS
Definition of the main variables involved in Phase 1 clinical development
PEC
Oral presentations by English and French students
CV and cover letter proofreading
Teaching methods :
Lectures and tutorials
-SEMESTER 2
COMMON CORE (S2)
PAM1S2LV - English and 2nd language
Number of ECTS = 5 -
Responsible TU : Caroline WEMYSS and Peter WEINMANN
Prerequisite: BAC level
Content and objectives ofTU :
Work on all communication skills: written and oral expression and comprehension
Knowledge of the international professional and cultural environment
Job interview simulation, oral presentation with PowerPoint, meeting simulation, letter and e-mail writing, debates, document reading, etc.
Methodological aspects (according to group needs)
Exercises on digital platform to review and consolidate knowledge of the language.
Develop communication skills in a foreign language.
Specialized vocabulary
Knowledge of business and health issues in the target language countries
Cultural approach
Teaching methods :
Work on all communication skills: written and oral expression and comprehension
Knowledge of the international professional and cultural environment
Job interview simulation, oral presentation with PowerPoint, meeting simulation, letter and e-mail writing, debates, document reading, etc.
Methodological aspects (according to group needs)
Exercises on digital platform to review and consolidate knowledge of the language
PAM1S2ST - 3 to 5 month work placement
Number ECTS = 10 - Responsible TU :Béatrice BAÑULS
Prerequisites:
Completion of at least one internship in the Bachelor's program
TU from the Master 1 core curriculum and specific to each pathway
Content and objectives ofTU :
2h CM: preparation and instructions for finding and carrying out an internship
3 to 5 months full-time in a public or private company.
Apply the knowledge acquired during the training
Carry out a concrete professional project in the context of its activities
Teaching methods :
Written report , Oral test, Internship supervisor's assessment
TU SPECIFIC: CLINICAL OPERATIONS MANAGEMENT and DATA MANAGEMENT (S2)
TU PAM1MON: CLINICAL TRIAL MONITORING AND LOGISTICS
Number of ECTS = 5
Essential prerequisites: TU cannot be dissociated from the other TU courses.
Objectives
- Provide students intending to become Clinical Research Associates with the basic knowledge needed to set up and monitor clinical trials in line with good clinical practice.
- Define the different phases of clinical trials.
- Present the job of Clinical Research Associate (CRA) and all its missions.
Contents
Phase I, II, III clinical trials
Clinical trial monitoring and logistics
- Trial set-up, protocol, observation notebook, e-CRF,
- Follow-up of monitoring visits from the 1st visit to the closing visit.
- Investigators: recruitment, training, brochures
- Essential documents for conducting tests (before, during and at the end of the test)
- Documents for submission to HAS (ANSM, CPP, CNIL, etc.)
- Clinical batch distribution
The players and professions involved in clinical research
- The Arc laboratory/ Arc hospital profession
- Structures involved in clinical research (CIC, URC, CRC, CRB, etc.),
Bioequivalence tests
- Medical device testing
Hospital internship (4 weeks)
TU PAM1AFRE: REGULATORY AFFAIRS, BPC, PHARMACOVIGILANCE
Number of ECTS = 5
Essential prerequisites: This TU cannot be dissociated from the other TU courses.
Modalities : 32 h CM + 6h CM +3h TD
Objectives
- To provide students intending to work in Clinical Research and Development with basic knowledge of the regulatory environment.
- Mastering Good Clinical Practice - standardization ICH, CTD, FDA, EMEA, ANSM, CPP ...
- Acquire the basics of pharmacovigilance and adverse reactions.
- Give the basics of clinical trial planning.
Contents
- Regulatory environment for clinical trials
- Good clinical practice - standardization ICH, CTD, FDA, EMEA, ANSM, CPP, ...
- Quality assurance and quality control in clinical research and auditing
- Pharmacovigilance, serious and non-serious adverse reactions
- Operational planning
Teaching methods :
- Lectures, tutorials and projects supervised by professionals.
TU PAM1DATA: INTRODUCTION TO CLINICAL DATABASE MANAGEMENT - DATA MANAGEMENT
Number of ECTS=5
Prerequisite:
This TU cannot be dissociated from the other TU courses.
Statistics prerequisite: L3 Health Engineering level.
Objectives
- Introduction to clinical database management (Data Management)
- Know how to create a database from a CRF, and understand the main data quality controls.
- Learn about Data Management and the main tasks of a Data Manager.
- Know the different tools for entering source data.
- Master the basics of statistical analysis applied to clinical trials.
Contents
Data Management
- Definition and missions of a Data Manager
- Database structure, data quality control, freeze base
Introduction to SAS language
- Create tables, import data files, use simple procedures for statistical analysis of clinical data.
Statistical methodology applied to clinical research
- Statistics reminder
- Experimental designs: parallel designs, matched series designs, cross-over designs, bioequivalence tests
Epidemiological studies
Medical writing
Teaching methods :
- CM, TD, TP, and implementation of lessons through a tutored project on ACCESS
- Practical work with SAS software
MASTER 2
- SEMESTER 3
COMMON CORE (S3)
TU PAM2GPRJ - Health Product Project Management, Controlling and Performance Management
Number ECTS = 5 - Responsible TU : Béatrice BAÑULS
Essential prerequisites:
An initial knowledge (even minimal) of a company's financial items (balance sheet, income statement, etc.).
Content and objectives ofTU :
Project management:
the environment (organizations, stakeholders, etc.), the project life cycle and the ten knowledge areas of the Project Management Body of Knowledge (PMI®).
Operational planning: project analysis methods, Ford algorithm, milord algorithm; exercises and case studies.
Management control and performance management
Analysis of intermediate operating totals
Ration of profitability, profitability and performance
Practical applications
Work on a project management software package
TU objectives:
Project management: understanding the concepts, processes and methods of project management within the framework described by the Project Management Institute®. Operational planning: from project analysis to establishing a feasible workload plan.
Management control: evaluate and understand profitability and performance items through a company income statement.
Teaching methods :
Lectures and tutorials, Thematic lectures in amphitheatre, Application and comprehension exercises in tutorials
TU PAM2MNQM - Quality Management, Marketing
Number of ECTS = 5 - Responsible TU : Emmanuel ROBIN-Béatrice BAÑULS
Essential prerequisites:
Marketing: Initial knowledge of the global marketing approach
Quality: Initial knowledge of how a quality management system works.
Content and objectives ofTU :
Team management :20 H TD
Objectives:
Clarify the missions, roles and functions of a team (project) manager.
Understand the influence of your leadership on team performance.
Identify your management style and negotiation style.
Know how to lead meetings.
Self-knowledge. Personal characteristics impacting relationships with others.
Contents
Building a team, the conditions for its effectiveness. Managing the transition between a group and a team
The different roles within a team
Definition of team management. The key actions of a manager or project leader.
Reflecting on different management styles (self-diagnosis, role-playing)
Meeting facilitation training. Facilitator's functions. Facilitation techniques.
Negotiation and conflict management (self-diagnosis, simulations)
Quality management :12h CM + 6h TD
Within the framework of quality management in companies, based on Good Practices and ISO standards:
- Review of organizational elements, principles and tools for quality management and continuous improvement
- Product and project development: from requirements to design
- Risk management: general principles and risk assessment tools
- Change management of products, processes and methods, processes, studies
Marketing: 12h CM
Understand market mechanisms.
Identify the players involved and analyze the influencing factors.
Know the different strategic maneuvers (with regard to demand and competition).
Define the appropriate operational methods.
Integrate digital marketing methods.
TU SPECIFIC: CLINICAL OPERATIONS MANAGEMENT and DATA MANAGEMENT Clinical Database Management sub-course (S3)
TU PAM2BADO Database management - Programming:
Number of ECTS = 10 - Responsible TU :Myrtille VIVIEN
Prerequisites: None
Objectives
- Design the entity-association model of a database
- Designing a relational database
- Implementing a database in SQL language
- Create simple and complex SQL queries
- Creating programs in R
- SQL in R
- Import data from different sources
- Gather and format data from different tables
- Produce listings and graphics
- Analyze data using conventional statistical methods
- Entity/association model, relational model, algebraic language
- SQL: data definition language, creation language, query language
- The R language: basic language, function programming, use of conditional and repetitive structures, SQL in R, link with an Oracle database, data visualization with graphical functions
- SAS Basic and SAS Macro
- Listings and graphics
- Statistics
Teaching methods :
Database design is covered through exercises in a wide variety of fields.
Learning the SQL and R programming languages is based on repeated practice using various small databases, so that students are fully autonomous with these languages during the case study and internship.
Learning SAS is based on repeated use of the software, always in line with the professional situations that students will quickly be confronted with in their internships or jobs.
Each 3-hour tutorial aims to format and/or analyze a dataset. Most of the applications are directly linked to the professional opportunities offered by the course.
The involvement of professionals enables students to compare their practical experience with a mode of operation very close to their future use of the software.
Assessment methods :
Practical tests
TU PAM2DATA Data management 1
Number of ECTS = 7.5 -Manager TU : Myrtille VIVIEN
Prerequisites: TU PAM2DATA
Objectives
- Know how to structure a clinical database from a CRF based on the protocol
- Understanding the challenges facing the Data Manager and what happens to the data afterwards
- Good clinical practice in data management
- Know how to code adverse events and concomitant treatments using coding dictionaries and a professional tool
- Create a data transfer protocol for a laboratory
- Import external data and export data from professional software
- Be able to draw up a validation plan
- Know what you need to know to manage subcontracting in the laboratory
- Know what is needed to manage subcontracting from the subcontractor's point of view
- Master professional software for creating clinical databases
- Master the various possibilities for entering data from a paper CRF into the database
- Understanding the specificities of Data Management in academic structures
- Notions of risk management (RBM)
- Master methods and tools for project management, operational planning, time and team management
Contents ofTU :
- CRF annotation
- CDISC/SDTM
- Good clinical practice in data management
- Coding adverse events and concomitant treatments in practice
- Import and export laboratory data
- Risk-Based Monitoring
- Creation of a validation plan based on the example database common to all courses
- Laboratory subcontracting, CRO subcontracting, Data Management in academic structures
- Training in design and input on several professional software packages.
- Project-based learning Part 1: Creation of a clinical database based on a real protocol and CRF, using professional software in a project team under the supervision of the laboratory providing the study.
Teaching methods :
- The courses, which are run entirely by data management professionals, are based on a protocol and a fictitious CRF, which is used as a tutorial in TU PAM2DATA and PAM2DAT2.
- Practical work is carried out using professional eCRF software.
- Creation of the database structure in a project group and independently (1st part of the APP).
Assessment methods :
- Written test - Written report
TU PAM2MDBI Biomedical data management
Number of ECTS = 2.5 - Manager TU : Myrtille VIVIEN
Prerequisites: General knowledge of clinical research.
Objectives :
- Know the regulations concerning patient data
- How to draw up a validation plan for a clinical study
- Know how to carry out data cleaning steps
- Understanding the basics of risk management
- Know and understand the issues involved in coding adverse events and concomitant treatments, and the different coding dictionaries.
- Understanding the different data sources involved in clinical trials
- Learn about the uses of AI in clinical research
Contents ofTU :
- Data validation
- AI in clinical research
- Coding adverse events and concomitant treatments
- RGPD
- Real-life data
- Connected devices
- Clinical project management
Teaching methods :
Lectures given by professionals in the various fields covered.
- SEMESTER 4
COMMON CORE - INTERNSHIP (S4)
TU PAM2STAG: 4 TO 6-MONTH WORK PLACEMENT
Number of ECTS = 20 - Responsible TU :Béatrice BAÑULS
Prerequisites:
Completion of a Master 1 with an internship and/or work experience
Completion of the core Master 2 courses and the specific courses for each pathway
Content and objectives ofTU :
2h CM: preparation and instructions for finding and carrying out an internship
4 to 6 months full-time in a public or private company.
Apply the knowledge acquired during the course
Carry out a concrete professional project in the context of its activities.
Teaching methods :
Written report, Oral test, Assessment by training supervisor
TU SPECIFIC: CLINICAL OPERATIONS MANAGEMENT and DATA MANAGEMENT Clinical Database Management sub-course (S4)
TU PAM2DAT2 - Data Management 2
Number of ECTS = 5 - Manager TU : Myrtille VIVIEN
Prerequisites: TU PAM2MDBI, TU PAM2BADO
Objectives
- Know how to program validation checks in SAS language and in the Professional Software language used in TD.
- Understanding the reconciliation stage with pharmacovigilance
- Mastering data management quality control processes
- Understanding the regulatory environment for Data Management
- Know and know how to manage the closing stages of a clinical trial database.
Contents ofTU :
- Programming validation checks in two computer languages
- Quality control, Blind Review,
- Reconciliation with pharmacovigilance,
- Data Management regulatory environment, basic gel
- Introduction to Data Visualization with PowerBI®.
Teaching methods :
- The courses are taught by professionals, some of them in English.
- The programming of consistency checks is tested in practice on 2 software programs, in 2 different languages, under conditions close to those encountered in the professional world.
TU PAM2AGDC - Project-based learning GDC
Number of ECTS = 5 - Responsible TU :Myrtille VIVIEN
Prerequisites: UEs PAM2MDBI, PAM2DATA, PAM2DAT2, PAM2BADO
Objectives
- Apply all the lessons learned in the PAM2MDBI, PAM2DATA, PAM2DAT2, PAM2BADO, PAM2GPRJ and PAM2MNQM units to the second part of the project-based learning program.
- Master the tools and techniques of project management, operational planning, quality and team management.
- Create a validation plan based on a protocol and a real CRF
- Know how to program the controls described in the validation plan in the languages of the professional software used
- Drafting seizure agreements
- Drafting requests for clarification
- Know how to code AEs and concomitant events
- Know how to write a data transfer protocol, import laboratory data into professional software
- How to organize a blind review meeting
- How to freeze a database
Contents ofTU :
- As part of a project team, we carry out all stages of data management for the clinical trial whose database has been created inTU PAM2DATA, carrying out all necessary quality control and documentation:
- Validation plan, entry of patient CRFs, scheduling of checks, resolution of requests for clarification, coding of adverse events and medical terms, import of laboratory data, closing steps.
Teaching methods :
- Project teamwork in a dedicated room equipped with all the necessary software, in total autonomy, over 25 days.