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

Gurantor departmentDepartment of Economics and Control SystemsCredits7
Subject guarantorRNDr. Radmila Sousedíková, Ph.D.Subject version guarantorRNDr. Radmila Sousedíková, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semesterwinter
Study languageCzech
Year of introduction1995/1996Year of cancellation2014/2015
Intended for the facultiesHGFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
CHL0006 Ing. Jakub Chlopecký, Ph.D.,MBA,LL.M.
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, spreadsheet 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: 2012/2013 Winter semester, validity until: 2014/2015 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of pointsMax. počet pokusů
Exercises evaluation and Examination Credit and Examination 100 (100) 51 3
        Exercises evaluation Credit 33 (33) 17 3
                Other task type Other task type 33  17 3
        Examination Examination 67 (67) 34 3
                Written examination Written examination 32  16 3
                Oral Oral examination 35  18 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
2014/2015 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 3 Compulsory study plan
2014/2015 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 3 Compulsory study plan
2013/2014 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 3 Compulsory study plan
2013/2014 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 3 Compulsory study plan
2012/2013 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 3 Compulsory study plan
2012/2013 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 3 Compulsory study plan
2011/2012 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 3 Compulsory study plan
2011/2012 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 3 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 3 Compulsory study plan
2010/2011 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 3 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials P Czech Ostrava 3 Compulsory study plan
2009/2010 (B2102) Mineral Raw Materials (2102R001) Economics and Management in the Field of Raw Materials K Czech Most 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2013/2014 Winter
2012/2013 Winter
2011/2012 Winter
2010/2011 Winter
2009/2010 Winter