Subjects

Your browser does not support JavaScript, or its support is disabled. Some features may not be available.

Applied PC Techniques - N321015

Title:	Aplikovaná výpočetní technika
Guaranteed by:	Department of Carbohydrates and Cereals (321)
Faculty:	Faculty of Food and Biochemical Technology
Actual:	from 2019
Semester:	winter
Points:	winter s.:3
E-Credits:	winter s.:3
Examination process:	winter s.:
Hours per week, examination:	winter s.:1/2, MC [HT]
Capacity:	unknown / unknown (unknown)
Min. number of students:	unlimited
State of the course:	cancelled
Language:	Czech
Teaching methods:	full-time
Teaching methods:	full-time
Level:
Note:	course can be enrolled in outside the study plan enabled for web enrollment

Guarantor:	Pour Vladimír Ing. CSc.
Is interchangeable with:	M321003

Examination dates Schedule

Annotation -

Students on simple examples get familiar with basic statistical concepts and basic statistical operations. The necessary mathematical operations are designed using programmed functions in Excel spreadsheet. Emphasis is placed on evaluating statistical conclusions from both the model and from actual operating data.

Last update: TAJ321 (18.12.2013)

Aim of the course -

Students will be able to:

master the basic statistical and probability concepts

assess the statistical ensemble using basic statistical characteristics

use statistical functions in MS Excel to process the data files

Last update: TAJ321 (26.09.2013)

Literature -

R:Excel Guide

R:STATISTICS Methods and Applications, Statsoft

Last update: TAJ321 (03.10.2013)

Teaching methods - Czech

Přednášky, cvičení, samostatné projekty

Závěrečný test

Last update: TAJ321 (19.11.2012)

Syllabus -

1. Parameters and sample

2. Second Analytical results, measurement errors

3. Testing results

4. Rating experimentally observed dependence

5. Regression, correlation, extrapolation and interpolation

6. Evaluation of granulometric spectra

7. Processing of statistical analyzes on computers I. (Excel)

8. Development of statistical analysis on computers II. (Excel)

9. Working with data files

10. The calculation of statistical characteristics

11. Regression methods I.

12. Regression methods II.

13. Graphical presentation of the results I.

14. Graphical presentation of results II.

Last update: TAJ321 (26.09.2013)

Learning resources -

Mathematics I

Chemical Engineering I

Last update: TAJ321 (02.10.2013)

Registration requirements -

None.

Last update: TAJ321 (02.10.2013)

Teaching methods
	Activity	Credits	Hours
	Účast na přednáškách	1	28
	Práce na individuálním projektu	0.7	20
	Příprava na zkoušku a její absolvování	0.3	8
	Účast na seminářích	1	28
		3 / 3	84 / 84

Coursework assessment
Form	Significance
Regular attendance	30
Report from individual projects	30
Examination test	40