639-0410/01 – Computer Aided Quality Management (CAQMI)

Gurantor departmentDepartment of Quality ManagementCredits4
Subject guarantorprof. Ing. Jiří Plura, CSc.Subject version guarantorprof. Ing. Jiří Plura, CSc.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semestersummer
Study languageCzech
Year of introduction2004/2005Year 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 18+0

Subject aims expressed by acquired skills and competences

Student will be able • to categorize software used in quality management field • to apply spreadsheet MS Excel at data processing • to solve selected tasks in MS Excel • to interpret achieved results • to create applications for quality management field in MS Excel

Teaching methods

Lectures
Tutorials
Project work

Summary

Subject is focused on the use of computer aid in quality management. The possibilities of the computer aid use in the various fields of quality management and used software are analyzed. Students obtain information about selected software products and their possibilities. They obtain computer skills of using spreadsheet EXCEL for solution of various quality management tasks.

Compulsory literature:

MONTGOMERY, DOUGLAS C: Introduction to Statistical Quality Control. 5th edition, New York: John Willey & Sons, 2004, 832 pp. ISBN 0-471-66122-8 WALKENBACH, JOHN: Microsoft Excel 2010. Bible. Indianopolis: Wiley Publishing Inc., 2010, ISBN 978-0-470-47487-7

Recommended literature:

TURBAN, EFRAIM - ARONSON, JAY E.: Decision Support Systems and Intelligent Systems (6th Edition). Prentice Hall, 2003, ISBN: 0130894656 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

Tests

E-learning

No

Další požadavky na studenta

Required attendance at exercises, projects processing.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Fields of computer aided quality management. Types of 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 sorting and filtering. Work with tables. Excel functions and their use. Graphical presentation of data. Exploratory data analysis. Excel analytical tools. Contingency tables. Special Excel applications. Histogram, Pareto diagram, control chart, regression analysis etc. Other software products for various quality management fields.

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester, validity until: 2011/2012 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 40  0
        Examination Examination 60 (60) 0
                Written examination Written examination 20  0
                Oral Oral examination 40  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2016/2017 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2015/2016 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2015/2016 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2014/2015 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2014/2015 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2013/2014 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2013/2014 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2012/2013 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2012/2013 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2011/2012 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2011/2012 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2011/2012 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Třinec 3 Compulsory study plan
2010/2011 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2010/2011 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Třinec 3 Compulsory study plan
2010/2011 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2009/2010 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2009/2010 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2009/2010 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Třinec 3 Compulsory study plan
2008/2009 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2008/2009 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2008/2009 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Třinec 3 Compulsory study plan
2007/2008 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2007/2008 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2007/2008 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Třinec 3 Compulsory study plan
2006/2007 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2006/2007 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2006/2007 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Třinec 3 Compulsory study plan
2005/2006 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management P Czech Ostrava 3 Compulsory study plan
2005/2006 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Ostrava 3 Compulsory study plan
2005/2006 (B3922) Economics and Management of Industrial Systems (3902R041) Quality Management K Czech Třinec 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
Subject block without study plan - FMMI - K - cs 2016/2017 Combined Czech Optional FMT - Faculty of Materials Science and Technology stu. block
Subject block without study plan - FMMI - P - cs 2016/2017 Full-time Czech Optional FMT - Faculty of Materials Science and Technology stu. block