639-0923/02 – Computer Aided Quality Management and Data Management (CAM)

Gurantor departmentDepartment of Quality ManagementCredits10
Subject guarantorprof. Ing. Jiří Plura, CSc.Subject version guarantorprof. Ing. Jiří Plura, CSc.
Study levelpostgraduateRequirementChoice-compulsory
YearSemesterwinter + summer
Study languageCzech
Year of introduction2010/2011Year of cancellation
Intended for the facultiesHGF, FMTIntended for study typesDoctoral
Instruction secured by
LoginNameTuitorTeacher giving lectures
PLU30 prof. Ing. Jiří Plura, CSc.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Examination 2+0
Combined Examination 28+0

Subject aims expressed by acquired skills and competences

Student will be able • to identify possibilities of computer aided quality management • to apply spreadsheet MS Excel and software Minitab for data processing • to solve selected tasks from quality management field with using MS Excel and Minitab

Teaching methods

Lectures
Individual consultations
Other activities

Summary

The aim of the subject is to learn applications 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 MS Excel and software Minitab. Emphasis is put on the correctness of the solution procedure and the correct interpretation of results.

Compulsory literature:

MONTGOMERY, DOUGLAS C. Introduction to Statistical Quality Control. 6th edition. Hoboken: Wiley, 2009, 734 s., ISBN 978-0-470-16992-6 WALKENBACH, JOHN Microsoft Excel 2010. Bible. Indianopolis: Wiley Publishing Inc., 2010, ISBN 978-0-470-47487-7

Recommended literature:

HENDERSON, G. R. Six Sigma Quality Improvement with Minitab. 2nd edition. John Wiley & Sons, 2011, 504 s., ISBN 978-0-470-74175-7 LAUDON, K. C., LAUDON, J. P. Management Information Systems: Managing the Digital Firm (9th Edition). Prentice Hall, 2005, 736 s., ISBN-10: 0131538411

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

Processing of written work to the examination.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

The importance of computer aid in the field of quality management. Types of used software. Information systems of quality management. Creating information through data collection and processing. Data management. Specialized software in the field of computer aided quality management. Spreadsheet Excel and possibilities of its use for quality management tasks solution. Work with data files, data import and export. Data verification. Data sorting and filtering. Work with tables. Conditional formatting. Calculations in Excel, use of relative and absolute addresses. Exploratory data analysis. Graphical presentation of data. Excel functions and their use in the quality management. Excel analytical tools. Contingency tables and their use in the quality management. Processing of special Excel applications. Selected statistical software and their suitability for solving problems in the field of quality management. Characteristics of software Minitab and possibilities of its use in quality management. Working with worksheets and projects in Minitab, data import and export. The calculations in Minitab, creating new variables. Selected operators and their use in quality management. Data filtering and sorting. Exploratory data analysis. Hypothesis Testing in Minitab (testing normality, goodness of fit tests , t -test, F -test). Regression and correlation analysis in Minitab. Special tasks in the field of quality management (cause and effect diagram, Pareto analysis, measurement system analysis). Special tasks in the field of quality management (process capability analysis, statistical process control). Other special software for various fields of quality management (Statgraphics, QC Expert, Palstat etc.).

Conditions for subject completion

Full-time form (validity from: 2013/2014 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Examination Examination  
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2019/2020 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2018/2019 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2018/2019 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2017/2018 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2017/2018 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2016/2017 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2016/2017 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2016/2017 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2015/2016 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2015/2016 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2015/2016 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2015/2016 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2014/2015 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2014/2015 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2014/2015 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2014/2015 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2013/2014 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2013/2014 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2013/2014 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2013/2014 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2012/2013 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2012/2013 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2012/2013 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2012/2013 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2011/2012 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2011/2012 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan
2011/2012 (P3925) Management of Industrial Systems P Czech Ostrava Choice-compulsory study plan
2011/2012 (P3925) Management of Industrial Systems K Czech Ostrava Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner