| Course Unit Code | 480-2013/01 |
|---|
| Number of ECTS Credits Allocated | 3 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | First Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | There are no prerequisites or co-requisites for this course unit |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| UHL72 | Mgr. Radim Uhlář, Ph.D. |
| 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. |
| Learning Outcomes of the Course Unit |
|---|
Repeat the basic knowledge from secondary school information technology.
Solve the simple exercises from basic information technology using the EXCEL and MATLAB. |
| Course Contents |
|---|
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 |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
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.
|
Navarrů, M. EXCEL 2019: Podrobný průvodce uživatele, GRADA, 2019.
Zaplatílek, K., Doňar, B., MATLAB pro začátečníky, BEN - technická literatura, 2005.
Tvrdík, J., Pavliska, V., Bujok, P., Základy modelování v MATLABU, Ostravská Univerzita, 2010.
Musto, J.C., Howard, W.E., Williams, R.R., Engineering Computations: An Introduction Using MATLAB and Excel, 2nd edition, McGraw Hill, 2021.
|
| Recommended Reading: |
|---|
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.
|
Barilla, J., Simr, P., Sýkorová, K. Microsoft Excel 2010 Podrobná uživatelská příručka, Computer Press, 2010.
Etheridge, D. Excel 2007 Data Analysis: Your visual blueprint for creating and analyzing data, charts, and PivotTables, Wiley Publishing, 2007 |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Graded credit | Graded credit | 100 | 51 |