OPF:INMBKNIE Informatics for Economists II - Course Information

INMBKNIE Informatics for Economists II

Extent and Intensity

12/0/0. 4 credit(s). Type of Completion: zk (examination).

Teacher(s)

Ing. Josef Botlík (lecturer)
Ing. Radim Dolák, Ph.D. (lecturer)
RNDr. Zdeněk Franěk, Ph.D. (lecturer)
Ing. Jan Górecki, Ph.D. (lecturer)
Mgr. Milena Janáková, Ph.D. (lecturer)
doc. Mgr. Petr Suchánek, Ph.D. (lecturer)

Guaranteed by

doc. Mgr. Petr Suchánek, Ph.D.
Department of Informatics and Mathematics – School of Business Administration in Karvina
Contact Person: Ing. Jan Górecki, Ph.D.

Timetable of Seminar Groups

INMBKNIE/01: Fri 13. 3. 8:05–9:40 B307, Fri 3. 4. 8:05–9:40 B307, Fri 15. 5. 8:05–9:40 B307, J. Botlík
INMBKNIE/02: Fri 13. 3. 9:45–11:20 B307, Fri 3. 4. 9:45–11:20 B307, Fri 15. 5. 9:45–11:20 B307, J. Botlík
INMBKNIE/03: Fri 13. 3. 9:45–11:20 B308, Fri 3. 4. 9:45–11:20 B308, Fri 15. 5. 9:45–11:20 B308, R. Dolák
INMBKNIE/04: Fri 13. 3. 9:45–11:20 B207, Fri 3. 4. 9:45–11:20 B207, Fri 15. 5. 9:45–11:20 B207, Z. Franěk
INMBKNIE/05: Fri 13. 3. 8:05–9:40 B208, Fri 3. 4. 8:05–9:40 B208, Fri 15. 5. 8:05–9:40 B208, M. Janáková
INMBKNIE/06: Fri 13. 3. 8:05–9:45 B207, Fri 3. 4. 8:05–9:45 B207, Fri 15. 5. 8:05–9:45 B207, R. Dolák

Prerequisites (in Czech)

FAKULTA(OPF) && TYP_STUDIA(B) && FORMA(K)

Course Enrolment Limitations

The course is only offered to the students of the study fields the course is directly associated with.

The capacity limit for the course is 204 student(s).
Current registration and enrolment status: enrolled: 0/204, only registered: 0/204

fields of study / plans the course is directly associated with

• European Integration (programme OPF, B_HOSPOL)
• Managerial Informatics (programme OPF, B_SYSINF)
• Business Economics and Management (programme OPF, B_EKOMAN, specialization Economy of Tourism)
• Business Economics and Management (programme OPF, B_EKOMAN, specialization Corporate Finance)
• Business Economics and Management (programme OPF, B_EKOMAN, specialization Hotel Management)
• Business Economics and Management (programme OPF, B_EKOMAN, specialization Marketing and Trade)
• Business Economics and Management (programme OPF, B_EKOMAN, specialization Business)
• Accounting and Taxes (programme OPF, B_EKOMAN)
• Public Economy and Administration (programme OPF, B_HOSPOL)
• Public Economy and Administration (programme OPF, B_VES)

Course objectives

The course is designed to acquaint students with working with data and information with main focus on input, selection, modification, analysis and output of data and information. Students will gain the ability to apply simple task of economic character using spreadsheet and database system.

Syllabus

• 1. Spreadsheet. Information about the structure and possibilities of using spreadsheets in corporate practice.
  2. Workbooks and sheets. Data file. Table and list. Identification of cells. Creation of formulas. Functions.
  3. Cell formatting. Tables formatting. Styles. Print output settings. Graphic objects in cells and sheets.
  4. Working with lists. Automatic and advanced filter. Subtotals. Pivot table.
  5. Charts. Types of charts. Sources of data and data series. Charts formatting. Export of charts. Trendline.
  6. Analysis tools. Goal Seek. What-If Analysis. Procedures for data analysis. Macro recording and editing.
  7. Practical tasks of usage of the spreadsheet program for solving typical examples of corporate practices.
  8. The characteristics of database programs and their usage. Database. The basics of creating databases. Relational Database. Modules of MS Access.
  9. Tables. Tables editting. Tables format. Sort records. Filters. Relations. Referential integrity.
  10. Queries. Simple Query Wirazd. Parameter Query. Find Query Wizard. Crosstab Query Wizard. Action Queries (Make Table, Append, Update, Delete).
  11. Forms and Reports. Form and Report Wizard. Form and Report Design.
  12. Macros. Basic activities while working with the macro. Macro creation. Macro editting.
  13. Practical tasks of use of the database program for solving model examples of corporate practices.
  

Literature

required literature
• BELKO, P. Microsoft Access 2013. Podrobná uživatelská příručka. Praha: Computer Press, 2014. ISBN 9788025141250. info
• PECINOVSKÝ, J. Excel 2013 podrobný průvodce. Praha: Grada, 2013. ISBN 9788024747293. info

recommended literature
• LAURENČÍK, M. Excel 2013 - práce s databázemi a kontingenčními tabulkami. Praha: Grada, 2014. ISBN 9788024750033. info
• PÍSEK, S. Access 2013. Praha: Grada, 2013. ISBN 9788024747460. info
• ŠIMEK, T. Office 2013 podrobný průvodce. Praha: Grada, 2013. ISBN 9788024747316. info

Language of instruction

Czech

Further comments (probably available only in Czech)

Study Materials
The course can also be completed outside the examination period.
Information on the extent and intensity of the course: Přednáška 12 HOD/SEM.

• Enrolment Statistics (Summer 2020, recent)
  
• Permalink: https://is.slu.cz/course/opf/summer2020/INMBKNIE