Skip to main content
Skip header

Software tools for study

* Exchange students do not have to consider this information when selecting suitable courses for an exchange stay.

Course Unit Code654-2200/01
Number of ECTS Credits Allocated3 ECTS credits
Type of Course Unit *Compulsory
Level of Course Unit *First Cycle
Year of Study *First Year
Semester when the Course Unit is deliveredWinter Semester
Mode of DeliveryFace-to-face
Language of InstructionCzech
Prerequisites and Co-Requisites There are no prerequisites or co-requisites for this course unit
Name of Lecturer(s)Personal IDName
LAM37Ing. Martin Lampa, Ph.D.
Summary
The course introduces students to the basics of working with the MS Office software package, image editors, 2D and 3D graphic editors. It introduces students to modern trends in the field of IT.
Learning Outcomes of the Course Unit
Knowledge gained:
-The student will understand the principles of working in the MS Office environment, Word, Excel, Powerpoint.
-The student will be able to work with correspondence, communicate using online means.
-The student will be able to work with image editor and will be able to use cloud storage.
-The student will understand the principles of 2D and 3D graphics and 3D printing.
-The student will be familiar with current trends in IT development.

Skills acquired:
-The student will be able to use a PC for routine work in his/her studies.
-The student will be able to use the advanced features and analytical tools contained in MS Office to make the computer a tool for technical and scientific work.
-The student will be able to create 2D and 3D images and then work with a 3D printer.
Course Contents
1. Introduction to the subject. Introduction of MS Office and other alternative programs. Information systems and resources of VŠB-TUO (INNet, Edison for students, LMS Moodle).
2. Word: creating a document (professional article, technical report) and working with text, styles, writing mathematical equations, creating tables, embedded images, automatic numbering of embedded objects.
3. Word: working with SmartArt, links and cross-references (tables of contents, indexes), revising the document, inserting add-ins.
4. Excel: basic operations in the environment, cell references, performing calculations, visualizing results, working with charts.
5. Excel: functions, data analysis, approximation of experimental data.
6. Excel: functions, data analysis, approximation of experimental data, application tasks.
7. Powerpoint: presentation basics, alternative presentation programs (mind maps), pdf presentations.
8. MS Outlook: work with mail, calendar and tasks. MS Teams basics of online communication and linking with MS Outlook. Alternative communication tools for online teaching and presentation.
9. Editing of photos and their inclusion in the document. Painting the picture. Cloud storage, principles and uses.
10. Vector graphics and principles of 2D drawing. 2D technical drawing working with layers, operations with drawn objects.
12. 3D printing, principles of printers, functions, operations before printing.
Recommended or Required Reading
Required Reading:
JOHNSON, Robert, Excel 2022. Independently published 2022. ISBN: ‎ 979-8356241734.
HOLLER, James, Microsoft Office 365 for Beginners 2022. Independently published, 2022, ISBN‏ : ‎ 979-8833565759
ŠPIČKA, Ivo. Počítačová technika I [CD-ROM]. Ostrava: Vysoká škola báňská - Technická univerzita Ostrava, 2015. ISBN 978-80-248-3709-3.
PECINOVSKÝ, Josef a Rudolf PECINOVSKÝ. Office 2019: & Office 365 : průvodce uživatele. Praha: Grada Publishing, 2019. Průvodce (Grada). ISBN 978-80-247-2303-7.NAVARRŮ, Miroslav. Excel 2019: podrobný průvodce uživatele. Praha: Grada, 2019. Průvodce. ISBN 978-80-247-2026-5.
HOLLER, James, Microsoft Office 365 for Beginners 2022. Independently published, 2022, ISBN‏ : ‎ 979-8833565759
Recommended Reading:
HAUSMAN, Kalani Kirk a Richard HORNE. 3D printing for dummies. Hoboken: Wiley, c2014. For dummies (Wiley). ISBN 978-1-118-66075-1.
ŠINDLER, Jaroslav. Microsoft Teams: praktická příručka po týmovou spolupráci. Praha: Grada Publishing, 2022. ISBN 978-80-271-1023-0.
KLOSKI, Liza Wallach a Nick KLOSKI. Začínáme s 3D tiskem. Přeložil Jakub GONER. Brno: Computer Press, 2017. ISBN 978-80-251-4876-1.
ŠPIČKA, Ivo, Robert FRISCHER. Počítačová geometrie a grafika [CD-ROM]. Ostrava: Vysoká škola báňská - Technická univerzita Ostrava, 2012. ISBN 978-80-248-2590-8.
Planned learning activities and teaching methods
Tutorials
Assesment methods and criteria
Task TitleTask TypeMaximum Number of Points
(Act. for Subtasks)
Minimum Number of Points for Task Passing
Graded creditGraded credit100 51