Programming for Manufacturing Systems (FSI-GPG)

Academic year 2018/2019
Supervisor: doc. Ing. Lubomír Vašek, CSc.  
Supervising institute: ÚVSSR all courses guaranted by this institute
Teaching language: Czech
Aims of the course unit:
The aim of the course is to familiarise students with basic properties of object and event driven programming. Students will be cognizant of programming language Microsoft Visual Basic .NET and language SQL.
Learning outcomes and competences:
The students will acquire knowledge necessary to create applications for operation system Microsoft Windows using the programming language Visual Basic. They will know to connect these applications to databases and create user defined ActiveX objects as well.
Prerequisites:
Students are expected to have basic knowledge of algorithm and programming, as well as basic knowledge of functions, objects and services offered by NT based operation systems.
Course contents:
The course provides an overview of different groups of programming languages used in the manufacturing systems. These are procedural languages, object-oriented languages, languages for database and multimedia applications. The development trends in these groups are analysed. An example of each group is described in detail and trained practically - MS Access, SQL, Visual Basic .NET.
Teaching methods and criteria:
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:
Working out of a semester project
Controlled participation in lessons:
Attendance at practise lessons is obligatory and it is checked. Only substantial reasons of absence are accepted. Missed lessons can be substituted for via solution of extra exercises.
Type of course unit:
    Lecture  13 × 2 hrs. optionally                  
    Computer-assisted exercise  13 × 2 hrs. compulsory                  
Course curriculum:
    Lecture 1. Introduction to developing environment Visual Basic (VB) - Specifications, Limitations, and File Formats
2. Visual Basic Coding Conventions
3. Introduction to Variables, Constants and Data Types
4-5. Using ActiveX Controls
6. Creating ActiveX Components
7. Accessing DLLs and the Windows API
8-9. Interacting Visual Basic with Data in a Database
10. Interprocess communication under MS Windows
11-12.Visual Basic Script ; programming for WEB
13. Differences between Visual C++ and Visual Basic
seminars in computer labs
    Computer-assisted exercise 1. Introducing Visual Basic development environment
2. Working with ActiveX objects
3-4. Creating the simple application for text processing
5. Creating the simple application for working with graphics
6-7. Creating the application "Calculator"
8. Connection of application to database
9. Creating a simple application for working with database
10-12.Semester project
13. Delivery and presentation of the semester project
Literature - fundamental:
1. Michael Halvorson, Microsoft Visual Basic 6.0 Professional Krok za krokem, ISBN: 8072264451
2. Microsoft Visual Basic 6.0 Příručka programátora, Microsoft Corporation, ISBN: 80-7226-154-1
Literature - recommended:
1. Michael Halvorson, Microsoft Visual Basic 6.0 Professional Krok za krokem, ISBN: 8072264451
2. Martin Gürtler, Pavel Kocich, 1001 tipů a triků pro Visual Basic, ISBN: 8072263684
The study programmes with the given course:
Programme Study form Branch Spec. Final classification   Course-unit credits     Obligation     Level     Year     Semester  
M2I-P full-time study M-VSR Production Machines, Systems and Robots P linked to branch B-SSZ GCr 4 Elective (voluntary) 2 1 S
M2I-P full-time study M-VSR Production Machines, Systems and Robots -- GCr 4 Elective (voluntary) 2 1 S