Course detail
Data Processing
FSI-GSZ Acad. year: 2027/2028 Summer semester
The course introduces students to the issues of data processing in a production process. Basic data acquisition methods, industrial buses and communication protocols, data transmission methods including security, data analysis and processing, and last but not least data recording in a database system are described in sequence. Emphasis is placed on current methods that meet the requirements for the Industry 4.0 domain.
Students become familiar with the basic environments for data acquisition and processing, with the principles of data pre-processing, with data storage, and with selected advanced data processing methods, namely data classification, evolutionary algorithms and fuzzy sets. These methods are introduced in the course and practised at the level of basic application; their deeper development is the content of the follow-up course Intelligent Manufacturing Systems.
Language of instruction
Czech
Number of ECTS credits
4
Supervisor
Entry knowledge
The student is able to explain the basic physical quantities and their units and the principles of electrical measurement of voltage, current, resistance and frequency. The student is able to describe the operating principle of basic temperature, pressure and position sensors.
The student is able to write a simple algorithm containing a loop, a condition and a function in a programming language and to work with basic data structures, in particular arrays and matrices. The student is able to operate a spreadsheet application at the level of calculations and charts and to work with data files.
Rules for evaluation and completion of the course
The course is completed by a course credit and an examination.
Course credit requirements
Compulsory attendance at laboratory exercises. Tolerance of two excused absences; the tasks missed in these exercises shall be completed by the student within the semester assignment. The method of make-up shall be approved by the teacher.
Continuous solution of partial tasks in the laboratory exercises.
Elaboration of a semester assignment in the range of 15 to 20 standard pages including scripts, which comprises the processing of the partial tasks from the exercises – sensor data acquisition, communication over an industrial bus, data pre-processing and filtering, storage of data in a relational database including SQL queries, and classification of the measured data, in each case with an evaluation of the results obtained. The assignment shall be submitted no later than in the 12th teaching week.
A maximum of 0 to 30 points may be awarded for the semester assignment.
The course credit is awarded upon fulfilment of the attendance requirement; the score achieved may be as low as 0 points. The course credit is awarded in the 13th teaching week; the content of the 13th teaching week is the verification of the results of the exercises and the award of the course credit.
Examination
The examination takes the form of a written test. A maximum of 0 to 70 points may be obtained from the test. Only a student who has been awarded the course credit may sit the examination.
Final classification
The overall assessment consists of the points from the exercises (0 to 30 points) and the points from the examination (0 to 70 points), i.e. 100 points at most.
Classification scale: A 90 to 100 points, B 80 to 89 points, C 70 to 79 points, D 60 to 69 points, E 50 to 59 points, F 0 to 49 points.
Aims
The graduate is able to:
- explain the difference between data and information and to classify the methods of data acquisition in a manufacturing enterprise,
- describe the operating principle of a selected industrial bus and communication protocol and to design the connection of a sensor into a measurement chain,
- configure sensor data acquisition in the MATLAB environment and in the LabVIEW environment and to store the measured data,
- apply data pre-processing methods, in particular filtering, removal of outliers and compression, and to evaluate their effect on the result,
- store the measured data in a relational database and to construct SQL queries for their analysis,
- apply a basic classification method to a measured data set and to interpret the result obtained.
The study programmes with the given course
Programme N-KSB-P: Quality, Reliability and Safety, Master's, compulsory
Type of course unit
Lecture
26 hours, optionally
Syllabus
1. Information and data, basic concepts, types and methods of data acquisition.
2. Buses and sensors used in industry
3. Data transmission, protocols, compression, encryption
4. IoT and cloud systems
5. Fundamentals of data processing in Matlab/Simulink
6. Fundamentals of data processing in LabVIEW
7. Databases – SQL language – query creation, relational databases
8. Text editors, spreadsheets, graphics
9. Advanced data processing methods – data classification
10. Advanced data processing methods – evolutionary algorithms
11. Advanced data processing methods – fuzzy sets
12. Practical examples of the topics covered.
13. Credit
Laboratory exercise
26 hours, compulsory
Syllabus
1. Data acquisition in Matlab environment, basic information
2. Data acquisition in Matlab environment, data acquisition from sensor
3. Data processing in Matlab (Octave)
4. Data collection in LabVIEW environment, basic information
5. Data acquisition in LabVIEW environment, data acquisition from sensor
6. Compression and encryption of acquired data
7. Spreadsheet processors, data processing
8. Spreadsheets, extended functions
9. MS Access, tables, search queries
10. MS Access, relational DB
11. SQL queries, relational DB
12. Inspection and completion of protocols
13. Credit