Course detail

Computer Preparation and the Evaluation of Experiments

FAST-5J2Acad. year: 2019/2020

The preparation and evaluation of experiments, survey, the possibilities of utilization, the utilization of the programming system STATGRAPH. 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.

Department

Institute of Technology of Building Materials and Components (THD)

Learning outcomes of the course unit

Not applicable.

Prerequisites

Mathematics, basic work with PC

Co-requisites

Not applicable.

Recommended optional programme components

Not applicable.

Recommended or required reading

Duda, W. H.: Cement Data-Book. Bauverlag GmbH 1977
Hušek, R., Lauber, J.: Simulační modely. SNTL/Alfa 1987
Plesník, J., Dupačová, J., Vlach, M.: Lineárne programovanie. Alfa 1990

Planned learning activities and teaching methods

Not applicable.

Assesment methods and criteria linked to learning outcomes

Not applicable.

Language of instruction

Czech

Work placements

Not applicable.

Course curriculum

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.
10.Utilization for solution of simple mathematical problems in the MS Excel.
11.The simplex method.
12.The mixing task.
13.The transport task.The Theory of games.

Aims

Explanation of general regularities in technological processes, utilization of statistical methods in mass production of building materials, statistic inspection of building materials physical properties, testing of selected utility properties statistic accordance, correlation analysis of parameters, utilization of statistic laws for quality control of production

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.

Type of course unit

 

Lecture

13 hours, optionally

Teacher / Lecturer

Exercise

13 hours, compulsory

Teacher / Lecturer

eLearning