| Code |
В03017В |
| Course unit |
Information technologies |
| Nomber of credits ECTS |
5.0 |
| Language of education |
Ukrainian |
| Learning outcomes of course unit |
- Use spreadsheets to perform a wide range of engineering calculations.
- Use standard database management systems for data collection, storage and processing.
|
| Types of educational work |
lecture classes, practical classes, doing calculation project. |
| Type of final control |
|
| Content of course unit |
- Use of electronic spreadsheets in engineering calculations. Basic concepts of electronic spreadsheets. Linear computational processes.
- Branched computing processes. Data entry and editing. Data formats. Data series.
- Working with matrices, and solving systems of algebraic equations.
- Final calculations. Using add-ons. Construction of diagrams and graphs of functions in spreadsheets.
- Solving complex applied problems.
- The concept of databases. Data models. Relational databases. Architecture of database management systems. Basic principles of database design.
- Creation of a new database, and tables. Data types in DBMS. Definition of relationships between tables. Creation of forms.
- Creation of requests in visual and manual modes. The SQL language.
- Creation of reports. Visualization of information using the Microsoft PowerPoint program.
- Algorithmization. Rules for constructing algorithm schemes. The alphabet and basic lexemes of the Visual Basic algorithmic language. Linear computational processes.
- Operations on the logical data type. Logical expressions. Branched computing processes.
- Programming algorithms of cyclic structure. Organization of routines and functions.
- Peculiarities of presenting numbers on a computer. Visual Basic data types. Composite data types.
- Algorithms for working with data arrays.
- Control elements for working with graphic objects.
|
| Equipment (if applicable) |
Personal computers, Microsoft Excel (or Libre Office Calc) software for automating calculations; Microsoft Access software for building a database and Microsoft Visual Basic |
