Blueprints are used by others besides architects. New home buyers may use the blueprint of their future home to better understand the architect’s vision and to consult with the architect on changes. Municipalities will use the blueprint to issue building permits. Builders will use it to plan construction and estimate costs.

Likewise, you don’t have to be a database designer to apply visual tools such as database diagrams. For example, creating or studying a database diagram can help you, as a leader in a healthcare organization, understand the data needs of the organization or of your team.

This is in turn can create efficiencies and drive improvements at varied levels of patient care. As a nurse, database diagrams can help you analyze the data structure and how to make best use of the available data and functionality in the provision of care. At every level of an organization, an understanding of database diagrams can help in providing feedback to database managers that in turn can help drive improvements.

In your Module 2 Assignment, you create a database diagram for the database that you proposed in the Week 3 Discussion and built upon in the Week 4 Discussion. You also create a PICOT question to be used to search your proposed database. Finally, you develop an analysis of your database design, explaining the proposed structure and design elements while justifying your approach.

To prepare:

• Review the Learning Resources.
• Review your posts from the Weeks 3 and 4 Discussions and the scenario on which they are based.
• Consider a clinical research question you might ask that could be informed by the data in your database.
• Restate your clinical question as a PICOT question.

Assignment (2- to 3-page paper and a diagram of a database as an appendix):

Using the scenario from Week 3, create a diagram of your proposed database using Microsoft Word.

• Include the additions made in Week 4.
• Complete the diagram first, but place it as the final page or pages of your submission. The diagram is separate from the required page count.

In the narrative portion of the assignment:

• Explain how your diagram articulates your planned design.
• Explain the principles behind selecting key fields and defining relationships. Be specific and support your response with evidence.
• Write a sample PICOT question (i.e., a query) you might ask based on the information in the database created during Weeks 3 and 4 to demonstrate your understanding of the connection between data and research.
• List the tables in the database that you would need to include when answering your question.

 This assignment will incorporate a common practical tool in helping clinicians begin to ethically analyze a case. Organizing the data in this way will help you apply the four principles and four boxes approach.

Based on the “Case Study: Healing and Autonomy” and other required topic study materials, you will complete the “Applying the Four Principles: Case Study” document that includes the following:

Part 1: Chart

This chart will formalize the four principles and four boxes approach and the four-boxes approach by organizing the data from the case study according to the relevant principles of biomedical ethics: autonomy, beneficence, non maleficence, and justice.

Part 2: Evaluation

This part includes questions, to be answered in a total of 500 words, that describe how principalism would be applied according to the Christian worldview.

Remember to support your responses with the topic study materials.

APA style is not required, but solid academic writing is expected. 

At the completion of your intervention, you will produce a 5–8 minute video discussion script of your care coordination intervention for a peer-reviewed media platform. 
As an advanced practice health care provider, it’s likely that you will be asked to give a presentation at some point in your career. Now that you have completed this project, it’s time to disseminate the outcomes in the form of a recorded professional presentation. A professional presentation style requires the confidence and ability to convey the right image that you want your audience to see. Unfortunately, it’s easy to miss some of the opportunities available to help you present yourself in the best possible light and, as a result, enjoy the success you deserve. Remember to be forthright about what happened during the project and about how data were collected and analyzed, and present the findings so stakeholders and external parties clearly understand the steps in the process. By completing this final activity, you can help others recreate this type of project and enhance outcomes in other patient care settings.

Assessment Instructions

In Assessment 3, you will build on the work you completed in Assessments 1 and 2.
Assignment Summary
This assessment requires you to prepare a 5–8 minute video discussion script of your care coordination intervention. Note: If you require the use of assistive technology or alternative communication methods to participate in this activity, please contact DisabilityServices@Capella.edu to request accommodations. If you are unable to record a video, please contact your faculty member as soon as possible to explore options for completing the assessment.
You have completed the intervention and achieved enhanced outcomes. Now you need to disseminate your findings and provide recommendations to sustain the results of your intervention. You have been asked by nursing leadership to produce a scholarly video for a peer-reviewed media platform. The video will include 5–8 minutes of scholarly discussion covering the topics listed below.
Grading Criteria
The numbered assignment instructions outlined below correspond to the grading criteria in the Disseminating the Evidence Scholarly Video Media Submission Scoring Guide, so be sure to address each point. You may also want to review the performance level descriptions for each criterion to see how your work will be assessed.

1. Analyze care coordination efforts related to clinical priorities based on a PICOT question. 
   • Provide the PICOT question and a brief introduction of the issues.
2. Describe the change in practice related to services and resources that will be available for the interprofessional care coordination team. 
   • Describe the key care coordination efforts.
3. Explain efforts to build stakeholder engagement within the interprofessional team. 
   • How did you lead the change in practice?
   • Summarize how you encouraged and built stakeholder engagement.
4. Recommend next steps that that support thoughtful resource utilization and a safe environment in care coordination. 
   • Propose how you will sustain the current outcomes with the coordinated care interprofessional team.
   • Make recommendations on moving forward that support thoughtful resource utilization and a safe environment.
5. Produce a video that provides insight, understanding, and reflective thought about care coordination.
6. Communicate audibly and professionally, using proper grammar and including a reference list formatted in current APA style.
7. Important Note: but do address each scoring guide criterion in the video, including a discussion of authors in the literature who support the ideas presented. Please submit a separate APA-formatted reference list for the resources discussed in your reflection.
   Additional Requirements 

• Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately.
• APA guidelines: Resources and citations are formatted according to current APA Style and Format. When appropriate, use APA-formatted headings.

 

Evidence translation begins with the identification of a problem or concern. Reflect upon the eight national practice problems presented in the Global Burden of Disease Research. Select one of the practice problems to address the following.

1- From a global/nationwide perspective, how does the selected practice problem impact nurses, nursing care, healthcare organizations, and the quality of care being provided?

2- Identify the national level key stakeholders who are affected by the practice problem and stakeholders involved in resolution.

3-Are clinical practice guidelines used to address this problem? Why or why not? If used, provide a brief overview of the CPG. If a CPG is not used, propose an intervention that could be implemented on a national scale to address the problem.

  

Please answer these questions separated and use at least 3 sources no later than 5 years and you can use the sources below.

 

Please read the discussion question above carefully to answer all components.  Our resources available to support your learning and work in our discussions this week are:

·   Our Chamberlain Week 1 lesson: The Practice Problem: National Issues and Nonresearch Evidence
and Appraisal of Nonresearch Evidence and Stakeholder Roles

·  The Global Burden of Disease Research Links found in your week 1 student lesson plan- scroll down to access the links to this research!!

·         Dang and Dearholt (2018):  ·          

o             Chapter 1: Evidence-Based Practice: Context, Concerns, and Challenges

o             Chapter 7: Evidence Appraisal: Nonresearch

o             Appendix F: Nonresearch Evidence Appraisal Tool

White, Dudley-Brown, and Terhaar (2016): ·          

o             Chapter 4: Translation of Evidence to Improve Clinical Outcomes

Our interactive discussion addresses the following course outcomes:

·         Investigate practice problems relevant to advanced nursing practice. (POs 1, 3, 4, 5, 6, 9)

·         Appraise practice problems at the micro, meso, and macrosystems levels. (POs 2, 3, 4, 5, 6, 9)

·         Examine the role of stakeholders in change and translation science. (POs 1, 4, 6)

·         Assess challenges and barriers related to evidence translation. (POs 3, 5, 9)

Chamberlain College of Nursing. (2019). NR-701 Week 1: The Practice Problem: National Issues and Nonresearch Evidence [Online lesson]. Downers Grove, IL: Adtalem.

Dang, D., & Dearholt, S. L. (2018). Johns Hopkins nursing evidence-based practice: Model and guidelines (3rd ed.). Indianapolis, IN: Sigma Theta Tau International.

White, K. M., Dudley-Brown, S., & Terhaar, M. F. (2016). Translation of evidence into nursing and health care (2nd ed.). New York, NY: Springer Publishing Company.

 

• Morbidity and mortality, Years Lived with Disability (YLLS), QALYs (Quality-Adjusted Life Year) and DALYs (Disability-Adjusted Life Year) From the WHO:https://www.who.int/quantifying_ehimpacts/publications/en/9241546204chap3.pdf (Links to an external site.) 
• (2020). Health statistics and information systems. Retrieved from https://www.who.int/healthinfo/global_burden_disease/metrics_daly/en/ (Links to an external site.)  
• (2020). Health statistics and information systems: Disability weights, discounting and age weighting of DALYs. Retrieved from https://www.who.int/healthinfo/global_burden_disease/daly_disability_weight/en/ (Links to an external site.)

Guides and tutorials on the Global Burden of Disease

The best resource to use to find incidence, prevalence, etc. by cause (or disease) is the GBD Results Tool: http://ghdx.healthdata.org/gbd-results-tool (Links to an external site.) (Links to an external site.)

This tool allows users to query our estimates from the latest round of the Global Burden of Disease study, GBD 2017. 

            – The GBD Results Tool User Guide: This contains help for common questions and

              troubleshooting

            – Codebook: This ZIP file contains a codebook file with the IDs AND names for all

               encoded values in the  tool, along with other useful documentation, such as a

               measure and metric definitions

            – Tools Overview: This file is a PDF guide to our data tools which also includes all

                variable names and  IDs, a glossary, and more

The GBD Results Tool includes estimates at the US state, but not county, level.

You can find our US county-level data collected on the US Data page here (may be older data): http://ghdx.healthdata.org/us-data (Links to an external site.) (Links to an external site.)

For more on searching the GHDx, please refer to the following resources:

   – Two brief introductory videos on browsing and searching the GHDx: http://ghdx.healthdata.org/help/ghdx-instructional-videos (Links to an external site.) (Links to an external site.)

    – More detailed search tips: http://ghdx.healthdata.org/help/searching-ghdx (Links to an external site.) (Links to an external site.)

Reference:

The U.S. Burden of Disease Collaborators. (2018). The state of U.S. health, 1990–2016 burden of diseases, injuries, and risk factors among U.S. states. JAMA, 319(14), 1444–1472. https://doi.org/10.1001/jama.2018.0158