Benchmarks and Quality Measures

Details: The conidiation that you will use for this assignment is Diabetes. I have attached the pervious paper that was written on collecting information. Also, I attached an example of xcel file that needs to be done.

Instructions
Step One: Preparation
Locate data related to quality measures relevant to your topic from one or more of these websites:

Agency for Healthcare Research and QualityLinks to an external site.. (n.d.). https://www.ahrq.gov

Centers for Disease Control and Prevention (CDC)Links to an external site.. (n.d.). http://www.cdc.gov

Centers for Medicare & Medicaid Services. (n.d.). CMS data navigatorLinks to an external site.. https://data.cms.gov/

The Joint CommissionLinks to an external site.. (n.d.). https://www.jointcommission.org/

National Committee for Quality Assurance (NCQA)Links to an external site.. (2019). https://www.ncqa.org/

Occupational Safety and Health AdministrationLinks to an external site.. (n.d.). http://www.osha.gov/index.html

Any other site that contains national or state health care quality measures.

Step Two: Data Collection
Using the Data Collection Spreadsheet Guide [XLSX] Download Data Collection Spreadsheet Guide [XLSX]as an example, create a spreadsheet containing three tabs: Dashboard Tracking, Data Collection, and Trending.

On the first tab, Dashboard Tracking, draw from the information you gathered in Step One as part of your preparation for this assessment:

Identify the specific benchmark data you will compare with your office data. Remember it is up to you to establish your benchmarks.
Organize or create a spreadsheet to display the totals, percentages, averages, and so on of your office data and of the national or state data you will be using for comparison.

Note: Your Office Data column will be blank because you are not collecting any office data. This is only a proposal to do an information review of the quality of care provided by the physician group. Data does, however, need to appear in the Benchmark (national/state) data column.

Include at least one comparison graph of your choice on this tab.

On the second tab, Data Collection, draw from the information you gathered in Step One as part of your preparation for this assessment:

Create a form you will use to collect specific data from the patients’ records.
Include a row for each patient.
Provide a column for each data collection point (quality measure) you will be comparing.
Note: The information on this page is totaled, averaged, et cetera, with the results linked to the first tab.

To create your third tab, Trends, you will need to do some additional research. Identify national benchmarks for the condition you have chosen that could be compared to your office data. For example, if the trend in your office is that you are seeing more patients with asthma, but the national trend is decreasing, you have discovered a discrepancy that needs to be investigated.

To perform your analysis:

Visit one or more of the following websites containing national data:
Agency for Healthcare Research and Quality. (n.d.). HCUPnet: Healthcare cost and utilization projectLinks to an external site.. https://hcupnet.ahrq.gov/#setup

Centers for Disease Control and Prevention. (n.d.). CDC wonderLinks to an external site.. https://wonder.cdc.gov/WelcomeT.html

Centers for Medicare & Medicaid Services. (n.d.). CMS data navigatorLinks to an external site.. https://data.cms.gov/

Any other site that contains national or state health care data.

Locate and analyze statistical data relevant to the selected condition.

Examine trends:
What other meaningful trends exist? For example, consider the number of new cases, increases or decreases of cases within a specific age range or location, et cetera.
How do the national and state trends compare?
Is the national trend increasing or decreasing?
What is the percentage of cases who expire from the disease?

Identify the trending of one statistical result relating to the condition you selected over the last 5–10 years.
Create a line graph on the third tab of your spreadsheet, Trends, that illustrates the national and/or state trending of the disease you selected over the past 5–10 years.

Note: Remember you have not collected your office data yet for comparison purposes. You could add that data at a later time.

Step 3: Data Compatibility
Write a short section to add to the proposal you will complete in Assessment 3. Be sure this section of your proposal includes all of the following headings and your narrative addresses each of the bullet points.

Introduction
Provide a brief 1–2 sentence high-level summary explaining data compatibility.

Data Compatibility
Assess the compatibility of the data:
How can you ensure data from multiple sources is compatible?

How do you know the data you are using for comparison is compatible with your office data?

What challenges are associated with data standardization?
We do not want to compare apples with oranges. You want to be sure data from multiple sources:
Represents the same condition.
Uses similar statistical analysis.
And so on.

Effects of Health Information Quality on the HIE
Explain the difference between an HIE and a national database.
Explain what problems can develop if facilities submit incomplete or inaccurate information to an HIE.
Explain what problems can develop if facilities submit incomplete or inaccurate information to a national database.
Explain how incomplete or inaccurate data may affect your proposal.

Conclusion
Briefly reinforce your paper’s main points.

Additional Requirements
Your assessment should meet the following requirements:

Excel spreadsheet: Your spreadsheet must contain three tabs, be organized, contain appropriate graphs, and have correct spelling.

Written communication: Your paper needs to be clear and well organized, with correct spelling, grammar, and syntax, to support orderly exposition of content.

Answer preview for Benchmarks and Quality Measures

APA

911 Words