# Presentation: 319650

## 302H Using Excel to Analyze Data in Health Care Environments 

## Beth Budny MS RN, CNA, CRRNQM/MIS Coordinator Boston Healthcare System 
Heather Arredondo MSN RNNursing InformaticsDallas Healthcare System 
Karen Harnois BSN RN QM/MIS Coordinator Boston Healthcare System

- Heather Arredondo MSN RNNursing InformaticsDallas Healthcare System
- Karen Harnois BSN RN QM/MIS Coordinator Boston Healthcare System

- _PRESENTERS_

## HOUSE KEEPING

## HOUSE KEEPING

- This is 1.5 Hours Hands-On class
- Restrooms are located...
- Cell Phones
- Please turn off or change to vibrate
- 	If you must answer a call, please leave the room.

**Notes:**
Before we get started we need to take care of some Housekeeping issues. Restrooms are located..
If you have any questions please write them on the 3X5 card provided. Answers to your questions will be posted on the VEHU website. So please check the website when you return home.

## HOUSE KEEPING

- Please,
- No questions during the presentation.
- Questions written on the 3X5 card will be answered at the conclusion of the presentation.
- For questions not answered,
- the question and the answer will be available on the web.

**Notes:**
Before we get started we need to take care of some Housekeeping issues. Restrooms are located..
If you have any questions please write them on the 3X5 card provided. Answers to your questions will be posted on the VEHU website. So please check the website when you return home.

## HOUSE KEEPING

- If you get lost, raise your hand

- There are room assistants to help you.

**Notes:**
Before we get started we need to take care of some Housekeeping issues. Restrooms are located..
If you have any questions please write them on the 3X5 card provided. Answers to your questions will be posted on the VEHU website. So please check the website when you return home.

## OBJECTIVES

- Understand the importance of processing and converting data into information
- Import data from external sources
- Perform tasks such as formatting, organizing and sharing data
- Perform calculations in a worksheet using statistical functions and formulas such as SUM, AVERAGE, MEDIAN, MIN, and MAX and the AutoSum features
- Create charts and graphics to present data

## WHY TURN DATA INTO INFORMATION

- Improve the quality and safety of healthcare
- Implement best practices
- Improve veteran and family satisfaction
- Encourage innovation
- Promote administrative, financial, and clinical efficiencies
- Focus research and development on clinical and system improvements

**Notes:**
It is the VA’s mission to improve the health and well-being of America’s veterans; to be a patient centered integrated, healthcare organization that provides excellence in research and education. In order to meet our goals of improving the quality and safety of healthcare, of implementing best practices, of improving veteran and family satisfaction, of encouraging innovation, of promoting administrative, financial, and clinical efficiencies, and of focusing research and development on clinical and system improvements, we must continually understand and measure quality of care in terms of structure, process, and outcomes and design and test interventions to change processes and systems of care with the objective of improving quality.

## Why Use Microsoft Excel

- Run powerful **queries** that can sort and filter your data.
- Run sophisticated **calculations** to derive the information you want.
- Use **pivot tables **to work with your data interactively.
- Generate **reports** on your data and view them in multiple formats.

**Notes:**
We utilize informatics to communicate, to manage knowledge, to mitigate error and to support decision making.  Today we will use Microsoft Excel to import external data from CPRS Query but you can also import data from Vista reports. Then we will use Microsoft Excel to view and edit the imported data.  Once the data is on the Microsoft Excel spreadsheet, you will be able to: 
1.  Run powerful queries that can sort and filter your data. 2.  Run sophisticated calculations to derive the information you want. 3.  Use pivot tables to work with your data interactively. 4.  Generate reports on your data and view them in multiple formats. 

## DATA EXTRACTION

- VISTA reports
-     - Canned reports:
- 		a. Consult tracking
- 		b. Clinic workload
- 		c. Progress note tracking
- - FileMan reports:
- 		a.  Order verification
- 		b.  Height/weight tracking
- 		c.  PRN effectiveness
- 		d.  Missed medications

**Notes:**
There are several methods of data extraction which are easy and will be of great interest to nurses.  Data gets stored in the VISTA system and can be extracted to generate either a canned report or FileMan report.Canned reports in Vista are pre-existing reports that already have a template created with populated data.  Some examples of canned reports are:
1.  Consult tracking 
2.  Clinic workload tracking
3.  Progress note tracking

FileMan reports in Vista are created based on criteria selected. However FileMan access is limited to select staff.  Some of the FileMan reports that we have created at the Boston VA are:1.  Order verification
2.  Height/weight tracking
3.  PRN effectiveness
4.  Missed medications

## DATA EXTRACTION

- CPRS Query Tool
-            -Pre-defined (canned) reports
- 		a.  Abnormal Results
- 		b.  Consult Status
- 		c.  Incomplete Orders
- 		d.  Recent Activity of patients with orders and          documents created within the past 24 hours
- 		e.  Scheduled/Due Activity of patients with           orders or consults that are pending or           scheduled
- 		- Customized Reports

**Notes:**
Another source from which data can be extracted is the CPRS query tool.  The query tool allows you to create reports derived from patient data.  Based on a patient cohort and other defined report criteria, the tool searches across the population of patients to produce reports. The CPRS Query Tool has five pre-defined queries. The five predefined or canned reports are for:
Abnormal Results
Consult Status 
Incomplete Orders
Recent Activity of patients with orders and documents created within the past 24 hours.
Scheduled/Due Activity of patients with orders or consults that are pending or scheduled
Custom reports, on the other hand, do not have predefined criteria.  You would need to define the criteria based on the information you want displayed in your report. 

## Log-In Instructions

- Access Code:  ##VEHU
- Verify Code:    VEHU##

## Thank You

## Questions?