SubjectsSubjects(version: 876)
Course, academic year 2020/2021
Applications of Computer Science - S445001A
Title: Applications of Computer Science
Guaranteed by: Department of Computing and Control Engineering (445)
Actual: from 2011
Semester: summer
Points: summer s.:3
E-Credits: summer s.:3
Examination process: summer s.:
Hours per week, examination: summer s.:0/3 C [hours/week]
Capacity: unknown / unknown (unknown)
Min. number of students: unlimited
Language: English
Teaching methods: full-time
For type:  
Guarantor: Hrnčiřík Pavel doc. Ing. Ph.D.
This subject contains the following additional online materials
Last update: Hrnčiřík Pavel doc. Ing. Ph.D. (28.05.2012)
The course is focused on fundamentals of technical computing in common spreadsheet environment (MS EXcel). Featured techniques include: numerical solution of non-linear equations (e.g. by the Solver tool), numerical solution of systems of linear equations via inverse matrices, experimental data fitting using linear/non-linear functions, numerical integration/derivation
Last update: Hrnčiřík Pavel doc. Ing. Ph.D. (28.05.2012)

1. E-learning Portal of the Department of Computing and Control Engineering (in Czech) -

2. E. Joseph Billo: Excel for Scientists and Engineers: Numerical Methods, Wiley-Interscience, 2007.

Syllabus - Czech
Last update: Šmídová Ludmila (20.01.2012)

1. Fundamental terms of computer science. File management.

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

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

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

5. Application examples No. 1.

6. Test from first of the three thematic parts (file management, work with MS Word and MS Excel).

7. Solving nonlinear equations.

8. Solving system of linear equations.

9. Linear approximation of functions.

10. Nonlinear approximation of functions.

11. Computation methods of numerical integration and derivation.

12. Application examples No. 2.

13. Test of computation methods - first half of a group.

14. Test of computation methods - second half of a group.