Question: For Assessment 2, you will develop an Excel dashboard with graphs and a strategy map for four (4) DRGs - heart failure, pneumonia, heart attack

For Assessment 2, you will develop an Excel dashboard with graphs and a strategy map for four (4) DRGs - heart failure, pneumonia, heart attack (MI), and stroke readmissions. Preparing for the Assignment Review Olson, J. R., McLaughlin, D. B., & Sharma, L.(2022). Healthcare operations management. - Chapters 1-8. Begin the assignment inSentinel Health DataLabby clicking"Enter Sentinel World"at the beginning of the course page. Review the following files Project RED Strategy Map Medicare Synth Data with Readmissions Indicated Instructions Step 1: Access theSentinel Health DataLab,then: Select Quality. Select Column Visibility. Select Region, State, Year, and % Heart Failure, Pneumonia, Heart Attack, and Stroke Readmissions. Click outside the boxes to close the screen. Select Excel to obtain the data report. Click in the Select States section and select one state of your choice from the dropdown list. Click Filter. The Sentinel Health Data Lab screens data report will change to indicate only the state you have chosen. Select Excel and save the Excel file to complete step 2. Step 2: Review the saved excel file for the state you have chosen. There are several columns present, scroll right until you find columns for % Heart Failure, Pneumonia, Heart Attack, and Stroke Readmissions. Create an excel dashboard that displays the readmissions for the selected DRG codes. a. Create at least 3 types of graphs of the readmission data (i.e. pie graph, line graph, bar graph, etc.) in your dashboard. b. All four (4) DRGs are to be included in the graphical representations. Construct a strategy map (refer to the Project RED Strategy Map file example) to reduce the readmission rates foreachof the selected DRG codes. Step 3: Complete a 1-2 page executive summary explaining your dashboard information and strategy map. Your summary should contain hypothetical examples and should be written as if you are conveying your findings to C-suite (CEO, CFO, COO, etc.) executives. Submit the Excel dashboard as Appendix A, and the strategy maps as Appendix B. Submission Criteria for Assignment 2 All submissions should have a title page and reference page (not included in page count). Narrative is submitted in a Word document which may include tables, graphs, other resources as needed. Include an introductory and summary paragraph/statement. The page count should be 1-2 pages (not including the dashboard and strategy maps). Submit the Excel dashboard as Appendix A, and the strategy maps as Appendix B. Utilize a minimum of three (3) scholarly resourcesin addition to your required textbook and resources. Adhere to grammar, spelling, and punctuation criteria. Adhere to APA compliance guidelines.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!