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
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more