# 480-2013/02 – 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 English Year of introduction 2018/2019 Year of cancellation Intended for the faculties USP, FEI, FMT Intended for study types Bachelor
Instruction secured by
Extent of instruction for forms of study
Form of studyWay of compl.Extent

### 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.

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/ 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.

### 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

Full-time form (validity from: 2018/2019 Winter semester)
Min. number of points
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