Course: Basic Software

« Back
Course title Basic Software
Course code KMI/ZSW
Organizational form of instruction Seminar
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 3
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Procházka Pavel, Mgr.
  • Laštovička Jan, Mgr.
  • Zacpal Jiří, Mgr. Ph.D.
  • Motyčková Lenka, doc. Ing. CSc.
  • Hronek Jiří, Ing.
  • Ježková Lucie, Mgr.
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.


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Science Mathematics-Economics of Banking / Insurance Systems (1) Mathematics courses 1 Winter
Faculty of Science Applied Statistics (2015) Mathematics courses 1 Winter