Czech

3

Not applicable.

The enhancement of students’ knowledge and competences in terms of utilizing of computers in chemical practice will take effect in particular in following branches:

1) The students will master the advanced level of utilizing information technologies together with using of information databases, which will also be enhanced during the following course.

2) The students will develop the competences to master the text processors on an advanced level, including the employing of automated numbering, automated contents, cross-references, title links, revision monitoring and mass correspondence. Students will also learn how to keep the standards of typography.

3) Students will gain the knowledge how to use the spreadsheet editors, in particular the mathematical, logical, text, search and statistical operations with employment of related formulas and functions. Students will master the creation of advanced charts and their exploiting for data analysis as well as the work with lists of data, data searching and filtering with employing of pivot tables and pivot charts. Students will understand the fundamentals of probability distributions, descriptive statistics and linear regression.

Basic skills and experience with using of computers and managing of files.

Not applicable.

Lectures + exercises with a full elearning support.

The course consists of a credit and an exam as well as an elearning course. To gain the credit, student is required to pass three term tests and to complete the elearning course. Gaining the credit is a condition required to take a part on the exam. The exam has a written and an oral part. In the written part a student solve an input theoretical test and practical examples. The oral part of the exam will contain discussion of tasks and possible supplementary questions.

Detailed outline of the course is show at: https://www.vutbr.cz/elearning/course/view.php?id=121773

Part I. Advanced work with text processors
1) Fundamentals of IT using at Faculty of Chemistry
2) Advanced work with text processors
3) Advanced processing and creationg of professional documents
4) Typography

Part II. Advanced work with spreadsheets
5) Basic spreadsheet techniques
6) Technical calculations
7) Advanced spreadsheets and charts
8) Data import, advanced charts, linear regression

Part III. Fundamentals of statistics
9) Fundamentals of probability distributions
10) One-dimensional data – basics of descriptive statistics
11) Two.dimensional data – correlations and linear regression
12) Calculations of measurement uncertainties.

Part IV. – Elearning course – Work with informational sources
The part of the course is a full-tutored elearning course intorducing the fundamentals of work with information sources (in particular the informational scientific databases) in the chemical practice as well as with advanced methods, how to utilize these informational sources.

Not applicable.

The course objective is to provide students with the basic knowledge and skills from the field of information science, which are necessary for following study of chemical subjects. The project focuses on the application of these knowledge in the field of chemistry and also other related branches.

The course is consisted of lectures, exercises and a tutored elearning course. Attendance on lectures is optional, but strongly recommended and suitable for completing the course. Attendance on exercise is compulsory and controlled. A student has a right to be missing without a particular reason only a tone exercise, shall he/she miss more exercises, loses the possibility to gain a credit, cannot therefore attempt on an exam and is obliged to repeat the course. Student can be excused from missing an exercise class from serious reasons, generally medical or family. The suitable excuse is e.g. a medical report; the final say is up to the lector of the exercise. The part of the whole course is a fully tutored elearning course, divided into weekly-parts and its completion is a non-separable part of gaining a credit.
In terms of the course, the students have the autoevaluation and communication tolls available via the elearning portal, so they have the possibility to consult the ways to solve the given tasks with the lectors. The students’ progress during the course is controlled and evaluated always after the completion of topic part of the course, utilizing running term tests.

Not applicable.

Not applicable.

Not applicable.

Barilla J., Simr P., Excel pro techniky a inženýry, Computer Press, Brno, 2008 (CS)
Jiří PAVLÍK a kolektiv. Aplikovaná statistika. Praha: Vydavatelství VŠCHT Praha, 2005. ISBN 80-7080-569-2. (CS)

26 hours, compulsory

Praktická příručka pro používání výpočetní techniky na FCH (cs) - doporučení systémvého integrátora

• Praktická příručka ICT FCH VUT [.pdf] 151.5 kB