Please review this file  download and observe how patient age is calculated, and how cohorts are created for each category of Pediatric Patient. Please go thru each of the worksheets presented as “Step 1”, “Step 2”, and so forth. Upon completion, create a Pivot Table in Step 6 which analyzes the Pediatric patient data by age cohort in Step 5. Submit the MS Excel file here. 

Part 2:   Case StudyWeek 2:Defining Age Cohort Definitional Problems in anAcute Care Hospital Quality Resource DepartmentCase Background:  A 450 bed acute care hospital that was runningat a typical daily occupancy of rate of 86% performs approximately 85focused chart reviews per day, concentrating on a number of factors, including the patient’s length of stay  (LOS),  severity,  current  diagnosis, pre-operative surgical risk  factor  status, infection  status,  current  medication protocols, and a number of behavioral health indicators.During the course of developing chart review protocolsin anticipation of a focused review involving the Department of Pediatrics,  a  lively  discussion  ensued  among  the  Quality  Resource  Management (QRM) staff  as to  what constituteda “Pediatric”case.  A number of members of the team had different opinions as to which patient ageboundaries should be  used  whendesignating  a  case  to  qualify  as “Pediatric”.    Some  members felt  that  many  of  the older patients  seen within  the  Pediatric  Department should be  classified  as “adults”due  to  a  number  of  physiological  and  psychological factors,  while  other  members  of  the  team  felt  that  it  was  important,  for  reasons  of  data  consistency,  to  maintain  the traditional pediatric age cut-off point of “under age 18years”for designating pediatric patients.Data  Collection, Preparation,  and  Analysis: The  Chairman  of  the  Department  of  Pediatrics charged  those  individuals responsible  for  data  collection,  preparation,  and  analysis  to  take  an “open”and “flexible”approach  to  the  issue  of designating  which  patients  would  be  considered “pediatric”from  a  clinical  perspective  versus  from  an  administrative perspective.    In  essence,  the  Chairman  was  directing  the  team  to analyze  the datain  such  a  way  that  would  permit grouping of patients by age into multiple cohorts.  One member of the team cautioned that creating multiple definitions of “pediatric”might create confusion when conducting analysis. Conclusion:  The Quality Resource Management staff ultimately decided to create sixage cohort designations based on the patient’s age at the time of admission.   These cohorts consisted of these groupings:

Pt Age RangePt Age Range Designation< 1 YearInfant1 –3YearsToddler4–10YearsPediatric11 –12YearsPreAdolescent13 –15 YearsAdolescent16 –17 YearsPost AdolescentUnanticipated Outcome:Shortly after this decision was made, the QRM staff discovered that a similar issue existed for patients classified as “Geriatric”.  In this case, the discussion focused on the gradualincrease in patient age experienced in the healthcare environment, with specific attention to patients who are over the age of 90.  In this case, the Quality Resource  Management  Team  developed  the  following  age  cohorts  to  describe  patients  who  previously  had  all  been collapsed into a single category of “Geriatric”:Pt Age RangePt Age Range Designation65-69Young Geriatric70-74Septuagenarian 175-79Septuagenarian 280-84Octogenarian 185-89Octogenarian 290-99Nonagenarian100+Centenarian