302H Using Excel to Analyze Data in Health Care Environments

1
302H Using Excel to Analyze Data in Health Care
Environments
2
PRESENTERS

• Beth Budny MS RN, CNA, CRRNQM/MIS Coordinator
  Boston Healthcare System
• Heather Arredondo MSN RNNursing
  InformaticsDallas Healthcare System
• Karen Harnois BSN RN QM/MIS Coordinator Boston
  Healthcare System

3
HOUSE KEEPING
4
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.

5
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.

6
HOUSE KEEPING

• If you get lost, raise your hand

There are room assistants to help you.
7
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

8
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

9
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.

10
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

11
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

12
Log-In Instructions

• Access Code VEHU
• Verify Code VEHU

13

• Thank You

14

• Questions?