Course detail

Introduction to Informatics in Production

FSI-GZIAcad. year: 2020/2021

Learning outcomes and competences: Students will acquire information and knowledge about programming systems for creating application programs for production systems. Emphasis is placed on the object-oriented approach and this is shown on the discussed examples of the program systems - Wonderware InTouch, Wonderware Application Server and Microsoft SQL Server as a database system in line with the principles of Industry 4.0.

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

Ing. František Bradáč, Ph.D.

Department

Institute of Production Machines, Systems and Robotics (ÚVSSR)

Learning outcomes of the course unit

Students will learn how to work with object-oriented Wonderware InTouch, Wonderware Application Server and SQL software systems that make it relatively simple to create visualization and supervising applications for different types of manufacturing systems.

Prerequisites

Students are expected to be familiar with the database query language SQL as well. Basic knowledge of database and information systems is also expected.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

The course is taught through lectures explaining the basic principles and theory of the discipline. Teaching is suplemented by practical laboratory work.
According to the possibility of teaching can be organized lectures for students by practitioners and excursions to companies focused on activities related to the course content.

Assesment methods and criteria linked to learning outcomes

Course-unit credit is conditional on the following: Participation in practicals and working out of semester work. Examination: The exam has a written and an oral part. Final grade reflects student’s knowledge acquired in the course and his/her ability to apply this knowledge to the practical problems solution.

Course curriculum

Not applicable.

Work placements

Not applicable.

Aims

Students will learn how to work with object-oriented Wonderware InTouch, Wonderware Application Server and SQL software systems that make it relatively simple to create visualization and supervising applications for different types of manufacturing systems.
Learning outcomes of the course unit Students will learn to use object-oriented programming systems for visualization and supervising control / human-machine interface and applications for advanced management and analysis of manufacturing operations in the category Production and Performance Management. Students will also learn about the use of SQL databases.
Learning outcomes of the course unit The aim of the course is to acquaint the students with the current situation in the field of computer support of production systems. Attention is paid to the creation of control and visualization programs for production systems.

Specification of controlled education, way of implementation and compensation for absences

Attendance at obligatory lessons is checked and only substantial reasons of absence are accepted. Missed lessons can be substituted for via solution of extra exercises.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

OLIVÉ, A., 2007. Conceptual modeling of information systems. New York: Springer. ISBN 978-354-0393-894. (EN)
STAIR, Ralph M., 2016. Principles of information systems. 13th edition. Mason, OH: Cengage Learning. 8. Band, 3. Teil. ISBN 978-1305971776. (EN)

Recommended reading

BIGELOW, Stephen J., 2004. Mistrovství v počítačových sítích: správa, konfigurace, diagnostika a řešení problémů. Brno: Computer Press. ISBN 80-251-0178-9. (CS)
Informační systém podniku, 2001. Zlín: Univerzita Tomáše Bati. ISBN 80-238-6525-0. (CS)
Schneider Electric Software Global Customer Support [online], 2018. Schneider Electric industrial software business [cit. 2018-03-18]. Dostupné z: https://softwaresupport.schneider-electric.com/ (EN)
Wonderware software [online], 2018. Hradec Králové: Pantek (CS) [cit. 2018-03-18]. Dostupné z: http://www.pantek.cz/produkty/wonderware-software/ (CS)

Classification of course in study plans

  • Programme B3S-P Bachelor's

    branch B-VSY , 3 year of study, winter semester, compulsory

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

Ing. František Bradáč, Ph.D.

Syllabus

1. Lectures contents - systems, information and information systems.
2. Keywords definition - quantity of information, transfer of information, codes and coding.
3. HMI (Human-Machine Interface) visualization and supervision applications (visualization and supervision / human-machine interface).
4. Supervision and visualization applications of the SCADA type (Supervisory Control and Data Acquisition).
5. Advanced Management and Analysis of Production Operations in Production and Performance Management, MES (Manufacturing Execution Systems).
6. Data collection from control systems (PLC, DCS, I / O etc.).
7. Data and their processing - database systems, their architecture and types.
8. Relation databases.
9-11. Database language SQL.
12. Computer networks - basic keywords and terminology.
13. Internet and its basic services.

Computer-assisted exercise

26 hod., compulsory

Teacher / Lecturer

Ing. František Bradáč, Ph.D.

Syllabus

1-3. Working with the Wonderware Application Server. Create a sample application of the manufacturing system.
4-6. Working with Wonderware InTouch. Creating a SCADA application in conjunction with a created model in Wonderware Application Server.
7. Database MS Access - basic properties, fundamentals of programming.
8. Work with Microsoft SQL Server, create and manage databases, data manipulation commands (SELECT, INSERT, UPDATE, DELETE).
9. Working with Microsoft SQL Server - structure definition commands (CREATE, ALTER, DROP), transaction control commands (START TRANSACTION, COMMIT, ROLLBACK), filtering and sorting commands.
10-12. Work on the semester project.
13. Presentation of the semester project and evaluation of exercises.