155-1353/01 – Data processing on PC (ZD)
| 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 | Requirement | Choice-compulsory |
| Year | 3 | Semester | winter |
| | Study language | Czech |
| Year of introduction | 2013/2014 | 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 totals or pivot tables of Microsoft Excel.
To understand the difference between a databases in Microsoft Excel and Access.
To design relational databases.
To use statements SELECT, INSERT, UPDATE and DELETE of SQL language.
To create database applications in Microsoft Office Access.
Teaching methods
Lectures
Tutorials
Summary
The aim of subject is to extend the knowledge and skills in the areas of business data processing on a PC using a spreadsheet and DBMS (using of MS Excel and MS Access is supposed). In MS Excel, students will be introduced to the processing of large amounts of data using subtotals, pivot tables or charts, PowerPivot or Power BI add-ins. In Microsoft Access, students will be learned to create a databases, to query data of the databases or to create a simple graphical user interface.
Compulsory literature:
Recommended literature:
Way of continuous check of knowledge in the course of semester
Hodnocení nabytých vědomostí a dovedností je ověřováno dvěma projekty v průběhu semestru.
První projekt ověřuje pochopení látky po přednášce Kontingenční tabulky a grafy MS Excelu. Úkolem je zpracování seznamu dat pomocí kontingenční tabulky.
Druhý projekt ověřuje pochopení látky celého předmětu. Úkolem je implementace jednoduché databázové aplikace na MS Accessu. Je odevzdáván v zápočtovém týdnu nebo později.
E-learning
Přednášky a cvičení jsou ve formátu PDF v LMS Moodle.
Other requirements
No other requirements.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
Lectures:
1) Working with lists in MS Excel.
2) Pivot tables and charts in MS Excel.
3) Design of relational databases.
4) Creating tables in MS Access.
5) Querying in MS Access.
6) Creating graphical user interface in MS Access.
7) Cooperation between MS Excel and MS Access.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.