Concepts of Nursing III (BSN 346) : Concept Map Assignment Worksheet V2 Practice map layout.

Purpose

The following activity is designed to provide you with the opportunity to practice analyzing data and
creating data visualizations.



Objectives

• Using Excel, analyze the data provided
• Summarize your findings including the average age, gender distribution, and the prevalence
of falls, CAUTIs, medication errors, and MRSA in your dataset
• Using Excel, create data visualizations including a pivot table, bar chart, pie chart, line chart,
and a stacked column chart




Overview

This semester you will be completing a Data Storytelling Hallmark project.

Part of that project includes analyzing data and creating data visualizations.

This activity is designed for practice. You will be provided with a sample dataset and will be guided
through the steps for analyzing data, interpreting/summarizing data, and creating data visualizations.

To receive credit for this activity, please complete (instructions below) and submit this document to
Canvas.

, Data Analysis
Dataset

This dataset includes patient information such as age, gender, falls, catheter-associated urinary tract infections (CAUTIs), medication errors, and
methicillin-resistant Staphylococcus aureus (MRSA) infections.

Table

Patient ID Age Gender Falls (Yes/No) CAUTIs (Yes/No) Medication Errors (Yes/No) MRSA (Yes/No)


1 65 Female Yes No Yes No


2 70 Male No Yes No Yes


3 55 Female Yes No No No


4 80 Male No Yes Yes No


5 60 Female Yes No Yes Yes


6 75 Male No Yes No No

Instructions

1. Open the Excel workbook and save it to your computer.

o Open the Excel dataset.

Note: The following instructions will walk you step-by-step through the process of calculating descriptive statistics, creating a pivot table,
visualizing, analyzing, and interpreting the date.