Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

quay

please complete attachment

Activity: Orientation to Data Analytics

Link to Activity:


Learning objectives

1. Analyze data to identify trends (4)

2. Utilize technology for data collection, storage, analysis, and reporting of information (3)

3. Analyze statistical data for decision making (4)

Prerequisites

1. Use of Microsoft Excel® is required to complete this activity

2. This activity is the first activity in a sequential 5-activity series.

Student instructions

1. If you have questions about this activity, please contact your instructor for assistance.

2. You will review the de-identified chart that accompanies this activity. Your instructor has provided you with a link to the
Orientation to Data Analytics I (BS) activity. Click on
2: Launch EHR to review the patient chart and begin this activity.

3. Refer to the patient chart and any suggested resources to complete this activity.

4. Document your answers directly on this activity document as you complete the activity. When you are finished, you will save this activity document to your device and upload this activity document with your answers to your Learning Management System (LMS).

Introduction

This activity will evaluate a microbiology report of culture and sensitivity results for various microbes and antibiotics. Microsoft Excel® will be used to analyze and compile the data to draw meaningful conclusions.
You do not need to turn in the pivot tables you will create in this activity to your instructor. You will only turn in your answers to the questions below.

The activity

Foundational learning




Review the resource,
About Culture & Sensitivity Screening
(found under 1: Overview & Resources along with this activity document) and answer the following questions.

1. Why is a sensitivity analysis done?

2. What is needed for a sensitivity analysis?

3. How is the sensitivity analysis performed?

4. What does susceptible mean in a sensitivity analysis?

5. What does intermediate mean in a sensitivity analysis?

6. What does resistant mean in a sensitivity analysis?

Application

Review the

Culture & Sensitivity (C&S) Report
on the Notes Tab of the de-identified EHR that accompanies this activity under 2: Launch EHR and answer the following questions.

7. What was the specimen used in this C&S?

8. What organism was cultured from this specimen?

9. Which antibiotics were tested against this specimen?

10. Based on the
Culture & Sensitivity (C&S) Report in the EHR, which antibiotic(s) should the provider prescribe for this patient, and why?

Data organization & analysis

The General Hospital is conducting an internal review of the culture and sensitivity results from patients treated for infections of the urine, blood, and sputum over the last year. A report has been generated of all cultures positive for either E. coli, Streptococcus, or K. pneumoniae bacteria and the antibiotics these bacteria were sensitive to.
Open the resource

Mass Sensitivities Export

(found under 1: Overview & Resources along with this activity document) in Microsoft Excel®. A file with 5 columns of data will open. Follow the steps described below to analyze the data, then answer the related questions.

Notice that it’s difficult to see trends in the data just by viewing the data points (rows of data in the file). Pivot tables will be used to compile and summarize the data for each variable.

· Click and drag from on field 1A to field 1100E to highlight and select all of the data.

· Go to
Insert then
PivotTable. Leave the default settings and select
OK.

The pivot table building tool will open in a new tab.

First, determine which antibiotic is most effective (Susceptible) for each type of specimen. To do so, look at the number of susceptible results for each antibiotic by specimen type. A table with each specimen as a row and each antibiotic as the column is one way to view these data. To make this table:

· Click and drag the Susceptibilities field to the Filters area. This will allow view of only the Susceptible (effective) results.

· Click and drag the Specimen field to the Rows area. This will display each specimen as a row in the table.

· Click and drag the Antibiotics field to the Columns area. This will display each antibiotic as a column in the table.

· Click and drag the Susceptibilities field to the ∑ Values area. It should then appear as ‘Count of Susceptibilities’. This will populate the table with the total number of susceptibilities for each combination of specimen and antibiotic.

The resulting table should appear as follows:

Only display the results that have a Susceptibilities result of ‘Susceptible’ (meaning the antibiotic was effective). To do so:

· Select the dropdown arrow in cell B1 where it currently says ‘(All)’.

· Choose
Select Multiple Items and remove the checks so that only ‘Susceptible’ is checked. Then
OK.

Based on the resulting pivot table, answer questions 11-13 below by determining which antibiotic has the highest susceptibility count for each specimen type. Then answer questions 14-15 based on the Grand Total for each antibiotic.

Questions

11. Which antibiotic is most effective in urine-based infections? Explain.

12. Which antibiotic is most effective in blood-based infections? Explain.

13. Which antibiotic is most effective in sputum-based infections? Explain.

14. Which antibiotic is most effective overall? Explain. 

15. Which antibiotic is least effective overall? Explain. 

Now, determine which specimen has the most resistance for each type of microbe. To do so, change the Susceptibilities filter in cell B1 from ‘Susceptible’ to ‘Resistant’. Answer question 16 below.

Question

16. Which type of specimen has the most resistance? Explain. 

Next, assess which antibiotic is most effective for the various types of infections. Return to the Culture & Sensitivity Data tab and create a new pivot table. If your columns aren’t already selected, repeat that step and then choose
Insert and
PivotTable and
OK.

· Click and drag the ‘Susceptibilities’ field to the Filters area. This will allow the susceptible (effective) results to be isolated.

· Click and drag the ‘Specimen’ field to the Filters area. This will allow the type of specimen for the results to also be isolated.

· Click and drag the ‘Antibiotics’ field to the Columns area. This will display each antibiotic type as a column in the table.

· Click and drag the ‘Microbes’ field to the Rows area. This will display each microbe type as a row in the table.

· Click and drag the ‘Susceptibilities’ field to the ∑ Values area. This will populate the table with the total number of susceptibilities for each microbe and antibiotic combination.

· Specify the susceptibility of ‘Susceptible’ in cell B1 to display only the effective results.

· Specify the specimen of ‘Urine’ in cell B2 to display only the results for urine.

Use the results in the pivot table to answer question 17 below.

Question

17. Which antibiotic would you recommend be tried with a urine-based E. coli infection? Explain. 

· Change the specimen filter (cell B2) from Urine to
Blood and answer question 18.

Question

18. Which antibiotic would you recommend be tried with a blood-based Streptococcus infection? Explain. 

Lastly, determine if overall age plays a role in susceptibilities. Return to the original Culture & Sensitivity Data set tab and insert a new pivot table again. Follow the steps below:

· Click and drag the ‘Susceptibilities’ field to the Filters area. This will allow the susceptible (effective) results to be specified.

· Click and drag the ‘Age’ field to the Rows area. This will display each age as a row in the table.

· Click and drag the ‘Susceptibilities’ field to the ∑ Values area. It should show as ‘Count of Susceptibilities’. This will populate the table with the total number of susceptibilities for each age.

· In the Susceptibilities filter (cell B1), specify ‘Susceptible’. The resulting table should appear as follows.

When analyzing ages and/or dates, it’s often helpful to group them by ranges. In this case, group the ages by 10 to display the results for people in their 20s, 30s, 40s, etc. To do so:

· Click on one of the ages in Column A. For example, age 18 in cell A4. Choose
Analyze and
Group Field as demonstrated in the screenshot below.

· Group by 10 starting at 20 and ending at 100.

Answer question 19 below based on the results. Disregard the data for <20 as that segment only includes 2 years (18 and 19) whereas the rest includes 10 years.

Question

19. Does age make a difference in susceptibilities? Explain.

Critical Thinking Question

20. Summarize your findings in 100 words or less to share with the General Hospital administration.

Submit your work

Document your answers directly on this activity document as you complete the activity. When you are finished, save this activity document to your device and upload this activity document with your answers to your Learning Management System (LMS). If you have any questions about submitting your work to your LMS, please contact your instructor.

References

Healthline. Sensitivity Analysis: Purpose, Procedure, and Results. Medically reviewed by Steve Kim, MD on February 24, 2016 — Written by Christine Case-Lo and Brian Wu. Available at

EHR Go Knowledge Activity: Orientation to Data Analytics I (Baccalaureate) HBK1023.1

1

Archetype Innovations LLC ©2019

image3.png

image4.png

image5.png

image6.png

image7.png

image8.png

image9.png

image10.png

image11.png

image12.png

image13.png

image1.png

image2.png

image14.jpg

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Education EHR Assignment

Assume that you are a health care administrator who oversees a small conglomerate of local clinics. After the recent acquisition of a physical therapy clinic, it was brought to the attention of key stakeholders that the clinics were all operating with different electronic health records software, which was affecting interoperability

question assigment

1 2 Title Student’s name Instructor Course Date Module 1 Discussion: Self-Introduction 1. Summary of My Education and Career Goals Hi everyone.  I am (name), and I am currently studying for my Master of Science in Education and Special Education at Touro College. I have education experience with a background

question assigment

650 Module 4 Assessment: Create an Inquiry-Based Online Learning Activity Instructions  Assignment For this assignment, you will create an inquiry-based online learning activity that aligns with the unit you are designing. You may choose to use Google Slides, Prezi, HyperDocs (guidesLinks to an external site.) or Wakelet (guidesLinks to an

question assigment

650 Module 3: Adaptive Learning Technologies Instructions: 1. Explore the adaptive platforms listed below. Alternatively, you can use any similar platform familiar to you but not listed here. 2. Login with your Google account or create a free account with that platform; 3. Choose an activity that fits within your

question assigment

650 Discussion Topic : Module 3 Discussion: Assistive TechnologyModule 3 Discussion: Assistive Technology Module 3 Discussion: Directions: Post your initial response within in 1-2 days from the module start, and post 2 to 3 responses before the end of the module. Discussion Session 3: 1. Which 4 assistive technology features, built

question assigment

650 Module 2: Initial LMS Digital Classroom The culminating project for this course is to create an interactive, fully-functioning digital classroom on a learning management system (Google Classroom). Over the course of the semester, you will create learning activities using various educational technology tools. The activities you create will be

question assigment

650 Module 2 Discussion: Introduction to Educational Technology Discussion Topic: Module 2 Discussion: Introduction to Educational TechnologyModule 2 Discussion: Introduction to Educational Technology Module 2 Discussion: Directions: Post your initial response, within in 1-2 days from the session start, and post 2 to 3 responses before the end of the session. 1. Using examples

question assigment

Please complete the assignment by answering the following Baseline Survey questions in a  MS Word document format (.doc or .docx): 1. Rate your current knowledge on the Rubric for Effective Teacher Technology Use. See the attached document: johnson_rubric.pdf  Download johnson_rubric.pdf  Johnson_Rubric_Editable.docx Download Johnson_Rubric_Editable.docx You can download word document, highlight your level for

question assigment

650 : Module 1 Discussion: Introduce Yourself Module 1 Discussion: Directions: Post your responses to the following: 1. Provide a summary of your education and career (or future career goals.) 2. Copy and paste your Assignment 1 Baseline Survey.   · What do we already know about instructional technology? (Comment on your

question assigment

650 : Module 1 Discussion: Introduce Yourself Module 1 Discussion: Directions: Post your responses to the following: 1. Provide a summary of your education and career (or future career goals.) 2. Copy and paste your Assignment 1 Baseline Survey.   · What do we already know about instructional technology? (Comment on your

question assigment

1. Classmate 2. Hi everyone! My name is Shannon Dowling. I am currently a certified teacher in elementary education and students with disabilities for grades 1-6. I am looking to expand my certification to early childhood education, which is the reason I am taking this course.  One of my favorite

question assigment

1. First classmate T.K My knowledge, skills, and dispositions of early childhood education is evolving everyday. The responsibilities I hold, especially in regards to accommodating diverse learners, is something that I do not take lightly. I am furthering my education by taking courses like this to develop my understanding and

Brochure/Newsletter

  Brochure/Newsletter: Create a family-friendly brochure or newsletter. It should: Summarize child development targeting a particular age AND a specific domain of development Recommend specific activities or materials to enhance children’s learning, growth, and development in this developmental domain. Provide Internet addresses for two family-friendly websites with information about development in

Chapter 11 & 12 DQ

See attachment for instructions! Chapter 11 Discussion Question The director of an early childhood center decided that authentic assessment took too much time and that administering a standardized literacy assessment in the pre-K year would show the quality of her program if the children scored well. What concerns would you

question assigment

I. Critical Review/Analysis of Websites. Due Module 4. 20% of the course grade (LO #5) Explore the Internet for resource websites! 1. Critically analyze 3 websites. Select two (2) that would be especially helpful in the Birth-Grade 2 classroom for teachers and one (1) that would be particularly helpful for parents.

question assigment

MODULE 2 Discussion: Journal Entry #1 – Policies & Practices Regarding Diverse-Learner Needs Policies & Practices Regarding Diverse-Learner Needs Summarize and describe how your knowledge, skills and dispositions for early childhood pedagogy is evolving  with regards to accommodating diverse learners.  Refer to what you have gained from assigned readings and articles

question assigment

MODULE 1 Discussion: Introductions Please use this discussion forum to introduce yourself to your peers by including the following information: About me, I have already taken this professor before, this is my second class, please use my information, I was used before class Hello everyone! My name is G, and

discussion response

Discussion 1 Part 1 Over the years, I have had many goals and motivators aligned with my vision for life. Now that I am further along in my career, my goals have become more concrete; one of my professional goals is to be a leader in the community and step