480-2013/01 – Computer Science Exercise and User's Software (PPUS)
Gurantor department | Department of Physics | Credits | 3 |
Subject guarantor | Mgr. Radim Uhlář, Ph.D. | Subject version guarantor | Mgr. Radim Uhlář, Ph.D. |
Study level | undergraduate or graduate | Requirement | Compulsory |
Year | 1 | Semester | winter |
| | Study language | Czech |
Year of introduction | 2018/2019 | Year of cancellation | |
Intended for the faculties | FEI, USP, FMT | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
Repeat the basic knowledge from secondary school information technology.
Solve the simple exercises from basic information technology using the EXCEL and MATLAB.
Teaching methods
Lectures
Tutorials
Summary
The subject Computer Science Exercise and User improves the computer skills gained through the secondary education. It is focused on the spreadsheet software Excel and mathematical computing software MATLAB.
Compulsory 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.
Recommended 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.
Way of continuous check of knowledge in the course of semester
Check of readiness for exercise - written and oral. Passing a written test at the end of the semester.
E-learning
LMS Moodle VŠB – Technická univerzita Ostrava
https://lms.vsb.cz/
Other requirements
Performing assigned tasks during the exercises, in the case of the absence additional submission of the tasks solution.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
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
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction