Computer Evaluation of Experiments
FAST-CJ54Acad. year: 2019/2020
The preparation and evaluation of experiments, survey, the possibilities of utilization, the utilization of the table calculator EXCEL. Handling with experimental data - making ready and conserving the data, corrections.
Describing statistics, frequency tables and histograms. Statistical analysis of one or two variables, probability distribution. Initial data analysis, quartile graphs, dispersion variance and covariance analysis. Interpolation of data in selected distribution, critical values. Distribution functions – calculation, graphic presentation.
Tests of distribution, quality control, smoothing of dependence. Simple and multiple, linear and non-linear regression. Filtering of remote measurements. Description of graphs and its print. Methods for proposal of an experiment and the experiment evaluation.
Estimation and testing of hypotheses.
Optimization task, methods of seeking the extremes, analysis and the formulation of the linear and quadratic programming task. Problems from the building practice of seeking the optimum- transport task, mixing problem, composition of raw material mixtures, grain distribution in the ground material.
The subject doesn’t contain a part with lectures, the exercise has a calculation character.
Institute of Technology of Building Materials and Components (THD)
Learning outcomes of the course unit
The student would manage the goal of the subject by acquiring knowledge on statistical control of physical properties of construction material, testing the statistical accordance of used end-use properties, correlation analysis of parameters, use of statistical laws during production quality management, process management of the experiment, simulation and statistical processes.
Basic Mathematics, basic work with PC
Recommended optional programme components
Recommended or required reading
Plesník, J., Dupačová, J., Vlach, M.: Lineárne programovanie. Alfa, Bratislava, 1990. neuvedeno. (SK)
Duda, W. H.: Cement-Data-Book. Bauverlag Wiesbaden, 1977. neuvedeno. (EN)
Hušek, R., Lauber, J.: Simulační modely. SNTL/Alfa, 1987. neuvedeno. (CS)
Planned learning activities and teaching methods
Assesment methods and criteria linked to learning outcomes
Language of instruction
1.Utilization of computer technique – PC – in building practice.
2.Fundamentals of work with data files.
3.Advanced work with data files – sorting and filtering of data.
4.Problems of data access, remote access to data and sharing of data files.
5.Utilization of PC technique in deciding processes.
6.Detailed acquainting with the medium MS Excel.
7.Work in the researcher’s table calculator Excel MS.
8.Fundamentals of data files statistic analysis.
9.Simple regression methods in MS Excel.The simplex method.The mixing task. The transport task.
10. Use solver for simple math problems in MS Excel
11. Use of optimization methods in industry and technology - algebraic basis of convex sets
12. The role of the quadratic optimization - optimization problem of the composition of the raw mix in cement production, optimization of mixing raw materials (particle size distribution, porosity distribution foamed plastic, etc.)
13. Non-deterministic optimization models - integer optimization (cutting plan, the problem with dividing panels in the production of the long lines), the optimization principle in the design of the heating system (heating media optimization distribution network)
Statistic control of building materials physical properties, testing of statistic accordance of selected utility properties. Correlation analysis of parameters, utilization of statistic regularities for production quality control.Control of processing experimental control, simulation and static processesAdaptive control method, uncertainty in technological processes evaluation.
Specification of controlled education, way of implementation and compensation for absences
Extent and forms are specified by guarantor’s regulation updated for every academic year.