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, Ph.D.
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
Part-time 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

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

Part-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 pointsMax. počet pokusů
Credit and Examination Credit and Examination 100 (100) 51
        Credit Credit 33  17
        Examination Examination 67  34 3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.Zaměření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

Assessment of instruction



2018/2019 Winter
2017/2018 Winter
2016/2017 Winter
2015/2016 Winter