Computer Science Exercise and User's Software

Type of study	Bachelor
Language of instruction	Czech
Code	480-2013/01
Abbreviation	PPUS
Course title	Computer Science Exercise and User's Software
Credits	3
Coordinating department	Department of Physics
Course coordinator	Mgr. Radim Uhlář, Ph.D.

Subject syllabus

1. Excel: Working with workbooks and worksheets, interface; Introduction to formulas and functions; Logical functions
2. Cell references: absolute, relative, mixed and external; copy the formulas
3. Text functions; Lookup and reference functions
4. Statistical functions; rounding of numbers; Array formulas; Solving the system of linear equations
5. Analysis of the data: sorting and filtering; conditional formatting
6. Creating, adjustment and formatting of the chart
7. Typographic conventions for editing a text with mathematics symbols
8. Introduction to MATLAB
9. Alternatives to MATLAB (e.g. Octave); The MATAB environment; elementary operations (command line)
10. Variables, arrays and matrixes; array and matrix operations
11. Saving the data into a file and loading the data from a file; loops
12. Creating, adjustment and formatting of the chart; Symbolic mathematics
13. The basic commands in LINUX

E-learning

Materials are available at https://lms.vsb.cz/?lang=en.
Selected study materials are published on the e-learning portal (https://www.vsb.cz/e-vyuka/en).

Literature

Winston, W.L., Microsoft Excel 2010: Data Analysis and Business Modeling, Microsoft Press, 2011.
Walkenbach, J.: Excel 2013 Power Programming with VBA, Wiley, 2013.
http://www.excel-easy.com/
https://www.mathworks.com/
Musto, J.C., Howard, W.E., Williams, R.R., Engineering Computations: An Introduction Using MATLAB and Excel, 2nd edition, McGraw Hill, 2021. .

Advised literature

Etheridge, D. Excel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and PivotTables, Wiley Publishing, 2007. .
Chapman, S.J., MATLAB Programming for Engineers, Thomson, 2004.
Etheridge, D. Excel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and PivotTables, Wiley Publishing, 2007.

back to search page