Activity: Orientation to Data Analytics
Link to Activity: https://web21.ehrgo.com/rd/?courseActivityId=13691
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.
EHR Go Knowledge Activity: Orientation to Data Analytics I (Baccalaureate) HBK1023.1 1
Archetype Innovations LLC ©2019
, 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? The specimen used in the C&S was urine.
8. What organism was cultured from this specimen? The organism cultured from this
specimen was Escherichia Coli.
9. Which antibiotics were tested against this specimen? The antibiotics tested against this
specimen are Tetracycline, Ampicillin, Cefpodoxime, Cephalexin, Ciprofloxacin,
Nitrofurantoin, and Tri/Sulfa.
10. Based on the Culture & Sensitivity (C&S) Report in the EHR, which antibiotic(s) should the
provider prescribe for this patient, and why? Based on the culture sensitivity report,
the provide should prescribe Nitrofurantoin because the C&S report indicates that the
cultured organism is susceptible to this antibiotic, meaning the antibiotic will likely kill
the bacteria or at least prevent it from growing/spreading.
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
EHR Go Knowledge Activity: Orientation to Data Analytics I (Baccalaureate) HBK1023.1 2
Archetype Innovations LLC ©2019
Link to Activity: https://web21.ehrgo.com/rd/?courseActivityId=13691
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.
EHR Go Knowledge Activity: Orientation to Data Analytics I (Baccalaureate) HBK1023.1 1
Archetype Innovations LLC ©2019
, 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? The specimen used in the C&S was urine.
8. What organism was cultured from this specimen? The organism cultured from this
specimen was Escherichia Coli.
9. Which antibiotics were tested against this specimen? The antibiotics tested against this
specimen are Tetracycline, Ampicillin, Cefpodoxime, Cephalexin, Ciprofloxacin,
Nitrofurantoin, and Tri/Sulfa.
10. Based on the Culture & Sensitivity (C&S) Report in the EHR, which antibiotic(s) should the
provider prescribe for this patient, and why? Based on the culture sensitivity report,
the provide should prescribe Nitrofurantoin because the C&S report indicates that the
cultured organism is susceptible to this antibiotic, meaning the antibiotic will likely kill
the bacteria or at least prevent it from growing/spreading.
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
EHR Go Knowledge Activity: Orientation to Data Analytics I (Baccalaureate) HBK1023.1 2
Archetype Innovations LLC ©2019
