|
Lecturer(s)
|
|
|
|
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
|
|
Monologic Lecture(Interpretation, Training), Demonstration, Grafic and Art Activities, Activating (Simulations, Games, Dramatization)
|
|
Learning outcomes
|
The course should help students to practically use main programmes of Microsoft Office package including Microsoft Word, Microsoft Excel and Microsoft Powerpoint. Some of the topics are: work with text, indexes, pictures, notations, contents creation, function, cross analysis, presentation creation, dynamical presentation, etc.
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
|
Written exam
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.
|