Skip to main content
Skip header

Computer Aided Quality Management

Type of study Doctoral
Language of instruction Czech
Code 639-0937/03
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

1. 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.
2. Spreadsheet Excel and possibilities of its use for quality management tasks solution.
3. Work with data files, data import and export. Data verification. Data sorting and filtering.
4. Work with tables. Conditional formatting. Calculations in Excel, use of relative and absolute addresses.
5. Exploratory data analysis. Graphical presentation of data. Excel functions and their use in the quality management.
6. Excel analytical tools. Contingency tables and their use in the quality management.
7. Processing of special Excel applications.
8. Selected statistical software and their suitability for solving problems in the field of quality management.
9. Characteristics of software Minitab and possibilities of its use in quality management.
10. Working with Minitab worksheets and Minitab projects, data import and export.
11. The calculations in Minitab, creating new variables. Selected operators and their use in quality management.Data filtering and sorting. Exploratory data analysis.
12. Hypothesis Testing in Minitab (testing normality, goodness of fit tests, t -test, F -test).
13. Regression and correlation analysis in Minitab.
14. Special tasks in the field of quality management (cause and effect diagram, Pareto analysis, measurement system analysis, process capability analysis, statistical process control).
15. 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.