155-1553/01 – Data processing on PC (ZDEng)
Gurantor department | Department of Applied Informatics | Credits | 4 |
Subject guarantor | Ing. Vítězslav Novák, Ph.D. | Subject version guarantor | Ing. Vítězslav Novák, Ph.D. |
Study level | undergraduate or graduate | | |
| | Study language | English |
Year of introduction | 2016/2017 | Year of cancellation | |
Intended for the faculties | EKF | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
To be able to process larger amounts of data using Microsoft Excel tools such as subtotals, pivot tables or PowerPivot add-in.
To be able to process data from other applications.
To understand the difference between databases in Microsoft Excel and Access.
Teaching methods
Lectures
Tutorials
Summary
The aim of the course is to familiarize students with the possibilities of Microsoft Excel spreadsheet for data analysis. The show will be applicable to the basic fuctions and advanced tools such as structured tables, pivot tables, Power Query tool for data transformations and Power Pivot add-in for managing data models.
Compulsory literature:
Recommended literature:
Way of continuous check of knowledge in the course of semester
Evaluation of acquired knowledge and skills is verified by the test (51 - 100 points).
The test verifies basic understanding of Excel.
E-learning
Other requirements
No other requirements.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Lectures:
1) Addressing in Excel
2) Excel Statistical Functions
3) Excel Other Functions
4) Formatting in Excel
5) Charts in Excel
6) Lists in Excel
7) Structured Tables in Excel
8) Pivot Tables and Charts
9) Using of Power Pivot and Power Query
10) Comparison of Excel and Access
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.