PřF:E1020 Soft-skills I - PC Literacy - Course Information
E1020 Soft-skills I - Computer LiteracyFaculty of Science
- Extent and Intensity
- 0/1/0. 1 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Taught in person.
- Mgr. Peter Šebej, Ph.D. (lecturer)
Mgr. Jakub Urík, Ph.D. (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
- Timetable of Seminar Groups
- E1020/1: Tue 15:00–15:50 D29/347-RCX2, P. Šebej, J. Urík
E1020/2: Mon 16:00–16:50 D29/347-RCX2, P. Šebej, J. Urík
E1020/3: Mon 17:00–17:50 D29/347-RCX2, P. Šebej, J. Urík
- 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.
- 1. Introduction, MS Office, basic work on internet, MS Teams
- 2. Protocol, laboratory diary. Relationship of experiment records and protocol. Writing of protocol – structure and parts, form, interpretation of the laboratory task
- 3. Protocol examples. Preparation of tentative protocol with interpretation of data set, conclusion. Application of software tools.
- 4. Structure of the text. Logic and coherence. Essay. Scientific essay.
- 5. 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.
- 6. Popular science. Popular scientific text.
- 7. MS Word – basic formatting, form of document, revisions, table of contents, numbering, tables, header and footer. Alternative software packages.
- 8. MS Excel – ordering and filtering of data, settings. Basic work with data (significant figures, data quality: accuracy, precision, deviations, measurements errors: random and systematic),
- 9. MS Excel – graphs – how to choose suitable graph type, deviations representation, axes and multiple axes
- 10. MS Excel – tables, basic equations, linear regresion
- 11. MS PowerPoint – basic settings, "rules" for aesthetic presentation, preparation of a presentation – basic parts, suggested additions, structure. Other presentation sofwtare.
- 12. Evaluation of students' works, final assessment, Q&A
- Ž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, . 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
- Follow-Up Courses
- Further Comments
- Study Materials
The course is taught annually.