| Course Unit Code | 545-0162/01 |
|---|
| Number of ECTS Credits Allocated | 3 ECTS credits |
|---|
| Type of Course Unit * | Compulsory |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Third Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| SVU008 | Ing. Jiří Švub, Ph.D. |
| 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. |
| Learning Outcomes of the Course Unit |
|---|
| 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. |
| Course Contents |
|---|
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 |
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
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. |
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 Reading: |
|---|
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. |
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. |
| Planned learning activities and teaching methods |
|---|
| Lectures, Tutorials |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Graded credit | Graded credit | 100 (100) | 51 |
| 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 |