Excel for Public Health Data Management and Analysis
0% Completed
Module 1: Introduction to Public Health Data Systems
This module introduces the fundamental role of data in public health practice. Participants will learn how data support disease surveillance, outbreak response, program monitoring, operational research, and evidence-based decision-making.
The module also introduces the public health data lifecycle and familiarizes learners with common data sources and case investigation forms that will be used throughout the course.
By the end of this module, participants will understand how public health data are generated, collected, managed, analyzed, and transformed into actionable information.
Lesson 1.1: The Role of Data in Public Health
Reading
Lesson 1.2: Disease Surveillance Systems
Reading
Lesson 1.3: Sources of Public Health Data
Reading
Lesson 1.4: The Public Health Data Lifecycle
Reading
Lesson 1.5: Introduction to Case Investigation Forms
Reading
Module 1 Quiz: Public Health Data Systems
Quiz
Module 2: Understanding the Measles Case Investigation Form
This module introduces participants to the structure and content of a standard measles case investigation form (CIF). Learners will explore how epidemiological information is collected during outbreak investigations and surveillance activities.
Participants will identify demographic, clinical, vaccination, laboratory, and outcome variables that will later be transformed into an electronic database. By the end of this module, learners will be able to interpret a case investigation form and prepare it for database design and data management.
Lesson 2.1: Anatomy of a Measles Case Investigation Form
Reading
Lesson 2.2: Demographic Variables
Reading
Lesson 2.3: Clinical Variables
Reading
Lesson 2.4: Vaccination Variables
Reading
Lesson 2.5: Laboratory Variables
Reading
Lesson 2.6: Outcome Variables
Reading
Module 2 Quiz: Understanding the Measles Case Investigation Form
Quiz
Module 3: Converting a Case Investigation Form into a Database
This module teaches participants how to transform a paper-based Case Investigation Form (CIF) into a structured electronic database. Learners will identify variables, define data types, establish naming conventions, create coding systems, and develop a comprehensive data dictionary.
By the end of this module, participants will be able to design a complete outbreak database structure that supports data entry, quality assurance, epidemiological analysis, and reporting.
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%