Skip to main content
Skip header

ECTS Course Overview



Data processing on PC

* Exchange students do not have to consider this information when selecting suitable courses for an exchange stay.

Course Unit Code155-1553/01
Number of ECTS Credits Allocated4 ECTS credits
Type of Course Unit *Choice-compulsory
Level of Course Unit *First Cycle
Year of Study *
Semester when the Course Unit is deliveredSummer Semester
Mode of DeliveryFace-to-face
Language of InstructionEnglish
Prerequisites and Co-Requisites Course succeeds to compulsory courses of previous semester
Name of Lecturer(s)Personal IDName
NOV21Ing. Vítězslav Novák, Ph.D.
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.
Learning Outcomes of the Course Unit
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.
Course Contents
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) Basic statements of SQL Language.
7) Creating graphical user interface in MS Access.
Recommended or Required Reading
Required Reading:
WALKENBACH, John. Excel 2010 bible. Indianapolis, IN: Wiley Publishing, 2010. ISBN 978-0470474877.
GROH, Michael R. Access 2010 bible. Indianapolis, IN: Wiley Publishing, 2010. ISBN 978-0470475348.
LAURENČÍK, Marek. Excel 2010: práce s databázemi a kontingenčními tabulkami. Praha: Grada Publishing, 2011. 168 s. ISBN 978-80-247-3986-1.
PECINOVSKÝ, Josef. Excel a Access 2010: efektivní zpracování dat na počítači. Praha: Grada Publishing, 2011. 198 s. ISBN 978-80-247-3898-7.
KRUCZEK, Aleš. Microsoft Access 2010: podrobná uživatelská příručka. Brno: Computer Press, 2010. 392 s. ISBN 978-80-251-3289-0.
Recommended Reading:
FRYE, Curtis. Microsoft Excel 2010: step by step. Redmond, Wash.: Microsoft Press, 2010. ISBN 978-0735626942.
COX, Joyce a Joan LAMBERT. Microsoft Access 2010: step by step. Redmond, Wash.: Microsoft Press, 2010. ISBN 978-0735626928.
PÍSEK, Slavoj. Access 2010: podrobný průvodce. Praha: Grada Publishing, 2011. 160 s. ISBN 978-80-247-3653-2.
DODGE, Mark a Craig S. DOUGLAS. Mistrovství v Microsoft Excel 2010. Brno: Computer Press, 2011. 935 s. ISBN 978-80-251-3354-5.
Planned learning activities and teaching methods
Lectures, Tutorials
Assesment methods and criteria
Tasks are not Defined