SubjectsSubjects(version: 896)
Course, academic year 2021/2022
Applications of Computer Science - S445001
Title: Applications of Computer Science
Guaranteed by: Department of Computing and Control Engineering (445)
Actual: from 2021
Semester: winter
Points: winter s.:3
E-Credits: winter s.:3
Examination process: winter s.:
Hours per week, examination: winter s.:0/3 C [hours/week]
Capacity: unknown / unknown (unknown)
Min. number of students: unlimited
Language: English
Teaching methods: full-time
Is provided by: AB445001
For type:  
Guarantor: Hrnčiřík Pavel doc. Ing. Ph.D.
Examination dates   Schedule   
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: KNOBLOCL (15.12.2011)

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.