|
Lecturer(s)
|
|
|
|
Course content
|
1. MS Word - styles, templates, headers and footers. 2. MS Word - content, register, and lists. 3. MS Word - references, bibliography and document revision. 4. MS Word - forms, and automated procedures. 5. MS Excel - basics revision. 6. MS Excel - selected functions and complex formulas. 7. MS Excel - data analysis (basic statistical methods). 8. MS Excel - forms and formula applications. 9. Algorithm and its notation. Algorithm complexity. Time and space complexity. 10. Data storage, data representation, variables, data types. 11. Basic algorithms I. 12. Basic algorithms II.
|
|
Learning activities and teaching methods
|
|
Demonstration
|
|
Learning outcomes
|
The students become familiar with basic concepts of basic software.
MS Word and MS Excel advanced revision - focused on mathematical applications. Basic algorithms knowledge.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
Written exam, Student performance
Active participation in class. Completion of assigned homeworks. Passing the written exam.
|
|
Recommended literature
|
-
J. Chajdiak. (2005). Štatistické úlohy a ich riešenie v Exceli. Bratislava, Statis.
-
K. Murray, M. Millhollon, B. Melton. (2008). Microsoft Office Word 2007. Brno, Computer Press.
-
M. Brož, V. Bezvoda. (2011). Microsoft Excel 2007/2010 : vzorce, funkce, výpočty. Brno, Computer Press.
|