Course Details
Applied Software
Academic Year 2024/25
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.