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
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:

MELTON, Beth et al. Microsoft Office Professional 2013: Step by Step. Sebastopol, Calif.: O'Reilly Media, 2013. xxix, 1184 p. ISBN 9780735669413.

Recommended literature:

MURRAY, Katherine. Microsoft Office Professional 2013. Sebastopol, Calif.: O'Reilly Media, 2013. 472 p. 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, presentation and written/oral exam.

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.

Další požadavky na studenta

There are no additional requirements.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Word, formatting of documents realized by utilizing text processor – punctuations, hyphen, abbreviations 2. Word, formatting of documents realized by utilizing text processor – symbols and characters, numbers and numerals 3. Word, formatting of documents realized by utilizing text processor – text marking and sectioning 4. Word, formatting of documents realized by utilizing text processor – document formatting 5. Word, formatting of documents realized by utilizing text processor – tables 6. Instructions for Bachelor's thesis writing – work organization, structure and range of thesis 7. Instructions for Bachelor's thesis writing – formal requirements 8. Excel, graph creation and modification – application to technical and production indicators of mining company 9. Excel, trend analysis of technical and production indicators of mining company 10. Excel, mining company financial analysis – horizontal and vertical analysis 11. Excel, mining company financial analysis – financial ratio calculation 12. Excel, investment project efficiency in mining company 13. Excel, financial investment in mining company 14. Excel, smoothing of time series of mining company stock prices

Conditions for subject completion

Full-time form (validity from: 2020/2021 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Graded credit Graded credit 100  51
Mandatory attendence parzicipation: Attendance at lectures is optional, attendance at seminars is 80%.

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2020/2021 (B2735XXX0001) Mineral Economics K Czech Most 3 Compulsory study plan
2020/2021 (B2735XXX0001) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2020/2021 (B2735XXX0001) Mineral Economics P Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner