5-2 Activity: Pareto Chart
IHP 430 Module Five Activity Guidelines and Rubric
Overview: The use of statistical process control tools helps address organizational performance in many industries, including Healthcare Information Management. A Pareto chart is a type of analysis tool that helps with ranking causes from most significant to least significant. For this activity, you will create a Pareto chart using the data provided. As you complete this activity, consider whether these tools could help identify and solve your organizational problem for your final project. For help on how to create a Pareto chart, see this tutorial from Microsoft Office. Prompt: Utilizing the Chapter 04 Analysis Data Set document, which is linked in the Module Five activity assignment in your course, create a Pareto chart depicting the top 10 states with the longest lengths of stay, and the average length of stay for the remaining 40 states. Your chart should contain 11 columns.
In a separate Word document, answer the following questions regarding your Pareto Chart:
Determine if there is any commonality among the states with long lengths of stay. Explain your conclusion.
Evaluate the use of statistical process control tools and how they could address organizational performance.
Identify how these tools could help solve your organizational problem for your final project.
Rubric
Guidelines for Submission: Submit the Pareto chart as an Excel document. For the corresponding questions, submit in a Word document with double spacing, 12-point Times New Roman font, and one-inch margins. Use APA format for the reference list and all internal citations.
Critical Elements Exemplary Proficient Needs Improvement Not Evident Value
Pareto Chart Creates a Pareto chart depicting the top 10 states with the longest lengths of stay, and the average length of stay for the remaining 40 states (100%)
Creates a Pareto chart depicting the top 10 states with the longest lengths of stay, and the average length of stay for the remaining 40 states, but chart has errors or is incomplete (55%)
Does not create a Pareto chart (0%)
20
Commonality Meets “Proficient” criteria and offers keen insight into explanation of commonality (100%)
Determines if there is commonality among the states with long lengths of stay (85%)
Determines if there is commonality among the states with long lengths of stay, but lacks details in response (55%)
Does not determine if there is commonality among the states with long lengths of stay (0%)
20
Critical Elements Exemplary Proficient Needs Improvement Not Evident Value
Statistical Process Control Tools
Meets “Proficient” criteria and offers keen insight into how the tools can be used to address organizational performance (100%)
Evaluates the use of statistical process control tools and how they could address organizational performance (85%)
Evaluates the use of statistical process control tools and how they could address organizational performance, but response lacks details or has errors (55%)
Does not evaluate the use of statistical process control tools and how they could address organizational performance (0%)
20
Solving Organizational
Problem
Meets “Proficient” criteria and offers detailed examples of how tools will help solve the organizational problem for the final project (100%)
Identifies how these tools could help solve the organizational problem for the final project (85%)
Identifies how tools could help solve the organizational problem for the final project but lacks details or has errors (55%)
Does not identify how tools could help solve the organizational problem for the final project (0%)
20
Articulation of Response
Submission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy-to- read format (100%)
Submission has no major errors related to citations, grammar, spelling, syntax, or organization (85%)
Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas (55%)
Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas (0%)
20
Total 100%