Skip to main content
Skip header

Computer Aided Quality Management

Type of study Doctoral
Language of instruction Czech
Code 639-0937/01
Abbreviation PPMK
Course title Computer Aided Quality Management
Credits 10
Coordinating department Department of Quality Management
Course coordinator Ing. David Vykydal, Ph.D.

Subject syllabus

• The importance of computer aid in the field of quality management. Types of used software. Information systems of quality management.
• Specialized software in the field of computer aided quality management.
• Spreadsheet Excel and possibilities of its use for quality management tasks solution.
• Work with data files, data import and export. Data verification. Data sorting and filtering.
• Work with tables. Conditional formatting. Calculations in Excel, use of relative and absolute addresses.
• Exploratory data analysis. Graphical presentation of data.
• Excel functions and their use in the quality management.
• Excel analytical tools.
• Contingency tables and their use in the quality management.
• Processing of special Excel applications.
• Selected statistical software and their suitability for solving problems in the field of quality management.
• Characteristics of software Minitab and possibilities of its use in quality management.
• Working with Minitab worksheets and Minitab projects, data import and export.
• The calculations in Minitab, creating new variables. Selected operators and their use in quality management.
• Data filtering and sorting. Exploratory data analysis.
• Hypothesis Testing in Minitab (testing normality, goodness of fit tests, t -test, F -test).
• Regression and correlation analysis in Minitab.
• Special tasks in the field of quality management (cause and effect diagram, Pareto analysis, measurement system analysis).
• Special tasks in the field of quality management (process capability analysis, statistical process control).
• Other special software for various fields of quality management (Statgraphics, QC Expert, Palstat etc.).

Literature

MONTGOMERY, D. C. Introduction to Statistical Quality Control. 7th edition. Hoboken: Wiley, 2013. ISBN 0-471-31648-2.
WALKENBACH, J. Microsoft Excel 2016. Bible. Indianopolis: Wiley Publishing Inc., 2015. ISBN 80-86593-01-0.
PLURA, J. and P. KLAPUT. Computer Aided Quality Management II. 1. vyd. Ostrava: VŠB-TU Ostrava, 2015. Dostupné z: http://katedry.fmmi.vsb.cz/Opory_FMMI_ENG/QM/Computer%20Aided%20Quality%20Management%20II.pdf

Advised literature

ZIMMERMAN, S. M. and M. ICENOGLE. Statistical Quality Control Using Excel. Milwaukee: ASQ Quality Press, 2003. ISBN 0-87389-566-5.
HENDERSON, G. R. Six Sigma quality improvement with Minitab. 2nd ed. Chichester: Wiley, 2011. ISBN 978-0-470-74174-0.
LAUDON, K. C and J. P. LAUDON. Management Information Systems: Managing the Digital Firm (13th Edition). Harlow: Pearson, 2014. ISBN 0-13-230461-9.