545-0162/01 – Computing Applications I (AVTI)

Gurantor departmentDepartment of Economics and Control SystemsCredits3
Subject guarantorIng. Jiří Švub, Ph.D.Subject version guarantorIng. Jiří Švub, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semesterwinter
Study languageCzech
Year of introduction2019/2020Year of cancellation
Intended for the facultiesHGFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
SVU008 Ing. Jiří Švub, 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

In this course students will acquire advanced knowledge in computing and use of computers in management processes and economics. The course explains today's possibilities of SW tools for document preparation, simple analysis and presentation of data, project planning or creation of diagrams, drawings and plans. Students will verify acquired skills in practice during lessons.

Teaching methods

Lectures
Tutorials

Summary

In this course students will acquire advanced knowledge in computing and use of computers in management processes and economics. The course explains today's possibilities of SW tools for document preparation, simple analysis and presentation of data, project planning or creation of diagrams, drawings and plans. Students will verify acquired skills in practice during lessons.

Compulsory literature:

ROSMAN, P. BUŘITA, L. Informatika pro ekonomy a manažery. Skriptum UTB. Zlín: UTB ve Zlíně, 2012, 188 s. 4.upravené a dopl. vydání. ISBN 978-80-7454-228-2. BROŽ, Milan. Microsoft Excel pro manažery a ekonomy. 4. aktualiz. vyd.. Brno : Computer Press, 2006. 430 s. : il. + 1 CD-ROM ISBN 80-251-1307-8 BOYCE, Jim, PIERCE, John, ed. 2007 Microsoft Office system inside out [CD-ROM]. Redmond: Microsoft Press, c2007. ISBN 978-0-7356-2324-8. Elektronické studijní opory předmětu: Aplikace VT pro manažery I

Recommended literature:

MEYER, M. Osobní počítač. Názorný průvodce hardwarem, systémem a sítěmi. Brno: Computer Press 2005. ISBN 80-251-0834-1 HYNDRÁK, K. Microsoft office project, hotová řešení. Brno: Computer press, 2007, 308 s. + 1 CD-ROM. ISBN 978-80-251-1681-4. LAURENČÍK, Marek. Excel 2016: práce s databázemi a kontingenčními tabulkami. Praha: Grada, 2017. ISBN 978-80-271-0477-2. GOTTLIEB, Isaac. Next generation Excel: modeling in Excel for analysts and MBAs. Singapore: Wiley, 2010. ISBN 978-0-470-82473-3.

Way of continuous check of knowledge in the course of semester

Progress tests, final test

E-learning

The Moodle Learning Management System (lms.vsb.cz) is used to communicate beyond the scope of attendance at the conference, through which communication is made not only between the teacher and students, but also between the students.

Další požadavky na studenta

Active participation in seminars, elaboration of a project.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. MS Word - styles, equations 2. MS Word - forms, bulk correspondence 3. MS Excel - formulas, formatting 4. MS Excel - work with large data 5. MS Excel - creation of macros, custom functions 6. Personal Time Management Tools 7. MS Project - projects, calendars, tasks 8. MS Project - resources, costs 9. MS Project - progress monitoring 10. MS Project - views, reports 11. MS Visio - flowcharts 12. MS Visio - diagrams, organizational diagrams 13. MS Visio - workflow diagrams 14. MS Visio - plans

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: Active participation in seminars, elaboration of assigned task.

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