General Resources

Pre-Course Material

• HRET QMMP – James – 89 – Quality Management for Health Care Delivery
• HRET – James – 1992 – Good Enough - Standards and Measurement in Continuous Quality Improvement
• JMCP – James – Sep-Oct02 – Quality Improvement Opportunities in Health Care – Making it Easy to Do it Right
• HRET - James – 1994 – Outcomes Measurement
• MedCare 41.1 – Berwick et al – Jan03 – Connections Between Quality Measurement and Improvement
• Frontiers – Vol 7-4
• Frontiers – Implementing Practice Guidelines

Pre-Course Videos

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.3.xla. Please open Excel Homework Tutorial 1 before beginning the homework.

• Mac 2011 Tutorial.pdf 
• PC 2010 Tutorial.pdf 

To enable Excel Macro – SPC Macros AddIn rev. 1.12.4.xla

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.

Note: If you are using a Mac, you will need a previous to 2008 version or 2011 Office for Mac. 2008 Office for Mac did not include Visual Basic and will not work with our macros. Currently 2016 Office for Mac is not compatible with our macro.

• SPC Macros AddIn rev. 1.12.4.xlam 

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.

• File1 - number of pneumonia patients per week.xls
• File2 - number of nondeaths between deaths.xls
• File3 - red bead game.xls
• File4 - length of stay by delivery type.xls
• File5 - breast cancer sreening.xls