Code В01013В
Course unit Information Technologies
Nomber of credits ECTS 4.0
Language of education Ukrainian
Learning outcomes of course unit

Knowledge:

- basic concepts of programming and computer technology;

- methods of preparing technical problems for solving them with the help of electronic computers;

- programming in a high-level language;

- work on a computer with one of the operating systems;

- methods of working with typical software complexes (packages);

- general approaches to the construction and operation of database management systems and information systems;

- basic network technologies and methods of data transmission.

Ability:

- choose a numerical method and develop an algorithm for solving an engineering problem;

- write the selected algorithm in a high-level language;

- debug and run the program on a computer;

- work on a computer with typical software complexes (packages);

- perform engineering calculations using electronic spreadsheets;

- work with computer networks;

- work with database management systems;

- draw up program documentation in accordance with the existing standard.

Types of educational work Lectures, practical sessions
Type of final control
Content of course unit
  1. Algorithmization. Rules for constructing algorithm schemes. The alphabet and basic lexemes of the Visual Basic algorithmic language. Linear computational processes.
  2. Operations on the logical data type. Logical expressions. Branched computing processes.
  3. Programming algorithms of cyclic structure. Organization of routines and functions.
  4. Peculiarities of presenting numbers in a computer. Visual Basic data types. Composite data types.
  5. Algorithms for working with data arrays.
  6. Control elements for working with graphic objects.
  7. Use of electronic spreadsheets in engineering calculations.
  8. Entering and editing data. Data formats. Data series. Working with matrices, solving systems of equations.
  9. Functions and formulas. Function wizard. Input automation. VBA programming
  10. Final calculations. Using add-ons. Construction of charts and graphs.
  11. The concept of databases. DBMS architecture. Data models. Relational databases. Basic principles of database design.
  12. Creation of a new database. Creation of tables. Saving tables. Definition of relationships between tables. Database modification.
  13. Expressions in Microsoft Access. Creation of forms.
  14. Creation of requests.
  15. Creation of reports. Visualization of information using the Microsoft Power Point program.
Equipment (if applicable) Computers with software Microsoft Visual Basic, Microsoft Office, LibreOffice, OpenOffice

Return
to the search form