E1020 Soft-skills I - Computer Literacy

Faculty of Science
Autumn 2018
Extent and Intensity
0/1/0. 1 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Mgr. Peter Šebej, Ph.D. (lecturer)
Mgr. Petra Stuchlík Fišerová, Ph.D. (lecturer)
Mgr. Barbora Palátová Nežiková (lecturer)
Guaranteed by
prof. RNDr. Jakub Hofman, Ph.D.
RECETOX - Faculty of Science
Contact Person: Mgr. Peter Šebej, Ph.D.
Supplier department: RECETOX - Faculty of Science
Mon 17. 9. to Fri 14. 12. Tue 15:00–15:50 D29/347-RCX2
High school graduation.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 20 student(s).
Current registration and enrolment status: enrolled: 0/20, only registered: 0/20, only registered with preference (fields directly associated with the programme): 0/20
fields of study / plans the course is directly associated with
Course objectives
The aim of this course is to learn work with MS Office software suite on the level allowing study of natural sciences at the undergraduate level. The emphasis will be on preparation for the future laboratory/practical courses, including simple data processing, their graphical presentation and preparation of the protocol and similar technical documents.
Learning outcomes
Upon course completion students will be able to:
- Use the tools from MS Office to prepare technical documentation.
- Work with simple, mainly quantitative, scientific data.
- Describe observation.
- Write a protocol.
  • Basic computer literacy and orientation in scientific publications at the level of undergraduate study.
  • 1. Introduction, MS Office, basic work on internet
  • 2. MS Word – basic formatting, form of document, revisions, table of contents, numbering, tables, header and footer. Alternative software packages.
  • 3. MS Excel – ordering and filtering of data, settings. Basic work with data (significant figures, data quality: accuracy, precision, deviations, measurements errors: random and systematic),
  • 4. MS Excel – graphs – how to choose suitable graph type, deviations representation, axes and multiple axes, tables, basic equations, linear regresion
  • 5. MS PowerPoint – basic settings, "rules" for aesthetic presentation, preparation of a presentation – basic parts, suggested additions, structure. Other presentation sofwtare (e.g. Prezi, pdf).
  • 6. Writing a protocol – structure and parts, form, interpretation of the laboratory task
  • 7. Sources of chemical, biological, biochemical and other environmentally relevant informations. Primary, secundary and tertiary literature sources. Types of documents. General strategy of the literature recherce.
  • 8. Scientometry, IF, H-index, citation analysis. Introduction to the Web of Science and Scopus.
  • 9. Online access to primary sources. Electronic journals, chemical databases. SciFinder, PubMed, MedLine, Science direct. Reaxys. Databases of chemical componds properties (ChemSpider, Comptox EPA).
  • 10. Scientific paper and its structure. Types of papers. How to read a paper.
  • 11. Peer-review: process, importance, reliability. Citation tools: EndNote, Zotero, Mendeley. Accessing documents from libraries. Library databases, KUK, Aleph. Cite-while-write, use of citation tools for effective writing.
  • 12. The dark side of open access: pretending peer-review, SciHub, ResearchGate, bookfi. Publication ethic. Repeating.
  • Žitniak, Ján. Microsoft Office 2016 Podrobná uživatelská příručka. Computer Press, 2017. 528 s. ISBN:978-80-251-4891-4
  • JANŮ, Stanislav. Bible MS Office 2013 a 365. Brno: Zoner Press, 2013. 287 s. ISBN 9788074132681. info
  • SYNEK, Miloslav, Pavel MIKAN and Hana VÁVROVÁ. Jak psát bakalářské, diplomové, doktorské a jiné písemné práce. 3., přeprac. vyd. Praha: Oeconomica, 2011. 61, [8]. ISBN 9788024518190. info
Teaching methods
lectures, computer class, class discussion, seminar
Assessment methods
Credit is given for attendance on at least 80% of hours and an anonymous peer-review of a text (e.g., a lab. coursework protocol or a bachelor thesis chapter) authored by other student of the course.
Language of instruction
Follow-Up Courses
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Autumn 2019, Autumn 2020, autumn 2021, Autumn 2022.
  • Enrolment Statistics (Autumn 2018, recent)
  • Permalink: https://is.muni.cz/course/sci/autumn2018/E1020