| Course Unit Code | 639-2011/02 |
|---|
| Number of ECTS Credits Allocated | 5 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Third Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| PLU30 | prof. Ing. Jiří Plura, CSc. |
| 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. |
| Learning Outcomes of the Course Unit |
|---|
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.
|
| Course Contents |
|---|
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. |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
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.
|
NENADÁL, J., D. NOSKIEVIČOVÁ, R. PETŘÍKOVÁ, J. PLURA a J. TOŠENOVSKÝ. Moderní management jakosti. 1. vyd. Praha: Management Press, 2008. ISBN 978-80-7261-186-7.
BARILLA, J., P. SIMR a K. SÝKOROVÁ. Microsoft Excel 2016. Podrobná uživatelská příručka. 1. vyd. Brno: Computer Press, 2016. ISBN 978-80-251-4838-9.
MONTGOMERY, D.C. Introduction to Statistical Quality Control. 7th edition. Hoboken: Wiley, 2013. ISBN 0-471-31648-2.
|
| Recommended Reading: |
|---|
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.
|
GÁLA, L., J. POUR a Z. ŠEDIVÁ. Podniková informatika. Počítačové aplikace v podnikové a mezipodnikové praxi. 3. vyd. Praha: Grada Publishing, 2015. ISBN 978-80-247-5457-4.
ZIMMERMAN, S. M. a M. ICENOGLE. Statistical Quality Control Using Excel. Milwaukee: ASQ Quality Press, 2003. ISBN 0-87389-566-5.
LAURENČÍK, M. Excel - pokročilé nástroje: funkce, makra, databáze, kontingenční tabulky, prezentace, příklady. Praha: Grada, 2016. ISBN 978-80-247-5570-0.
LAUDON, K. C a J. P. LAUDON. Management Information Systems: Managing the Digital Firm (13th Edition). Harlow: Pearson, 2014. ISBN 0-13-230461-9.
|
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials, Project work |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Credit and Examination | Credit and Examination | 100 (100) | 51 |
| Credit | Credit | 40 | 20 |
| Examination | Examination | 60 | 31 |