480-2013/01 – 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
Year1Semesterwinter
Study languageCzech
Year of introduction2018/2019Year of cancellation
Intended for the facultiesFEI, USP, 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

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

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

Show history

Conditions for subject completion and attendance at the exercises within ISP: Completion of all mandatory tasks within individually agreed deadlines.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2024/2025 (B0533A110023) Applied Physics P Czech Ostrava 1 Compulsory study plan
2023/2024 (B0533A110023) Applied Physics P Czech Ostrava 1 Compulsory study plan
2022/2023 (B0533A110023) Applied Physics P Czech Ostrava 1 Compulsory study plan
2022/2023 (B0719A270001) Nanotechnology P Czech Ostrava 1 Compulsory study plan
2021/2022 (B0719A270001) Nanotechnology P Czech Ostrava 1 Compulsory study plan
2021/2022 (B0533A110023) Applied Physics P Czech Ostrava 1 Compulsory study plan
2020/2021 (B0719A270001) Nanotechnology P Czech Ostrava 1 Compulsory study plan
2020/2021 (B0533A110023) Applied Physics P Czech Ostrava 1 Compulsory study plan
2019/2020 (B0533A110023) Applied Physics P Czech Ostrava 1 Compulsory study plan
2019/2020 (B0719A270001) Nanotechnology P Czech Ostrava 1 Compulsory study plan
2018/2019 (B3942) Nanotechnology (3942R001) Nanotechnology P Czech Ostrava 1 Compulsory study plan
2018/2019 (B1701) Physics (1702R001) Applied Physics P Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2022/2023 Winter
2021/2022 Winter
2020/2021 Winter
2019/2020 Winter
2018/2019 Winter