639-2011/01 – Computer Aided Quality Management I (PPMK I)
Gurantor department | Department of Quality Management | Credits | 6 |
Subject guarantor | prof. Ing. Jiří Plura, CSc. | Subject version guarantor | prof. Ing. Jiří Plura, CSc. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 3 | Semester | summer |
| | Study language | Czech |
Year of introduction | 2014/2015 | Year of cancellation | |
Intended for the faculties | FMT | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Student will be able:
- to categorize the types of software used in the quality management
- to identify the possibility of using a spreadsheet Excel in quality management
- to apply spreadsheet Excel for data processing
- to create an Excel application for the field of quality management and correctly interpret the results.
Teaching methods
Lectures
Tutorials
Project work
Summary
The aim of the subject is to learn possibilities of computer aided quality management. Students will become familiar with selected software and their possibilities and learn to solve problems of quality management with using spreadsheet Excel. Emphasis is put on the correctness of the solution procedure and the correct interpretation of results.
Compulsory literature:
Recommended literature:
Way of continuous check of knowledge in the course of semester
Tests
E-learning
Integrovaný systém modulární počítačové podpory výuky ekonomicko-technického zaměření (http://lms.vsb.cz): Vzdělávací modul 4 – Zlepšování procesů s využitím statistické analýzy: submodul Průzkumová analýza dat, submodul Analýza způsobilosti procesů, submodul Analýza statistické stability procesu.
o PLURA, J. Analýza způsobilosti procesů. Studijní opory. Ostrava: VŠB-TU Ostrava, 2015. NOSKIEVIČOVÁ, D. Základní statistické metody managementu jakosti. Studijní opory. Ostrava: VŠB-TU Ostrava, 2008.
Other requirements
Submitting projets and passing written tests.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
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.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction