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:

STAIR, Ralph M. and George Walter REYNOLDS. c2008. Fundamentals of information systems: a managerial approach. 4th ed. Boston: Thomson Course Technology. KUSLEIKA, Dick. Data visualization with Excel dashboards and reports. Indianapolis, Indiana: Wiley. ISBN 978-1-119-69872-2. BOYCE, Jim, PIERCE, John, ed. 2007 Microsoft Office system inside out [CD-ROM]. Redmond: Microsoft Press, c2007. ISBN 978-0-7356-2324-8. GRAY, Paul. Manager's guide to making decisions about information systems. Hoboken: Wiley. ISBN 0-471-26359-1.

Recommended literature:

CARLBERG, Conrad George. Business analysis with Microsoft Excel. Fifth edition. [Upper Saddle River]: Pearson Education. ISBN 978-0-7897-5958-0. ALEXANDER, Michael a Dick KUSLEIKA. Excel 2016 Power Programming with VBA. Indianapolis, IN: Wiley. Mr. Spreadsheet's bookshelf. ISBN 9781119415503. GOTTLIEB, Isaac. Next generation Excel: modeling in Excel for analysts and MBAs. Singapore: Wiley, 2010. ISBN 978-0-470-82473-3. ANDERSON, David Ray, Dennis J. SWEENEY a Thomas Arthur WILLIAMS. Modern business statistics with Microsoft Office Excel. 5th ed. Stamford: Cengage Learning. ISBN 978-1-305-08218-2.

Way of continuous check of knowledge in the course of semester

Active participation in seminars, processing of continuous tasks.

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.

Other requirements

Active participation in seminars, processing of continuous tasks.

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 pointsMax. počet pokusů
Graded credit Graded credit 100 (100) 51 3
        Laboratorní úkol 1 Laboratory work 25  13
        Laboratorní úkol 2 Laboratory work 25  13
        Laboratorní úkol 3 Laboratory work 25  13
        Laboratorní úkol 4 Laboratory work 25  13
Mandatory attendence participation: 80 % of seminars

Show history

Conditions for subject completion and attendance at the exercises within ISP: Consultations with the teacher about once a month, planned individually, presentation of the results of the work assigned at the consultations are expected. Preparation and defense of the semester work

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2024/2025 (B0724A290003) Mineral Economics K Czech Most 3 Compulsory study plan
2024/2025 (B0724A290003) Mineral Economics P Czech Ostrava 3 Compulsory study plan
2024/2025 (B0724A290003) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2023/2024 (B0724A290003) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2023/2024 (B0724A290003) Mineral Economics K Czech Most 3 Compulsory study plan
2023/2024 (B0724A290003) Mineral Economics P Czech Ostrava 3 Compulsory study plan
2022/2023 (B0724A290003) Mineral Economics K Czech Most 3 Compulsory study plan
2022/2023 (B0724A290003) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2022/2023 (B0724A290003) Mineral Economics P Czech Ostrava 3 Compulsory study plan
2021/2022 (B0724A290003) Mineral Economics K Czech Most 3 Compulsory study plan
2021/2022 (B0724A290003) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2021/2022 (B0724A290003) Mineral Economics P Czech Ostrava 3 Compulsory study plan
2020/2021 (B0724A290003) Mineral Economics K Czech Most 3 Compulsory study plan
2020/2021 (B0724A290003) Mineral Economics K Czech Ostrava 3 Compulsory study plan
2020/2021 (B0724A290003) Mineral Economics P Czech Ostrava 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction



2022/2023 Winter