480-2013/02 – Computer Science Exercise and User's Software (PPUS)

Gurantor departmentDepartment of PhysicsCredits3
Subject guarantorMgr. Radim Uhlář, Ph.D.Subject version guarantorMgr. Radim Uhlář, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Study languageEnglish
Year of introduction2018/2019Year of cancellation
Intended for the facultiesUSP, FEI, FMTIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
UHL72 Mgr. Radim Uhlář, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 1+2

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



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/ Chapman, S.J., MATLAB Programming for Engineers, Thomson, 2004.

Recommended literature:

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

Evaluation of given practical tasks.


Other requirements

Performing assigned tasks during the exercises, in the case of the absence additional submission of the tasks solution.


Subject has no prerequisities.


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

Full-time form (validity from: 2018/2019 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Graded credit Graded credit 100  51
Mandatory attendence parzicipation: At the most three absence with leave.

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2020/2021 (B0719A270002) Nanotechnology P English Ostrava 1 Compulsory study plan
2019/2020 (B3942) Nanotechnology (3942R001) Nanotechnology P English Ostrava 1 Compulsory study plan
2019/2020 (B0719A270002) Nanotechnology P English Ostrava 1 Compulsory study plan
2018/2019 (B3942) Nanotechnology (3942R001) Nanotechnology P English Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner