Application Case 1 - Aging the Pediatric Patient (Part 1)
Kpatel
PatientAgeCohortsUsefulforAnalysis.pptxDepartment of Health Informatics
Health Information Management Program
BINF 5520 Health Analytics
Using Microsoft Excel To Calculate Patient Age and
Create Patient Age Cohorts Useful for Analysis
Week 2
Discussion Forum
Today’s Topic
Understanding the challenges facing health information professionals as they negotiate:
Competing Standards of Data Quality
Data Quality Implementation Challenges
Exercise in Calculating Patient Age Cohorts
Questions and Answers
We will spend the bulk of our time working through an exercise in:
Calculating Patient Age
Creating Patient Age Cohorts Based On That Calculation
At the conclusion, we’ll have time for Questions and Answers.
Today’s Topic
Negotiating Competing Standards of Data
When analyzing and presenting health related information, what principles should we employ for the categorization of the data?
What challenges do we face when presenting data to audiences with different interests and/or agendas?
Awareness of Competing Data Standards
Standards of Rigor
Standards of Precision
Standards of Consistency
Standards of Timeliness
Standards Related To Patient Safety
The Role of Standards Development Organizations (SDOs)
Data Quality Implementation Challenges
Development of Data Quality Standards
Monitoring of Data Quality Standards
Enforcement of Data Quality Standards
Managing Change in Data Quality Standards
All Important Challenges !
Considerations for Calculating Patient Age
We must consider when the calculation of the patient’s age is performed. This is typically done at the time of service, but not always.
We must also consider that we typically round the patient’s age DOWN TO THE NEAREST WHOLE NUMBER. Another way of saying this is that the patient’s age doesn’t turn to the next consecutive number until their birthday passes. They “keep” their age up until their birthday. Then and only then to they “progress” to the next age.
Lastly, aside from newborns, we typically are not interested in the patient’s age in fractions or decimals. We typically round down to the nearest whole number. We handle this by invoking the “Integer” function when composing our formula.
These techniques will be demonstrated when you open up Technical Exercise 02 – Calculating Patient Age and Patient Age Cohorts”, which is a Microsoft Excel format.
Let’s Get Real….
The question at hand is this:
When does a patient move from the “Pediatric” category to the “Adult” category?
Let’s Get Even More Real…
Within the “Pediatric” category,
do we need to distinguish between
patients of varying ages?
Is a 3 year old really the same as a 17 year old ?
Whatever….
In Other Words….
Bumper Sticker It For Me !
When is a child no longer a child?
How can we categorize children by age?
Calculating Patient Age Cohorts
When we calculate Patient Age Cohorts, we must remain mindful that the logical grouping of patients must make sense to the user. There must be an internal consistency to the designations chosen for these age cohorts.
We will use a technique within Excel called the “Nested IF” statement, where we create multiple conditions for evaluating the patient’s age in order to designate the appropriate age category for each patient.
The Concept of “Nesting”
Items in a set forming a chain, hierarchy, or logical sequence in which each member is contained in or contains the next.
Nest, verb, past tense: nested; past participle: nested
1. (of a bird or other animal) use or build a nest.
2. fit (an object or objects) inside a larger one.
Calculating Patient Age Cohorts: The “Nested IF” Formula
=IF(G2<1,"Infant", IF(G2<4,"Toddler", IF(G2<11,"Pediatric", IF(G2<13,"Pre-Adolescent",
IF(G2<16,"Adolescent", IF(G2<18,"Post-Adolescent", "Other"))))))
=IF(Condition1, “Label 1”, IF(Condition2, “Label2”, IF(ConditionX, “Label X”)))
FOR EXAMPLE:
WHERE THE CELL G2 IS THE CALCULATED PATIENT AGE.
Calculating Patient Age Cohorts: The “Nested IF” Formula
=IF(G2<1,"Infant",
IF(G2<4,"Toddler",
IF(G2<11,"Pediatric",
IF(G2<13,"Pre-Adolescent",
IF(G2<16,"Adolescent",
IF(G2<18,"Post-Adolescent",
"Other"))))))
Condition 1
Condition 2
Condition 3
Condition 4
Condition 5
Condition 6
Open Parenthesis
Close Parenthesis
Condition 7
So Let’s Get Busy !
So Let’s Recall Our Question…
Is a 3 year old really the same
as a 17 year old ?
Pul-eeeze.
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts Step 1 – Collect Data
Step 1
Step 5
Step 4
Step 3
Step 2
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 2 – Calculate Patient Age
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 3 – Format Patient Age
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 3 – Format Patient Age
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 4 – Create Patient Age Cohorts
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
Technical Assignment 02 – Calculating Patient Ages and Age Cohorts
Step 5 – Analyze Data
