654-2200/01 – Software tools for study (SNS)

Gurantor departmentDepartment of Industrial Systems ManagementCredits3
Subject guarantorIng. Martin Lampa, Ph.D.Subject version guarantorIng. Martin Lampa, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year1Semesterwinter
Study languageCzech
Year of introduction2023/2024Year of cancellation
Intended for the facultiesFMTIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
BEC0052 Ing. Miloslav Bečka
LAM37 Ing. Martin Lampa, Ph.D.
SIR0048 Ing. Tomáš Sirník
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 0+3
Part-time Graded credit 0+12

Subject aims expressed by acquired skills and competences

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.

Teaching methods

Tutorials

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.

Compulsory literature:

JOHNSON, Robert, Excel 2022. Independently published 2022. ISBN: ‎ 979-8356241734. HOLLER, James, Microsoft Office 365 for Beginners 2022. Independently published, 2022, ISBN‏ : ‎ 979-8833565759

Recommended literature:

HAUSMAN, Kalani Kirk a Richard HORNE. 3D printing for dummies. Hoboken: Wiley, c2014. For dummies (Wiley). ISBN 978-1-118-66075-1.

Way of continuous check of knowledge in the course of semester

Graded credit, Powerpoint presentation, test, final project.

E-learning

Other requirements

There are no other requirements.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

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.

Conditions for subject completion

Full-time form (validity from: 2023/2024 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Graded credit Graded credit 100  51 3
Mandatory attendence participation: A maximum of 3 absences from exercises. Elaboration of assigned tasks.

Show history

Conditions for subject completion and attendance at the exercises within ISP: Completion of all mandatory tasks within individually agreed deadlines.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2025/2026 (B0715A270004) Materials Engineering K Czech Ostrava 1 Compulsory study plan
2025/2026 (B0715A270004) Materials Engineering P Czech Ostrava 1 Compulsory study plan
2024/2025 (B0715A270004) Materials Engineering P Czech Ostrava 1 Compulsory study plan
2024/2025 (B0715A270004) Materials Engineering K Czech Ostrava 1 Compulsory study plan
2023/2024 (B0715A270004) Materials Engineering K Czech Ostrava 1 Compulsory study plan
2023/2024 (B0715A270004) Materials Engineering P Czech Ostrava 1 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2023/2024 Winter