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

Gurantor departmentDepartment of Quality ManagementCredits6
Subject guarantorprof. Ing. Jiří Plura, CSc.Subject version guarantorprof. Ing. Jiří Plura, CSc.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semestersummer
Study languageCzech
Year of introduction2014/2015Year 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+2
Combined Credit and Examination 12+6

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

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.

Další požadavky na studenta

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

Combined form (validity from: 2014/2015 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:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management K Czech Ostrava 3 Compulsory study plan
2019/2020 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management P Czech Ostrava 3 Compulsory study plan
2018/2019 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management P Czech Ostrava 3 Compulsory study plan
2018/2019 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management K Czech Ostrava 3 Compulsory study plan
2017/2018 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management P Czech Ostrava 3 Compulsory study plan
2017/2018 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management K Czech Ostrava 3 Compulsory study plan
2016/2017 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management P Czech Ostrava 3 Compulsory study plan
2016/2017 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management K Czech Ostrava 3 Compulsory study plan
2015/2016 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management P Czech Ostrava 3 Compulsory study plan
2015/2016 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management K Czech Ostrava 3 Compulsory study plan
2014/2015 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management P Czech Ostrava 3 Compulsory study plan
2014/2015 (B3922) Economics and Management of Industrial Systems (3902R062) Quality Management K Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner