This assignment has three (3) parts.
Part 1:This portion of the assignment utilizes the content from your textbook listed below.
Read: Data Analytics in Healthcare Research: Tools and Strategies, Chapter 15: Using Data Mining Techniques to Predict Healthcare Associated Infections, pgs. 243 and 244, complete the statements and answer the questionsbelow by typing your answers in the spaces provided.
1. In the reading, what does the acronym CDI abbreviate?
2. What region of the United States has a significantly higher prevalence of CDI?
3. What size of hospitals (small/medium/large) in this region have more discharges related to CDI?
4. The art and science of intelligent data analysis with an aim to discover meaningful insights and knowledge from data is data __________.
5. The dependent variable for the proposed study is a hospital's __________ of __________ rates within US __________ care hospitals and has three response options:
• Better than the US National Benchmark.
• No Different than the US National Benchmark.
• Worse than the US National Benchmark.
Part 2: The content and examples found on the Module 05 page titled Query Statements for Data Extraction will provide helpful guidance for this part of the assignment (specifically content found under the Query Example and SQL Statement Example and Join Statementssubheadings).
The state surveyor from the region is gathering and collecting data from acute care hospitals in your region to compare to the National Benchmark.Ultimately, the state surveyor will compile the data collected from hospitalsand put it into a report following the format shown below.
As you can see above, the surveyor needs statistics regarding the discharges from all hospitals in the region during the 2012 to 2015 time period so that a comparison can be done on the prevalence of CDI.
The state surveyor has requested the above information from your facility but specifically for patientswho have addresses inzip code 14424. Consider the state surveyor's inquiry and complete the single table SQL statements below in order to pull the correct data from the database.
6. For Diagnosis Code
a. This query will provide a report for our facility with patients where the patient has a diagnosis code of __________.
b. What diagnosis does the above code represent?
c. What does the semicolon (;) tell the computer?
d. What table will be used in the above SQL statement?
7. For Zip Code
a. See the SELECT line above. What value should be recorded in the blank marked (7a)?
b. See the WHERE line above. What value should be recorded in the blank marked (7b)?
c. What does that all mean? This Query will provide our facility with what?
Part 3: Written Reflection
8. In the space on this page, write a short paragraph addressing the following:
a. Describe how the query process leads to the creation of reports.
b. Explain why accurate queries are important to obtaining reports with the data required.
c. Suggest reasons why reports are important to healthcare facilities in the USA.