Utilizing Health Care Databases Assignment | College Homework Help

Please read instructions carefully, this is very important. This is what the final will include.
To Be Submitted:
● #1 and #2—excel files with data
● #3—screen shots of data
● Separate narrative in a word document with your observations about the data findings.

Utilizing Health Care Databases

You are to provide a report from each of these registries based on the guidelines below.

Please Read Carefully and Follow all Directions

1.  Using the HCUP database, create a chart that shows the number of discharges, LOS, charges, and costs for all patients broken down by age (in categories) sex and insurance coverage.  Select two-way tables.  The video illustrated this on all patients discharged.  You are to select either a disease or a procedure, andrun the same query on the nationwide database and two of the states.  Evaluate your findings.  Some things to consider are the similarities and differences between the two states, and between the states and the national averages; or between age groups or pay source.

Speculate on reasons for the differences.  If you were a policy maker in one of the states, what would you recommend to your lawmakers regarding your findings?

For purposes of this assignment, I would recommend saving the results as an excel file so that I can see what you were reviewing.

Link to database: https://hcupnet.ahrq.gov/#setup

1. Using the National Healthcare Quality and Disparities Report, go to the Data Query tab.  You will only be looking at national number for this database. Choose Access to Care as the subject area and Structural Access as the topic. Access the measures below until you get to a measure that interests you.

• Children who had a doctor’s office or clinic visit in the last 12 months and needed care, tests or treatment who…….
• Adults with limited English proficiency who had a usual source of care
• Adults who reported getting the help or advice they needed the same day they contacted their home health providers
• Adults who had any appointments for routine health care in the last 12 months who sometimes or never got an appointment…..
• Children who had any appointments for routine health care in the last 12 months who sometime or never got an appointment
• Adults who needed care right away for an illness, injury, or condition in the last 12 months who sometimes or never……
• People under age 65 without health insurance
• People under age 65 with public health insurance only.

Select “Over time” under view tables and graphics for this measure.  Click on “Get Data”. Click on the link that says “Excel—Open/Save File”. Review the information in the Excel document.  Notice that there is more information in this file than what was displayed on the initial query.

Comment on the findings—What questions does the data raise for you. Can you make any predictions as to what the future holds for these patients?  As above, comment on what recommendations do you have as a policy maker to make impact future results

Link to database: https://nhqrnet.ahrq.gov/inhqrdr/reports/index

1. National Program of Cancer Registries:  For this database, click on “United States Cancer Statistics:  Data Visualizations”.  (Note that the video was done prior to having access to 2016 data and so the data in the video only displays up to 2015 data).

You are to use 2016 data.  This is an interactive graphic that displays the incidences of cancer by state ranking compared to the US overall.  You can do many things here, but you will be comparing two states of your choice to the national data.  You can compare the rates of male to female for certain types of cancer.  Or you can compare the rate of a particular type of cancer from 2016 with the same type of cancer in 2000.  It is up to you as to what you want to compare.  View the video to see how to navigate the website.

Make some observations about your findings.  For example: why is the incidence different between men and women?  Has the incidence of cancer decreased or increased over the years?  Why does one state have a higher incidence than another?  How do the states compare to the national rates?  These are the types of questions you are to evaluate.  Is there any recent research on the type of cancer you selected?

Link to database: https://www.cdc.gov/cancer/uscs/tools.htm?CDC_AA_refVal=https%3A%2F%2Fwww.cdc.gov%2Fcancer%2Fnpcr%2Ftools.htm

For this part of the assignment, you will have to send a screenshot of the three data sets you viewed.  See below for a sample.  That way I can go in and view the same data you were looking at.    See below for the screenshot I need.

For example this screenshot tells me that you were looking at the rate new cancer cases and cancer deaths of prostate cancer in New York for males in 2016.