SubjectsSubjects(version: 949)
Course, academic year 2023/2024
Information technologies - N445049
Title: Informační technologie
Guaranteed by: Department of Computing and Control Engineering (445)
Faculty: Faculty of Chemical Engineering
Actual: from 2011
Semester: winter
Points: winter s.:7
E-Credits: winter s.:7
Examination process: winter s.:
Hours per week, examination: winter s.:1/6, MC [HT]
Capacity: unknown / unknown (unknown)
Min. number of students: unlimited
Language: Czech
Teaching methods: full-time
Teaching methods: full-time
For type:  
Note: course can be enrolled in outside the study plan
enabled for web enrollment
Guarantor: Hrnčiřík Pavel doc. Ing. Ph.D.
Švihlík Jan doc. Ing. Ph.D.
Incompatibility : N445001
Is incompatible with: N445037
Examination dates   Schedule   
Literature - Czech
Last update: Hrnčiřík Pavel doc. Ing. Ph.D. (11.09.2009)

1. Brož M.: Microsoft Word 2002 Podrobná příručka, Grada 2003

2. Brož M.: Mistrovství v Microsoft Excel 2000 a 2002, Grada 2003

Requirements to the exam - Czech
Last update: Hrnčiřík Pavel doc. Ing. Ph.D. (21.09.2009)

Předmět je zakončen klasifikovaným zápočtem, k získání zápočtu je nutné z každého ze 2 testů a samostatného projektu získat alespoň 50 % z max. možného bodového ohodnocení.

Syllabus -
Last update: Hrnčiřík Pavel doc. Ing. Ph.D. (24.09.2009)

Part A

1. Technical documents in MS Word - formulas and equations, tables.

2. Mail merge, templates and electronic forms.

3. MS Excel - using formulas and functions (recapitulation knowledge).

4. Excel - matrices, matrix constants and equations.

5. Chart in MS Excel, inserting excel's tables and charts into MS Word.

6. Solving nonlinear equations.

7. Solver.

8. Solving systems of linear equations.

9. Linear approximation of functions.

10. Nonlinear approximation of functions.

11. Computation methods of numerical integration and derivation.

12. Application examples.

13. Test of computation methods

14. Test of computation methods - correction term