Skip to content
  • Who We Are
    • CPA President & Vice President
    • CPA Council
    • CPA Team
    • Alliances
    • Member Associations
    • Partners
    • Trustees
    • Patrons
    • Fellows
  • Strategy
    • Our Impact
  • Join
  • Careers
  • Our Work
    • AMR
    • COVID-19
    • CPD
    • PharmAid
    • Tools and Resources
  • Latest
    • Events
    • News
    • Blog
    • Publications
    • Work with Us
  • Support Us
  • Contact
Menu
  • Who We Are
    • CPA President & Vice President
    • CPA Council
    • CPA Team
    • Alliances
    • Member Associations
    • Partners
    • Trustees
    • Patrons
    • Fellows
  • Strategy
    • Our Impact
  • Join
  • Careers
  • Our Work
    • AMR
    • COVID-19
    • CPD
    • PharmAid
    • Tools and Resources
  • Latest
    • Events
    • News
    • Blog
    • Publications
    • Work with Us
  • Support Us
  • Contact
linkedinCreated with Sketch. InstagramCreated with Sketch. FacebookCreated with Sketch. TwitterCreated with Sketch. Youtube

Data Validation and Data Analysis

Data Validation and Data Analysis

Supporting your progress through Data for Action Module 3

Welcome to the Data for Action data validation and analysis page. Below are a series of videos and activities to support your learning on data validation and analysis of point prevalence survey (PPS) data using the World Health Organisation (WHO) methodology.

The videos should be viewed sequentially.  You will also need to download a copy of the Excel activities to complete. We recommend pausing the video to complete any activities and re-watching any sections as required.

Data Validation

Before watching the Data Validation videos, please download Excel Worksheet 2: Missing Data Activity (WHO PPS) by clicking the button below.

Download
Data Validation I: The WHO PPS Data Collection Tool & Data Entry
https://commonwealthpharmacy.org/wp-content/uploads/2026/01/1.-Data-validation-.mp4
Data Validation II: Stages of Data Validation
https://commonwealthpharmacy.org/wp-content/uploads/2026/01/2.-Data-validation-.mp4
Data Validation III: Data Standardisation
https://commonwealthpharmacy.org/wp-content/uploads/2026/01/3.-Data-validation-.mp4

Data Analysis

Before watching the Data Analysis videos, please download Excel Worksheet 3: Analysis Activity (WHO PPS) by clicking the button below.

Download
Data Analysis I
https://commonwealthpharmacy.org/wp-content/uploads/2026/01/Data-analysis-video-1-1.mp4
Data Analysis II
https://commonwealthpharmacy.org/wp-content/uploads/2026/01/Data-analysis-video-2.mp4
Data Analysis III
https://commonwealthpharmacy.org/wp-content/uploads/2026/01/Data-analysis-video-3-1.mp4

The data analysis featured in these videos is based on the following report template, which is to be used in conjunction with the PPS Short Report and Intervention Guide.

Download

Who we are

  • Alliances
  • Membership
  • Contact Us
  • Our Constitution
  • Alliances
  • Membership
  • Contact Us
  • Our Constitution

About us

  • Strategy
  • News
  • Blog
  • Safeguarding Policy
  • Strategy
  • News
  • Blog
  • Safeguarding Policy

Our work

  • AMR
  • COVID-19
  • CPD
  • PharmAid
  • Tools and Resources
  • AMR
  • COVID-19
  • CPD
  • PharmAid
  • Tools and Resources
© 2026 CPA
  • Privacy Notice
  • Terms & Conditions
  • Disclaimer
  • Cookie Policy (UK)
  • Privacy Statement (UK)
  • Cookie Policy (EU)
  • Privacy Statement (EU)
  • Privacy Notice
  • Terms & Conditions
  • Disclaimer
  • Cookie Policy (UK)
  • Privacy Statement (UK)
  • Cookie Policy (EU)
  • Privacy Statement (EU)

CIO Registered charity number: 1176132

Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behaviour or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}