Arte SheetsLearn. Try. Understand.

Statistical & Clinical Analysis

PRAM: Adding Five Pediatric Respiratory Assessment Scores

Sum five already-assessed PRAM component scores and display the numerical range, with input checks and pediatric clinical context.

Five assessed components

The Pediatric Respiratory Assessment Measure (PRAM) adds points for oxygen saturation, suprasternal retractions, scalene muscle contraction, air entry and wheezing. This worksheet starts with points already assigned by a trained assessor and demonstrates the addition; it does not examine a child or establish a diagnosis.

The 2008 prospective validation studied children aged 2–17 with acute asthma. Some current clinical pathways specify a different age range, including children from age 1; apply the relevant pathway rather than extending the original study population without qualification. In the Canadian Paediatric Society table, inspiratory wheeze can score 2 whether or not an expiratory component is present.

The cited Canadian guidance describes totals 0–3, 4–7 and 8–12 as mild, moderate and severe ranges, respectively. Other signs can indicate serious deterioration regardless of the total. A score alone does not determine medication, discharge or care escalation; the child needs the applicable clinical assessment and timely care.

ComponentAllowed points in this example
Suprasternal retractions0 or 2
Scalene muscle contraction0 or 2
Air entry0, 1, 2 or 3
Wheezing0, 1, 2 or 3
Oxygen saturation0, 1 or 2

Total the five sign scores

Each field B2:B6 is a numeric, already-assessed score, not a raw symptom or oxygen reading. All fields are required and only the listed whole-number values are accepted.

=IF(COUNT(B2:B6)<>5,"Missing or nonnumeric sign",IF(OR(AND(B2<>0,B2<>2),AND(B3<>0,B3<>2),B4<0,B4>3,MOD(B4,1)<>0,B5<0,B5>3,MOD(B5,1)<>0,B6<0,B6>2,MOD(B6,1)<>0),"Invalid sign score",SUM(B2:B6)))

Display the numerical range

A numerical band does not replace assessment for other signs of respiratory distress or establish an individual treatment plan.

=IF(COUNT(B2:B6)<>5,"Missing or nonnumeric sign",IF(OR(AND(B2<>0,B2<>2),AND(B3<>0,B3<>2),B4<0,B4>3,MOD(B4,1)<>0,B5<0,B5>3,MOD(B5,1)<>0,B6<0,B6>2,MOD(B6,1)<>0),"Invalid sign score",IF(SUM(B2:B6)<=3,"Score 0 to 3",IF(SUM(B2:B6)<=7,"Score 4 to 7","Score 8 to 12"))))

Try the example

Use the original values or change them to test your understanding.

Further reading