Knowledge Activity: Orientation to Data
Analytics I 2.0
Part A
Prerequisites
Questions
1. Identify & list at least three data quality issues in the dataset. The three data issues that
are easy to spot: many different capitalization errors in E. coli (e. coli), the same goes
for K. pneumonia, and lastly, the word “inter” should be “intermediate.”
2. Why must these issues be addressed before conducting analysis? These issues must be
addressed to avoid confusion in grouping, such as duplicate groups for the same
microbe due to a spelling or punctuation error.
3. Choose one issue and describe the exact steps you took in Excel to clean it. The one easy fix
was to highlight the chart, sort A-Z so that I could group all the “inter” together, then
highlight those columns, CTRL+H, and replace with “intermediate”.
4. Once you’ve completed cleaning the Mass Sensitivities EHR data, rename and save the
document to your computer to submit as a final step of this activity.
Section II.
To learn more, review the resource, Antimicrobial Susceptibility (found under 1: Overview &
Resources along with this activity document) and answer the following questions.
5. What is the main purpose of Antimicrobial Susceptibility Testing (AST)?
a. To monitor how often infections occur in a hospital
b. To identify the type of bacteria causing an infection
c. To determine which antibiotics are effective against specific bacteria
d. To track side effects of antibiotic medications
EHR Go Knowledge Activity: Orientation to Data Analytics I 2.0 Part A IK1023.5
Archetype Innovations LLC ©2026 1
Analytics I 2.0
Part A
Prerequisites
Questions
1. Identify & list at least three data quality issues in the dataset. The three data issues that
are easy to spot: many different capitalization errors in E. coli (e. coli), the same goes
for K. pneumonia, and lastly, the word “inter” should be “intermediate.”
2. Why must these issues be addressed before conducting analysis? These issues must be
addressed to avoid confusion in grouping, such as duplicate groups for the same
microbe due to a spelling or punctuation error.
3. Choose one issue and describe the exact steps you took in Excel to clean it. The one easy fix
was to highlight the chart, sort A-Z so that I could group all the “inter” together, then
highlight those columns, CTRL+H, and replace with “intermediate”.
4. Once you’ve completed cleaning the Mass Sensitivities EHR data, rename and save the
document to your computer to submit as a final step of this activity.
Section II.
To learn more, review the resource, Antimicrobial Susceptibility (found under 1: Overview &
Resources along with this activity document) and answer the following questions.
5. What is the main purpose of Antimicrobial Susceptibility Testing (AST)?
a. To monitor how often infections occur in a hospital
b. To identify the type of bacteria causing an infection
c. To determine which antibiotics are effective against specific bacteria
d. To track side effects of antibiotic medications
EHR Go Knowledge Activity: Orientation to Data Analytics I 2.0 Part A IK1023.5
Archetype Innovations LLC ©2026 1
