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).
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
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
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.ISBN 978-0073380278 .
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.ISBN 978-0073380278 .
Advised literature
Etheridge, D. Excel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and PivotTables, Wiley Publishing, 2007.ISBN 978-1118517147 .
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.
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.