|
Lecturer(s)
|
-
Bednář Marek, Ing.
-
Pánek Jiří, doc. Mgr. Ph.D.
|
|
Course content
|
1.WINWORD - keyboard shortcuts, basic tips for file processing, formatting, styles 2. Long documents, outline, content and index creation, list of pictures, tables 3. EXCEL - getting started with MS Excel 4. Operators, absolute vs relative adressing 5. Functions 6. Conditional formatting 7. Graph and data visualization, cross tables and graphs 8. Lists, filters, extended filters 9. Analytical tools, basic statistics 10. Matrix equations, forecasting functions 11. MS Access - data import and export, running queries 12. Sensitivity analysis tools, solver.
|
|
Learning activities and teaching methods
|
|
Lecture, Demonstration, Activating (Simulations, Games, Dramatization)
|
|
Learning outcomes
|
The course should help students to process documents both text and numeric using tolls of Microsoft Office, namely MS Excel.
Students know basic skills and tools for data processing using generally common software like MS Word, MS Access and MS Excel. Students know how to visualize, analyze, process and query data using various methods.
|
|
Prerequisites
|
Basic computer skills.
|
|
Assessment methods and criteria
|
Student performance, Seminar Work
Course assessment: written examination.
|
|
Recommended literature
|
-
Bednář, M. (2012). Práce s počítačem. Zpracování dat. UP Olomouc. Katedra rozvojových studií.
-
Dixon, H. (2007). Excel 2007: Beyond the Manual. Springer-Verlag. New York.
-
Matúš, Z. (2011). Excel 2007-2010 v příkladech. Kralice na Hané : Computer Media.
-
Pecinovský J. (2011). Excel a Access 2010 : efektivní zpracování dat na počítači / Josef Pecinovský. Praha : Grada.
-
Pecinovský, J. (2009). Excel 2007 v příkladech. Praha : Grada.
-
Pecinovský, J. (2010). Word 2010 - podrobný průvodce. Praha : Grada.
|