Reference no: EM13750999
Objectives
Upon completion of this activity, the student should be able to:
Retrieve requested patient data from a departmental database.
Calculate mortality/autopsy rates for a specific time period.
Communicate statistical findings required for a specific request
Definitions for the Assignment
Medical Patient is a patient who has no procedure code listed in the Principal Procedure column or has a minor diagnostic or therapeutic procedure (codes 87.0-99.99) listed in the Principal Procedure Column.
Surgical Patient is a patient with a Surgical Procedure code listed in the Principal Procedure column (excluding principal procedures which are minor diagnostic procedures - codes 87.0 to 99.99).
Instructions
Dr. Fox, the Chief of Surgery for Community Hospital, wishes to study the records of patients during the past six months who died within two days of surgery. He is not interested in patients who had minor procedures done (diagnostic or therapeutic), only those who had major surgical procedures. He is particularly interested in the records of those patients who did not have an autopsy performed and would like to know the surgeon involved.
Download and review the Community Hospital Death Register from July 1, 20XX through December 31, 20XX.
Using Microsoft Word, prepare a table for Dr. Fox that includes surgical patients who expired within two days of surgery. In the table, include each patient's medical record number, age, sex, final diagnosis code, principal procedure code and whether or not the patient had an autopsy.
Generate a list of records, from the table you created in #1, to be pulled for Dr. Fox, so that he can review the records of patients who died within two days of surgery, but did NOT have an autopsy.
Compute the following mortality and autopsy statistics to include in the memo to Dr. Fox:
Percentage of total deaths that were surgical (NOTE: surgical deaths do not include those with minor procedures as described in the Definitions above.)
Percentage of surgical deaths that died within 2 days of surgery
Autopsy rate for surgical deaths within two days of surgery
Write a memo to Dr. Fox that includes all the requested information. Include any other data that you think he may find helpful or interesting.
Evaluation
This activity will be evaluated for:
The ability to retrieve the requested data from the death register.
Correctly computing the statistics.
Documenting the findings in memo format.
|
Summarize recent real-world examples
: Summarize recent ‘real-world' examples that illustrate one or more of the topics presented in these chapters or find related articles that extend the book's discussion on IT and strategy, and/or
|
|
Current debt and issue new one to save on interest costs
: A treasurer argues with the CFO that because "interest rates have dropped substantially in the last year, the firm should best' back their current debt and issue new one to save on interest costs". The CFO answers that this only makes sense for "the ..
|
|
The strategic national stockpile
: The Strategic National Stockpile (SNS) is a pivotal tool in the event of a disaster. The SNS is used as a federal government initiative to meet the threat of disasters that result in mass casualties.
|
|
One ikea executive says that the current global economic
: 1 One IKEA executive says that the current global economic situation has "pushed innovation" at the company. In fact, he say, "This is a great time to be more innovative." Explain what he means.
|
|
Compute the mortality and autopsy statistics
: Compute the following mortality and autopsy statistics to include in the memo to Dr. Fox- Percentage of total deaths that were surgical, NOTE- surgical deaths do not include those with minor procedures as described in the Definitions above.
|
|
Analysis of the supreme court of the united states case
: Search the internet and find the case The Supreme Court of the United States case of Griggs v. Duke Power Company (1971). Analyze and present a summary of the case. When preparing the summary make sure you answer the following questions: 1.Why was th..
|
|
Write a paper on the film triangle fire
: Write a three to five pages paper on the film Triangle Fire.
|
|
Use one of the pages to map the risks
: Use one of the pages to map the risks and provide a table with corresponding numbers to identify the risks in the mapping tool Be sure to explain your risk choices as well as how the businesses could deal with the risk exposureThe matrix and table ca..
|
|
Select an area of growth within e-commerce or e-marketing
: Research Paper: Strategic Directions of E-Commerce and Future Development Select an area of growth within e-commerce or e-marketing. This can be an area of technology, technology implementation, business structure, or anything else related to ecomme..
|