545-0291/06 – Information Technology Application in Economic Practice I. (AVT I)

Gurantor departmentDepartment of Economics and Control SystemsCredits8
Subject guarantorRNDr. Radmila Sousedíková, Ph.D.Subject version guarantorRNDr. Radmila Sousedíková, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semesterwinter
Study languageCzech
Year of introduction2015/2016Year of cancellation2018/2019
Intended for the facultiesHGFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
HUB0006 Ing. Jaroslav Hubáček
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 Credit and Examination 2+4
Combined Credit and Examination 6+12

Subject aims expressed by acquired skills and competences

Generating knowledge concerning modern working processes in Microsoft Office, application to written outputs of research, simple economic analysis with spread sheet and and results presentation with PowerPoint.

Teaching methods

Lectures
Tutorials

Summary

The subject concerns modern working processes in Microsoft Office and their application to written outputs of research, presentation and economic analysis with spreadsheet.

Compulsory literature:

BUCKI, Lisa et al. Learning Microsoft Office 2010. Upper Saddle River, N.J.: Pearson/Prentice Hall, 2011. ISBN 978-0135108383

Recommended literature:

SHELLY Gary and Misty VERMAAT. Microsoft Office 2010: Introductory. Andover: Cengage Learning, 2010.ISBN 9781439078389.

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.

E-learning

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, principles of text document writing, advanced methods (working with sections and styles) 2) Word, working with tables, graphical modification, figure inserting and modification, equations writing 3) Word, advanced methods (captions of tables and figures, footnotes, cross-reference captions, creating a table of content and figures) 4) Word, mail merge, use of database record 5) Instructions for Bachelor's thesis writing, bibliographic citation 6) Excel, advanced methods, spread sheet use in economic practice (graph creation and modification , trend analysis 7) Excel, working with databases (creating tables, filters, creating subtotals and totals) 8) Financial analysis with Excel 9) Investment project efficiency with Excel 10) Debt amortization with Excel 11) Smoothing of stock prices time series with excel 12) Presentation with PowerPoint 13) Web page creating

Conditions for subject completion

Full-time form (validity from: 2015/2016 Winter semester, validity until: 2018/2019 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 33  17
        Examination Examination 67 (67) 34
                Písemná zkouška Written examination 67  34
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2018/2019 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 3 Compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Ostrava 3 Compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 3 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 3 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Ostrava 3 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 3 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 3 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Ostrava 3 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 3 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 3 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Ostrava 3 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner