Pre-Course Readings

Please read/watch the following articles and webcasts prior to attending the course:

Pre-Course Videos

(Click on title to view/stream video.  Click the download link to save the video to your computer.  You may need to right click the link and select 'save target as' to avoid opening the video by default.)
  
 
Brent C. James, MD, MStat
Length: 34 minutes 04 seconds
 
Presentation Objectives: 
  • Course overview.
  • Description of required quality improvement project.
  • Course logistics. 
 
 
Brent C. James, MD, MStat
Length: 41 minutes 35 seconds
 
Presentation Objectives: 
  • Committee vs. Teams dynamics.
  • Features of an effective team: safe, inclusive, open, consensus seeking, etc.
  • Ideal team members.
  • PDSA within teams. 
  
 
Brent C. James, MD, MStat
Length: 35 minutes 39 seconds
 
Presentation Objectives: 
  • Describes causal links between quality and cost.
  • List areas of quality waste, the cost of poor quality.
  • Define limited resource utilization; production vs. efficiency.
  • Describe the optimalist - maximalist argument; the implications of cost pressures for the healthcare system. 

Week One Preparation

For the first week of the program, please come prepared (if you can) with the following:

  • Title of your Quality Improvement Project (emailed to Ann Ward)
  • Why you selected this project (why it is important)
  • Who will be on the team
  • A simple global mission statement for your project
  • Preliminary data for project evaluation

These steps are the beginning steps of the quality project. You will use each of these steps in a PowerPoint presentation summarizing your project. During the fourth week each participant will present a PowerPoint illustrating their process improvement project and its results. Each presentation will be allotted 15 minutes with 5 minutes of Q & A after and will give fellow classmates a wide range of applications.

Excel Homework

The files you need for the homework are listed below. You will need to save the files to your hard drive. Right click on the file name and select "Save Target As" from the popup menu. This will save as a zipped file. You will need to run an extraction program (PKUNZIP or Compressed Folders Extraction Wizard) to extract the file to SPCMacrosAddInRev1.12.4.xlam. Please open Excel Homework Tutorial before beginning the homework.


To enable Excel Macro – SPC Macros AddIn rev. 1.12.4.xlam
You may need to lower your Excel security to enable the 'macro'. To do this, open up Excel and go to TOOLS at the top of the window in the standard toolbar. Next, go to MACRO, SECURITY, SECURITY LEVELS and lower to MEDIUM. You can choose whether or not to run potentially unsafe macros. **If you are using a Mac, you will need to use 2011 Office for Mac or newer. 2008 Office for Mac did not include Visual Basic and will not work with our macros.

The following are data files to be used within the homework assignment. Please refer to the tutorial for more information on how to use the files.

Session 1 Excel Assignment

  • Review the SPC Macro Tutorial (above) and complete the homework using the 5 Excel files (above).
  • Using your own QI project data or dry lab (made-up) data, create and SPC Control Chart using the Excel Macro (above) 

Session 2 Excel Assignment

    • Review the SPC Macro Tutorial (above) and complete the homework using the 5 Excel files (above).
    • Using your own QI project data or dry lab (made-up) data, create and SPC Control Chart using the Excel Macro (above) 
Copyright © , Intermountain Healthcare, All rights reserved.