Activity: Applied Data Analytics
Learning objectives
1. Identify and use secondary data presentations (3)
2. Analyze data to identify trends (4)
3. Apply knowledge of database architecture and design (3)
4. Utilize technology for data collection, storage, analysis, and reporting of information (3)
5. Evaluate database design and data warehousing (5)
6. Apply knowledge of database querying and data exploration and mining techniques to
facilitate information retrieval (3)
7. Interpret inferential statistics (5)
Prerequisites
1. Use of Microsoft Excel® is required to complete this activity
2. This activity is the second activity in a sequential 5-activity series. Completion of the
activity below is required to successfully complete this activity:
• Orientation to Data Analytics I
Student instructions
3. If you have questions about this activity, please contact your instructor for assistance.
4. You will review a de-identified patient chart to complete this activity. Your instructor has
provided you with a link to the Applied Data Analytics II (BS) activity. Click on 2: Launch
EHR to review the patient chart and begin this activity.
5. Refer to the patient chart and any suggested resources to complete this activity.
6. 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).
, The activity
Shoreline Birth Center is a major metro birth center that delivers the most babies in the area.
According to Shoreline’s website, [Shoreline] “has long been a leader in caring for women,
children and families. Our Birth Center is a beautiful example of our commitment to providing
you with state-of-the-art healthcare in a warm, soothing environment. And as the hospital that
delivers the most babies in the metro area, our commitment to families is clear. From our
outstanding nursing and medical staff, to our state-of-the-art Level III NICU and high-risk
maternity unit, the Shoreline Birth Center takes every step to ensure you are comfortable, both
physically and emotionally, during your stay with us.”
Last week the local paper did an article on the nation's high rates of C-Section deliveries. The
journalist featured interviews with Shoreline Birth Center doctors and patients who either
performed or had undergone C-Sections. The Birth Center feels that the press will negatively
impact their bottom line and have asked you to review their data and present the facts.
You have access to the following private patient data elements via the Shoreline EHR database.
• Patient demographics
• Vital signs
• Medications
• Diagnoses
• Labs
• Active problems
• Visit dates and times
• Procedures
• Test results
• Clinical notes
Access the de-identified EHR of a Shoreline patient that accompanies this activity under 2:
Launch EHR and determine whether the data would be helpful to collect to address the public
concern. Explain your answers.
Learning objectives
1. Identify and use secondary data presentations (3)
2. Analyze data to identify trends (4)
3. Apply knowledge of database architecture and design (3)
4. Utilize technology for data collection, storage, analysis, and reporting of information (3)
5. Evaluate database design and data warehousing (5)
6. Apply knowledge of database querying and data exploration and mining techniques to
facilitate information retrieval (3)
7. Interpret inferential statistics (5)
Prerequisites
1. Use of Microsoft Excel® is required to complete this activity
2. This activity is the second activity in a sequential 5-activity series. Completion of the
activity below is required to successfully complete this activity:
• Orientation to Data Analytics I
Student instructions
3. If you have questions about this activity, please contact your instructor for assistance.
4. You will review a de-identified patient chart to complete this activity. Your instructor has
provided you with a link to the Applied Data Analytics II (BS) activity. Click on 2: Launch
EHR to review the patient chart and begin this activity.
5. Refer to the patient chart and any suggested resources to complete this activity.
6. 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).
, The activity
Shoreline Birth Center is a major metro birth center that delivers the most babies in the area.
According to Shoreline’s website, [Shoreline] “has long been a leader in caring for women,
children and families. Our Birth Center is a beautiful example of our commitment to providing
you with state-of-the-art healthcare in a warm, soothing environment. And as the hospital that
delivers the most babies in the metro area, our commitment to families is clear. From our
outstanding nursing and medical staff, to our state-of-the-art Level III NICU and high-risk
maternity unit, the Shoreline Birth Center takes every step to ensure you are comfortable, both
physically and emotionally, during your stay with us.”
Last week the local paper did an article on the nation's high rates of C-Section deliveries. The
journalist featured interviews with Shoreline Birth Center doctors and patients who either
performed or had undergone C-Sections. The Birth Center feels that the press will negatively
impact their bottom line and have asked you to review their data and present the facts.
You have access to the following private patient data elements via the Shoreline EHR database.
• Patient demographics
• Vital signs
• Medications
• Diagnoses
• Labs
• Active problems
• Visit dates and times
• Procedures
• Test results
• Clinical notes
Access the de-identified EHR of a Shoreline patient that accompanies this activity under 2:
Launch EHR and determine whether the data would be helpful to collect to address the public
concern. Explain your answers.
