Skip main navigation
We use cookies to give you a better experience, if that’s ok you can close this message and carry on browsing. For more info read our cookies policy.
We use cookies to give you a better experience. Carry on browsing if you're happy with this, or read our cookies policy for more information.

Displaying PPS data

We can aggregate data from the patient level forms as shown previously in Step 2.5, then use these 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

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

Share this article:

This article is from the free online course:

Challenges in Antibiotic Resistance: Point Prevalence Surveys

BSAC

Contact FutureLearn for Support