Course Details
Applied Software
Academic Year 2025/26
NJA027 course is part of 1 study plan
NPC-SIM Winter Semester 1st year
Course Guarantor
Institute
Language of instruction
Czech
Credits
2 credits
Semester
winter
Forms and criteria of assessment
graded course-unit credit
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.