BMOF011 MS Office applications

Faculty of Medicine
autumn 2019
Extent and Intensity
0/2/0. 3 credit(s). Type of Completion: z (credit).
RNDr. Martin Komenda, Ph.D. (lecturer)
Mgr. Matěj Karolyi (lecturer)
Mgr. Renata Chloupková (lecturer)
Guaranteed by
prof. RNDr. Ladislav Dušek, Ph.D.
Institute of Biostatistics and Analyses - Other Departments for Educational and Scientific Research Activities - Faculty of Medicine
Contact Person: RNDr. Martin Komenda, Ph.D.
Supplier department: Institute of Biostatistics and Analyses - Other Departments for Educational and Scientific Research Activities - Faculty of Medicine
Mon 12:00–13:40 A1/609 - IBA (A1,6.p, Kamenice 3)
Prerequisites (in Czech)
Předpokladem je pouze základní zkušenost s prací na počítači. Kurz je nabízen studentům a všem členům akademické obce na Masarykově univerzitě, dále pak postgraduálním studentům a zaměstnancům Lékařské fakulty MU.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
Practically oriented course for undergraduate students, PhD students and also for staff of Medical faculty. The course is aimed on skills in using MS Office products in scientific practice:
General use of MS Office 2016; The use of MS Word for common and scientific work; The use of MS Powerpoint for presentations; The basics of MS Excel.

Learning outcomes
The student will understand the basic concept of working with MS Word, PowerPoint and Excel.
Students are able to work effectively in the mentioned environments and master the advanced functionalities required to work with more complex documents.
The student knows complex application settings and is able to adapt them to the demands that are made in his / her way of working.
  • The course is divided into three separated parts: The use and general functions of MS PowerPoint, MS Word and MS Excel. The lectures are focused on MS Office 2016 including brief overview, which relates to the differences between previous versions.

  • MS PowerPoint

  • • Graphical settings and templates • Charts and tables • Guidelines for preparation of successful presentations • Export and compatibility

  • MS Word

  • • Settings and basics • Document creation and formatting • Work with tables and pictures • Usage of styles • Bibliography (application Zotero) • Revision tools and security • Tips and tricks

  • MS Excel

  • • Introduction into MS Excel environment, controls and formatting, • Basic types of data, data formats • Data imports from files, web and databases, • Tips and tricks, shortcuts • Copy, paste and cut • Interaction with other Office applications • Window layouts, panes • Data checks and cleanup • Input forms, automatic data inspection • Lists, filters, automatic repair and finishing, • Formulas • Absolute and relative links • Functions • Graphs and minigraphs • Contingency tables and graphs • Locking cells, worksheets and workbooks • Macros

    recommended literature
  • John Pierce. Mistrovství v Microsoft Office 2007. CPress. ISBN 978-80-251-2066-8
Teaching methods
Practical training using computers.
Assessment methods
Attendance - at least 90% of lectures. Active participation.
Language of instruction
Further comments (probably available only in Czech)
Study Materials
The course is taught annually.
Information on the extent and intensity of the course: 30.
Teacher's information
The course is also listed under the following terms Autumn 2002, Spring 2003, Autumn 2003, Spring 2004, Autumn 2004, Spring 2005, Autumn 2005, Spring 2006, Autumn 2006, Spring 2007, Autumn 2007, Spring 2008, Autumn 2008, Spring 2009, Autumn 2009, Spring 2010, Autumn 2010, Spring 2011, Autumn 2011, Spring 2012, Autumn 2012, Spring 2013, Autumn 2013, Autumn 2014, Autumn 2015, Autumn 2016, Autumn 2017, autumn 2018, autumn 2020.
  • Enrolment Statistics (autumn 2019, recent)
  • Permalink: