Lecturer(s)
|
-
Plíva Zdeněk, prof. Ing. Ph.D.
-
Petržílka Leoš, Ing.
|
Course content
|
Main topics: - Office application overview, selected functions for data analysis. - Database table preparation and editation, basic functions. -. Database tools in spreadsheet (MS Excel). - Contingency tables, work with SQL statements (MS Query). - Data analysis using spreadsheet. - Data presentation - tables, charts, graphs. - Database - tables, queries, forms. - Database applications (MS Access). - Data Import and Export, data exchange. - Extended topics in spreadsheets, forms, macros. Exercises complement the lectures and practice: practical work with the "office" tools.
|
Learning activities and teaching methods
|
Lecture, Practicum
- Contacts hours
- 40 hours per semester
|
Learning outcomes
|
This subject is focussed on acquisition of basic skills in data evaluation, processing and presentation, and in preparation of different presentation materials.
The aim is the ability in data processing using standard office tools and in data presentation.
|
Prerequisites
|
No condition of registration
|
Assessment methods and criteria
|
Oral presentation of self-study, Written assignment
Activity on seminars, successful passing the tests, presentation of the individual project documentation and understanding of the lectured topics are required for getting the classified credit.
|
Recommended literature
|
-
BARILLA, Jiří. Microsoft Excel 2013: podrobná uživatelská příručka.. Computer Press, Brno, 2013. ISBN 978-80-251-4114-4.
-
BELKO, Peter. Microsoft Access 2013: podrobná uživatelská příručka.. Computer Press, Brno, 2014. ISBN 978-80-251-4125-0.
-
PECINOVSKÝ, Josef. Word 2013: podrobná uživatelská příručka. Computer Press, Brno, 2013. ISBN 978-80-251-3831-1.
-
ROUBALOVÁ, Eliška. Microsoft PowerPoint 2013: jednoduše.. Computer Press, Brno, 2014. ISBN 978-80-251-4122-9.
|