Subjects(version: 928)

Applied PC Techniques - N321015
Title: Aplikovaná výpočetní technika Department of Carbohydrates and Cereals (321) Faculty of Food and Biochemical Technology from 2019 winter winter s.:3 winter s.:3 winter s.: winter s.:1/2, MC [HT] unknown / unknown (unknown) unlimited Czech full-time course can be enrolled in outside the study planenabled for web enrollment
Guarantor: Pour Vladimír Ing. CSc. M321003
Examination dates   Schedule
 Annotation - ---CzechEnglish
Last update: TAJ321 (18.12.2013)
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.
 Aim of the course - ---CzechEnglish
Last update: TAJ321 (26.09.2013)

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

 Literature - ---CzechEnglish
Last update: TAJ321 (03.10.2013)

R:Excel Guide

R:STATISTICS Methods and Applications, Statsoft

 Learning resources - ---CzechEnglish
Last update: TAJ321 (02.10.2013)

Mathematics I

Chemical Engineering I

 Teaching methods - Czech
Last update: TAJ321 (19.11.2012)

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

Závěrečný test

 Syllabus - ---CzechEnglish
Last update: TAJ321 (26.09.2013)

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.

 Registration requirements - ---CzechEnglish
Last update: TAJ321 (02.10.2013)

None.

 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

VŠCHT Praha