Course detail
Information Systems and Computer Networks
FSI-GIF-K Acad. year: 2024/2025 Summer semester
Information systems are nowadays a very important part of production systems. Effective work with data and information is of particular importance in connection with the concept of Industry 4.0. In this course, basic concepts of information theory are discussed, students are familiar with the structure of modern information systems, their design and deployment in the field of manufacturing systems through the latest methods of software engineering. Students are also acquainted with the means of computer networks, their importance in the communication subsystem of information systems in production.
Language of instruction
Czech
Number of ECTS credits
4
Supervisor
Entry knowledge
Prerequisites and co-requisites Practical knowledge of computer work, basic knowledge of computer networking.
Rules for evaluation and completion of the course
The course consists of exercises and lectures. Exercise is completed by credit (awarded in the 13th week). To obtain it is required 100% participation in exercises and activity in exercises. Students will work out the individual work in the prescribed range and quality. Based on the quality of the work in the exercise, the student earns up to 30 points for the exam The work must be submitted in writing and checked and recognized by the teacher. The test is realized by written test, student can get up to 70 points from this test, where 30 points from exercises. Evaluation of the test result is given by the ECTS grading scale.
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.
Aims
Learning outcomes of the course unit To acquaint students with basic requirements for information processing in manufacturing companies and ways of their coverage, especially by using information systems for these purposes. They will also learn about development and classification of IS used in manufacturing companies, their structure and way of their construction. Great attention is paid to databases as a basic element of IS. Students will also become familiar with the basic features of computer networks.
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.
The study programmes with the given course
Programme N-VSR-K: Production Machines, Systems and Robots, Master's, compulsory-optional
Type of course unit
Guided consultation in combined form of studies
13 hours, compulsory
Syllabus
1. – 2. Course contents – systems, information, information size, information transfer, codes, and coding
3. – 4. Data and its processing in IS – database systems, their types, and architecture, relational databases
5. – 6. SQL as an example of database language
7. – 8. Computer networks – basic terms and terminology, Internet and its basic services
9. – 10. Information strategy in manufacturing company
11. – 12. IS structure of the manufacturing company, IS for production management – MRP, MRPII, CIM, ERP
13. Credit
Guided consultation
26 hours, optionally
Syllabus
1. Working with data, data compression and data encryption
2. MS Access database, tables and query creation
3. MS Access database, relational database
4. SQL – statements for data selection and presentation
5. SQL – data modification commands, external access to DS
6. SQL – data modification commands, external access to DS
7. IoT and cloud systems – basic information
8. IoT and cloud systems – practical examples
9. Computer networks, Internet and its basic services
10. Web page creation – static, dynamic
11. Creating web pages – dynamic
12. Completion of final protocols
13. Credit