Course detail
Information Systems and Computer Networks
FSI-GIF Acad. year: 2019/2020 Summer semester
Information systems are becoming a more and more important part of the manufacturing systems. Effective work with data and information takes on great importance especially in connection with the conception of the program Industry 4.0.The course is about basic concepts of information theory, students are familiarized with the structure of modern information systems, their design and application in production systems through modern methods of software engineering. The second part of course deals with the hardware and software of computer networks, their importance in the communication subsystem of information systems in production.
Language of instruction
Czech
Number of ECTS credits
5
Supervisor
Learning outcomes of the course unit
Students will be made familiar with the use of IS in manufacturing enterprises, concept of IS, and the methodology for its implementation. Students will acquire theoretical knowledge of and basic practical experience with databases and computer nets.
Prerequisites
Students are expected to have knowledge of:
- basic structure of manufacturing enterprises,
- basic knowledge of information flow in manufacturing processes,
- computer literacy,
- basic knowledge of computer networking.
Planned learning activities and teaching methods
The course is taught through lectures explaining the basic principles and theory of the discipline. Exercises are focused on practical topics presented in lectures.
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 verifies the acquired knowledge and is combined. It has a practical and theoretical part. The practical part examines the student's ability to apply acquired knowledge and methods on practical examples, in the theoretical part knowledge of the theoretical basis.
If a student solves less than half of the examples he has passed, he / she fails.
Aims
The aim of the course is to provide students with knowledge of the information flow in a manufacturing enterprise – specify requirements for information handling, methods used to cover these needs, use of information systems. Classification, inner structure and rules for development of IS are also discussed. The emphasis is placed on databases as a fundamental part of IS, as well as the communication in IS trough computer nets.
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.
The study programmes with the given course
Programme M2I-P: Mechanical Engineering, Master's
branch M-VSR: Production Machines, Systems and Robots, compulsory
Type of course unit
Lecture
26 hours, optionally
Teacher / Lecturer
Syllabus
1. Lectures contents – systems, information and information systems
2. Keywords definition – quantity of information, transfer of information, codes and coding
3. Information systems and technologies – IS/IT, their role in the digitization of production
4. Structure of IS for a manufacturing enterprises
5. Development of IS for production control – MRP, MRP II, CIM, ERP
6. Life cycle of IS
7. Information strategy for a manufacturing enterprise
8. Data and their processing – database systems, their architecture and types
9. Relation databases
10. Database language SQL
11. Computer networks – basic keywords and terminology
12. Internet and its basic services
13. Modern trends in the use of IS / IT in line with the concept of Industry 4.0
Computer-assisted exercise
13 hours, compulsory
Teacher / Lecturer
Syllabus
1-2. Information flow inside production systems
3-4. Information, their quantification and relation to probability
5-6. Database MS Access – basic properties
7-8. SQL – commands for selecting the data (SELECT)
9-10. SQL – commands for data modification (INSERT, UPDATE, etc.)
11-12. Computer networks
13. Evaluation of exercises