Course Details

Applied Software

Academic Year 2024/25

NJA027 course is part of 1 study plan

NPC-SIM Winter Semester 1st year

Course Guarantor


Language of instruction



2 credits



Forms and criteria of assessment

graded course-unit credit

Offered to foreign students

Not to offer

Course on BUT site


13 weeks, 2 hours/week, elective


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.


13 weeks, 1 hours/week, compulsory


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.