Skip to main content
Skip header

Computing Applications I

Type of study Bachelor
Language of instruction English
Code 545-0162/02
Abbreviation AVTI
Course title Computing Applications I
Credits 3
Coordinating department Department of Economics and Control Systems
Course coordinator Ing. Jiří Švub, Ph.D.

Osnova předmětu

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, pláns

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.

Povinná literatura

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.

Doporučená literatura

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.