Arte SheetsLearn. Try. Understand.

Healthcare & Clinical

Pediatric Trauma Score: Adding Six Component Points

Practice summing the published component-point values with complete and discrete input checks.

About the Pediatric Trauma Score

The Pediatric Trauma Score described by Tepas and colleagues combines six components: weight, airway, systolic blood pressure, consciousness, wounds and fractures. Each component receives one of the points −1, 1 or 2 in the published scheme, which are then summed.

The worksheet below only adds already chosen values; it does not translate clinical observations into points or determine mortality, treatment, transport or destination. Trauma triage requires trained professionals, current local protocols and the full clinical picture.

A fictional point-summing example

Six invented component points of 1 add to 6. With all six components set to −1 the arithmetic minimum is −6; all six set to 2 produce 12. These totals alone are not a patient assessment.

Six hypothetical pointsSum
1, 1, 1, 1, 1, 16
−1, −1, −1, −1, −1, −1−6
2, 2, 2, 2, 2, 212

Validate and add the points

Enter all six numeric component points in B2:B7. Each must be exactly −1, 1 or 2. This detects impossible numeric codes but cannot verify whether any point was correctly assigned.

=IF(COUNT(B2:B7)<>6,"Enter six numeric component points",IF(SUMPRODUCT((B2:B7<>-1)*(B2:B7<>1)*(B2:B7<>2))>0,"Each point must be -1, 1, or 2",SUM(B2:B7)))

Try the example

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

Further reading