545-0157/01 – Information Technology Application II (AVTII)

Gurantor departmentDepartment of Economics and Control SystemsCredits3
Subject guarantorRNDr. Radmila Sousedíková, Ph.D.Subject version guarantorRNDr. Radmila Sousedíková, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semestersummer
Study languageCzech
Year of introduction2020/2021Year of cancellation
Intended for the facultiesHGFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
ROL74 Ing. Markéta Laštůvková, Ph.D.
SOU70 RNDr. Radmila Sousedíková, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 1+2
Part-time Graded credit 4+8

Subject aims expressed by acquired skills and competences

Generating knowledge concerning modern working processes in Microsoft Office, application to written professional text, simple economic analysis with spread sheet in raw-materials industry.

Teaching methods

Lectures
Tutorials

Summary

The subject concerns modern working processes in Microsoft Office and their application to written professional text, presentation and economic analysis in raw-materials industry with spreadsheet.

Compulsory literature:

MAYES, Timothy R. Financial analysis with Microsoft Excel 2019. 9th edition. Boston: Cengage, 2021. ISBN 978-0357-44205-0. CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. Upper Saddle River: Pearson Education, 2019. ISBN 978-0-7897-5958-0. LAMBERT, Joan. Microsoft Office 2019 Step by Step. Microsoft Press U.S., 2018. ISBN 9781509307685. LAMBERT, Joan. Microsoft Word 2019 Step by Step. Microsoft Press U.S., 2019. ISBN 978150930587.

Recommended literature:

WINSTON, Wayne L. Microsoft Excel 2019: data analysis and business modeling. Sixth edition. New York: Pearson Education, 2019. ISBN 978-1-5093-0588-9. LAMBERT, Joan. Microsoft Word 2016 Step by Step. Microsoft Press, 2015. ISBN 9780735699236. MELTON, Beth et al. Microsoft Office Professional 2013: Step by Step. Sebastopol, Calif.: O'Reilly Media, 2013. ISBN 9780735669413. MURRAY, Katherine. Microsoft Office Professional 2013. Sebastopol, Calif.: O'Reilly Media, 2013. ISBN 9780735669321.

Way of continuous check of knowledge in the course of semester

Regular feedback on the progress of knowledge during the current term is provided by two semester projects and presentation. The course is completed by a written test.

E-learning

The Moodle Learning Management System (lms.vsb.cz) is used for external communication of the teacher with students outside the class-room, as well as for communication among the students themselves.

Other requirements

There are no additional requirements.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Word, principles of creating text documents, advanced techniques (working with sections, use of styles) 2. Word, working with tables, graphic editing, inserting and editing images, writing formulas in text 3. Word, advanced techniques (titles of tables and figures, footnotes, cross-references, generation of content, list of tables and figures) 4. Word, editing of documents processed by word processors - standard ČSN 01 6910 (2014) 5. Instructions for Bachelor's thesis writing – work organization, structure and range of thesis 6. Instructions for Bachelor's thesis writing – formal requirements 7. Excel, graph creation and modification – application to technical and production indicators of mining company 8. Excel, trend analysis of technical and production indicators of mining company 9. Excel, mining company financial analysis – horizontal and vertical analysis 10. Excel, mining company financial analysis – financial ratio calculation 11. Excel, investment project efficiency in mining company 12. Excel, financial investment in mining company 13. Excel, smoothing of time series of mining company stock prices

Conditions for subject completion

Part-time form (validity from: 2020/2021 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Graded credit Graded credit 100 (100) 51 3
        semestrální projekt Semestral project 15  8
        semestrální projekt Semestral project 10  6
        prezentace Other task type 5  3
        písemný test Written test 70  34
Mandatory attendence participation: Elaboration of semester project.

Show history

Conditions for subject completion and attendance at the exercises within ISP: 2 semester projects, 1 presentation, written test.

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2024/2025 (B0724A290003) Mineral Economics K Czech Most 3 Compulsory study plan
2024/2025 (B0724A290003) Mineral Economics P Czech Ostrava 3 Compulsory study plan
2024/2025 (B0724A290003) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2023/2024 (B0724A290003) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2023/2024 (B0724A290003) Mineral Economics K Czech Most 3 Compulsory study plan
2023/2024 (B0724A290003) Mineral Economics P Czech Ostrava 3 Compulsory study plan
2022/2023 (B0724A290003) Mineral Economics K Czech Most 3 Compulsory study plan
2022/2023 (B0724A290003) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2022/2023 (B0724A290003) Mineral Economics P Czech Ostrava 3 Compulsory study plan
2021/2022 (B0724A290003) Mineral Economics K Czech Most 3 Compulsory study plan
2021/2022 (B0724A290003) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2021/2022 (B0724A290003) Mineral Economics P Czech Ostrava 3 Compulsory study plan
2020/2021 (B0724A290003) Mineral Economics K Czech Most 3 Compulsory study plan
2020/2021 (B0724A290003) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2020/2021 (B0724A290003) Mineral Economics P Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2023/2024 Summer