Skip main navigation

Displaying PPS data

How to present PPS data

We can aggregate data from the patient level forms as shown previously in Step 2.5, then use this data within Microsoft Excel, or another spreadsheet software (e.g OpenOffice, Google sheets, Numbers) to create charts to illustrate the data more effectively when sharing with others.

If you want to know more about using Microsoft Excel to create charts you can find information here.

Here are some examples of charts used to display the data from a small hospital described in the previous steps.

This bar chart shows which antibiotics are being used in the hospital.

y axis shows number of prescriptions from 0 - 12, x axis shows Amoxicillin 11; Benylpenicillin 8; Cefuroxime 6; Ciprofloxacin 3; Co-Amoxilcalve 5; Flucloxacin 3; Gentamicin 3; Metronidazole 5 and Vancomycin 2

This pie chart shows the types of infections that are being treated in the hospital.

Pie chart which shows the number of patients with each type of infection n=50; most common to least common = UTI; Cellulitis; Wound infection; Acute exacerbation of COPD; Cellulitis; Community acquired pneumonia; Pyelonephritis; Acute abdominal infection; Neutropenic sepsis and Diverticulitis

The Excel spread sheets from which these charts were created are here.

Here are some other ideas for how to utilise data from PPS:

• Prevalence of patients on one antibiotic, two antibiotics, three or more antibiotics. This gives information about use of combination therapy

• Use of IV route by ward

Most patients only require IV therapy for a short time, so high rates of IV antibiotics suggest failure to review and switch to oral

If you would like to learn more about IV to oral switch, you may find the BSAC FutureLearn course on Intravenous To Oral Switch interesting and useful for your practice.

• Compliance with local policy

Poor compliance may be due to lack of awareness, common infections not being included in the policy or lack of clinician agreement with the policy antibiotic choice.

Data on use of antibiotics as surgical and medical prophylaxis can also be captured during a PPS and analysis of this data can also produce useful results to share with clinicians.

Duration of surgical prophylaxis is an important measure since for most procedures, only one dose of antibiotic is required and this will be stipulated in local policies. The % procedures where >1 dose is used is a useful measure to benchmark surgical specialities and identify where excess doses are being used.

Medical prophylaxis is also an area where antibiotics may be overused, e.g. daily antibiotics for urinary tract infection. A growing body of evidence and hence local policies recommend that course length for this indication should not exceed 6 months, so high levels of use suggest failure to discontinue prophylaxis. Compliance with prophylaxis policy for indications such as splenectomy and cancer chemotherapy can also be measured via a PPS.

This article is from the free online

Challenges in Antibiotic Resistance: Point Prevalence Surveys

Created by
FutureLearn - Learning For Life

Our purpose is to transform access to education.

We offer a diverse selection of courses from leading universities and cultural institutions from around the world. These are delivered one step at a time, and are accessible on mobile, tablet and desktop, so you can fit learning around your life.

We believe learning should be an enjoyable, social experience, so our courses offer the opportunity to discuss what you’re learning with others as you go, helping you make fresh discoveries and form new ideas.
You can unlock new opportunities with unlimited access to hundreds of online short courses for a year by subscribing to our Unlimited package. Build your knowledge with top universities and organisations.

Learn more about how FutureLearn is transforming access to education