Course Details

Applied Software

Academic Year 2023/24

NJA027 course is part of 1 study plan

NPC-SIM Winter Semester 1st year

Principles of problem solution searching, definition of modelling methods and simulation methodology, model, system. Modelling in technical branches, physical model, degrees of model abstraction, problem analysis and algorithm of solution. Technique of natural and physical modelling. Deterministic simulation models.
Realization on a deterministic model. Digital simulation models. Utilization of simulation for production planing, distribution and transport.
Utilization of the EUREKA program system, formulation of the technical problem.
Data handling - data preparation, data storage, files correction.
Extreme searching methods, analysis, formulation and task setting of optimization method. Tasks from the building practice- mixing problem, process of decision.
The part of lectures is followed by training, which has a computational character. In the framework of the training computational means used in the area of experiment planning, production technology are presented. Physical modelling - AREA, HEAT, FLUENT, EUREKA.

Course Guarantor

Institute

Objective

Principle of optimization methods utilization in mass production of building materials, principles of utilization of linear, quadratic and statistic searching of extremes / functionalities optima of building materials utility properties
Modeling and simulation of results, principles of formal automatic machines

Knowledge

The student would manage the goal of the subject by acquiring knowledge on the principles of optimization methods used in the process of mass production of construction materials, the use of linear, quadratic, statistical principles of searching for extremes / optimums of functional dependence of end-use properties of building material, modeling and process simulation, principles of formal automats.

Syllabus

1. Use of computer technology in building practice, use of software support in MS Windows environment.
2. Office Software Packages - MS Office.
3. Using MS Excel spreadsheet in building practice.
4. Formulate tasks to search for extreme functions.
5. Assemble a Solver / Solver solution.
6. Theoretical basis of the optimization task in the search for extreme functions.
7. Algorithmization of tasks for extreme search, simplex method.
8. Extreme formulation, description of conditions and limiting of linear task.
9. Extreme formulation, description of conditions, and limitation of quadratic task.
10. Mathematical programming, solution principle.
11. Practical examples of search for extreme in building practice.
12. Practical role of raw material composition suggestions.
13. Software Support for Finding Extreme Tasks.

Prerequisites

Fundamentals of work with PC

Language of instruction

Czech

Credits

2 credits

Semester

winter

Forms and criteria of assessment

graded course-unit credit

Specification of controlled instruction, the form of instruction, and the form of compensation of the absences

Extent and forms are specified by guarantor’s regulation updated for every academic year.

Offered to foreign students

Not to offer

Course on BUT site

Lecture

13 weeks, 2 hours/week, elective

Syllabus

1. Use of computer technology in building practice, use of software support in MS Windows environment. 2. Office Software Packages - MS Office. 3. Using MS Excel spreadsheet in building practice. 4. Formulate tasks to search for extreme functions. 5. Assemble a Solver / Solver solution. 6. Theoretical basis of the optimization task in the search for extreme functions. 7. Algorithmization of tasks for extreme search, simplex method. 8. Extreme formulation, description of conditions and limiting of linear task. 9. Extreme formulation, description of conditions, and limitation of quadratic task. 10. Mathematical programming, solution principle. 11. Practical examples of search for extreme in building practice. 12. Practical role of raw material composition suggestions. 13. Software Support for Finding Extreme Tasks.

Exercise

13 weeks, 1 hours/week, compulsory

Syllabus

1. Introduction to MS Excel environment. 2. Statistical functions in MS Excel. 3. Normal distance. 4. Solver. 5. Basic of optimization process. 6. Optimization of company production. 7. Optimization of building materials recipes design. 8. Optimization of production process from point of view of supply utilization. 9. Optimization of concrete production and transport. 10. Transport problem. 11. Optimal design grading size curve. 12. Utilization of optimization in building praxis. 13. Verification, credit test, credits.