639-2011/02 – Computer Aided Quality Management I (PPMK I)

Gurantor departmentDepartment of Quality ManagementCredits5
Subject guarantorprof. Ing. Jiří Plura, CSc.Subject version guarantorprof. Ing. Jiří Plura, CSc.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semestersummer
Study languageCzech
Year of introduction2019/2020Year of cancellation
Intended for the facultiesFMTIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
PLU30 prof. Ing. Jiří Plura, CSc.
VYK37 Ing. David Vykydal, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 1+3
Part-time Credit and Examination 6+12

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:

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.

Recommended 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.

Way of continuous check of knowledge in the course of semester

Combined exam. Elaboration of 2 individual project. Accomplishment of tests and the credit test. Participation in seminars (80%).

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. 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

There are no additional requirements for students.

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

Full-time form (validity from: 2019/2020 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 40  20
        Examination Examination 60  31
Mandatory attendence parzicipation: 80% presence at seminars

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2021/2022 (B0488A270001) Quality Management and Control of Industrial Systems (S02) Quality Management P Czech Ostrava 3 Compulsory study plan
2021/2022 (B0488A270001) Quality Management and Control of Industrial Systems (S02) Quality Management K Czech Ostrava 3 Compulsory study plan
2020/2021 (B0488A270001) Quality Management and Control of Industrial Systems (S02) Quality Management P Czech Ostrava 3 Compulsory study plan
2020/2021 (B0488A270001) Quality Management and Control of Industrial Systems (S02) Quality Management K Czech Ostrava 3 Compulsory study plan
2019/2020 (B0488A270001) Quality Management and Control of Industrial Systems (S02) Quality Management P Czech Ostrava 3 Compulsory study plan
2019/2020 (B0488A270001) Quality Management and Control of Industrial Systems (S02) Quality Management K Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner