Benchmarks and Quality Measures

i marked this paper as 5 pages for payment purposes.  3 pages for the written portion and the extra money for the excel part.  let me know if additional payment is needed.  Thank you



Identify the benchmarks and quality measures used to compare with the office data for your proposal (Excel spreadsheet). Assess the compatibility of the proposed data and examine potential issues related to information quality (1-3 pages).


A key part of your proposal will be to identify benchmarks and trends for the topic you have chosen for your documentation review. Benchmarks can come from national or state quality standards or trends. If your proposal is approved, you as the office manager will want to try to answer this question: How does our office data compare to national or state trends?

You need to identify your benchmarks before you can collect and then compare the data. You decide what your benchmarks are. They could be based on national averages, state averages, or quality standards. For example, here is one quality standard: All patients with chronic, stable coronary artery disease are on an antiplatelet therapy or have supporting documentation as to why they cannot take an antiplatelet therapy. For instance, they may have an allergy.

Another question to consider when establishing benchmarks is this: Are you comparing apples to apples or apples to oranges? In addition, if you are retrieving information from a national database or data from an HIE, how do you know your office data is comparable to the information you are retrieving? Consult your suggested resources for answers to these questions.

For this second assessment, you are to:

  • Analyze statistical trends and assess quality measures relevant to your proposal.
  • Assess the compatibility of data drawn from multiple sources.
  • Determine the effects of health information quality on an HIE.

This assessment is completed in three steps:

  1. Step One – Preparation: Locate data related to quality measures or trends relevant to your topic from specific websites.
  2. Step Two – Data Collection: Create a data collection tracking spreadsheet and dashboard.
  3. Step Three – Data Compatibility: Write a short paper on data compatibility and quality.

Please study this assessment’s scoring guide to better understand the performance levels relating to each criterion on which you will be evaluated.


Step One: Preparation

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

Step Two: Data Collection

Using the 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.). Healthcare cost and utilization project.
    • Centers for Disease Control and Prevention. (n.d.). CDC WONDER.
    • 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.


  • 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.


  • 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 does not need to be in APA format. It does need to be clear and well organized, with correct spelling, grammar, and syntax, to support orderly exposition of content.
  • Title page: Develop a descriptive title of approximately 5–15 words. It should stir interest yet maintain professional decorum.
  • References: Include a minimum of two citations of peer-reviewed sources in current APA format.
  • Length: 1–3 typed, double-spaced content pages, not including the title page and references page.
  • Font and font size: Times New Roman, 12 point.

Competencies Measured

By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and scoring guide criteria:

  • Competency 4: Determine how a health information exchange (HIE) or other external health care databases affect the management of patient data, clinical knowledge, and population data.
    • Assess the compatibility of data from multiple sources.
    • Explain the effects of health information quality on an HIE.
  • Competency 5: Apply quality and change management concepts to health care information management.
    • Analyze statistical trends relevant to a selected condition.
    • Assess quality measures relevant to a selected condition.
  • Competency 6: Communicate in a manner that is scholarly, professional, respectful of the diversity, dignity, and integrity of others, and is consistent with the expectations for healthcare professionals.
    • Write clearly, with correct spelling, grammar, and syntax, and good organization.
    • Apply proper APA formatting and style to citations and references.
3 replies
  1. says:

    I have read your article carefully and I agree with you very much. This has provided a great help for my thesis writing, and I will seriously improve it. However, I don’t know much about a certain place. Can you help me?

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *