E1020 Soft-skills I - Computer Literacy

Faculty of Science
Autumn 2019
Extent and Intensity
0/1/0. 1 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Mgr. Peter Šebej, Ph.D. (seminar tutor)
Mgr. Jakub Urík, Ph.D. (seminar tutor)
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
Timetable of Seminar Groups
E1020/01: Mon 13:00–13:50 D29/347-RCX2
E1020/02: Mon 17:00–17:50 D29/347-RCX2
E1020/03: Tue 11:00–11:50 D29/347-RCX2
Prerequisites
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.
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.
Syllabus
  • 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
  • 5. MS Excel – tables, basic equations, linear regresion
  • 6. MS PowerPoint – basic settings, "rules" for aesthetic presentation, preparation of a presentation – basic parts, suggested additions, structure. Other presentation sofwtare.
  • 7. Protocol, laboratory diary. Relationship of experiment records and protocol. Writing of protocol – structure and parts, form, interpretation of the laboratory task
  • Protocol examples. Preparation of tentative protocol with interpretation of data set, conclusion. Application of software tools.
  • 8. Structure of the text. Logic and coherence. Essay. Scientific essay.
  • 9. Repeating or widening/deepening of chosen topic(s) according to students demand.
  • 10. The path from a technical protocol to popular scientific text (and later to scientific paper). How to build a logical story. Data and their relationships.
  • 11. Popular science. Popular scientific text.
  • 12. Evaluation of students' works, final assessment, Q&A
Literature
  • Ž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 preparation of a protocol based on assigned example lab. coursework (includes description of experiment and corresponding dataset) and for attendance at seminars (not more than 2 absented hours).
Language of instruction
Czech
Follow-Up Courses
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Autumn 2018, Autumn 2020, autumn 2021, Autumn 2022, Autumn 2023, Autumn 2024.
  • Enrolment Statistics (Autumn 2019, recent)
  • Permalink: https://is.muni.cz/course/sci/autumn2019/E1020