Skip to main content
Skip header

Computer Aided Quality Management I

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

Subject syllabus

1. Fields of using computer aided quality management.
2. Types of software in the field of computer aided quality management.
3. Spreadsheet Excel and possibilities of its use for quality management tasks solution.
4. Work with data files, data import and export. Data verification.
5. Data sorting and filtering.
6. Work with tables. Conditional formatting.
7. Calculations in Excel, use of relative and absolute addresses.
8. Exploratory data analysis. Graphical presentation of data.
9. Excel functions and their use in the quality management.
10. Excel analytical tools.
11. Contingency tables and their use in the quality management.
12. Processing of special Excel applications.
13. Other software products for various quality management fields
14. Actual information on computer aided quality management.

E-learning

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.

Advised literature

ZIMMERMAN, S. M. a M. ICENOGLE. Statistical Quality Control Using Excel. Milwaukee: ASQ Quality Press, 2003. ISBN 0-87389-566-5.
LAUDON, K. C a J. P. LAUDON. Management Information Systems: Managing the Digital Firm (13th Edition). Harlow: Pearson, 2014. ISBN 0-13-230461-9.