Excel for Public Health Data Management and Analysis
Lesson 2.4: Vaccination Variables
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.
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.
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.