MODM Clinical Database Management

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.
Understandthe 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.

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)

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

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.

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, reading documents 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-playing

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

Assessment methods: Written test

Speakers

Montpellier University

BAÑULS Béatrice
KHIER Sonia
CROS Gérard
DRAKULOVSKI Pascal
C. Dupont
P. Licznar
V. Driss
Chevassus
V. Bellet

Outside professionals

• M. Chettouh (CHU)

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

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

Number of ECTS = 5 - Responsible TU : Patrice RAVEL

Essential prerequisites: TU cannot be dissociated from the other TU courses.

Modalities : 41 h CM + 6 h TD This TU includes reference hours (APP + hospital internship)

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)

Speakers

Outside professionals

C. LeperchoisE. EdorhE. DulucE. BeldaK. MahadeaV. Roux

Number of ECTS = 5 - Responsible TU : Patrice RAVEL

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.

Assessment methods :Written test - Case study

Speakers

University of Montpellier

BOISSERIE - LAPORTE VéroniqueC. Audrey

Outside professionals

N. BensmailB. BuffinO. Adotevi

Number of ECTS=5 - Responsible TU : Patrice RAVEL

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 the 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
• 5 sessions of 3 hours of practical work on SAS software per student

Assessment methods :

• Written test - SAS practical test and continuous assessment
• Tutored project and written report

Speakers

University of Montpellier

• P. RAVEL
• M. VIVIEN
• R. SABATIER

Outside professionals

• W. AGOUMI
• T. VANDENBOSSCHE

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

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 manager (project).
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 the competition).
Define the appropriate operational methods.
Integrate digital marketing methods.

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

Number of ECTS = 7.5 -Manager TU : Myrtille VIVIEN

Prerequisite: TU PAM2MDBI

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

Number of ECTS = 2.5 - Manager TU : Myrtille VIVIEN

Prerequisites: General knowledge of clinical research.

Objectives :

• Learn the basics of CDISC and SDTM standards
• 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

Contents ofTU :

• CDISC - SDTM
• Data validation
• Risk management
• Coding adverse events and concomitant treatments
• RGPD
• Real-life data
• Connected devices
• Clinical project management
• Databank

Teaching methods :

Lectures given by professionals in the various fields covered.

Assessment methods :

Written test

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

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
• Data security
• Introduction to DataVisualizationwithTableau®

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.

Assessment methods :

• Written exam via MOODLE - Group work grade

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.

Assessment methods :

• Written report and oral defense before a panel of professionals (lecturers and others)