OPF:INFBPNIE Informatics for Economists II - Course Information

INFBPNIE Informatics for Economists II

Extent and Intensity

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

Teacher(s)

doc. RNDr. František Koliba, CSc. (lecturer)
Ing. Josef Botlík (seminar tutor)
Ing. Jan Górecki, Ph.D. (seminar tutor)
Ing. Dalibor Hula (seminar tutor)
Mgr. Milena Janáková, Ph.D. (seminar tutor)
Ing. Kateřina Slaninová, Ph.D. (seminar tutor)
Ing. Marek Spišák (seminar tutor)
doc. Mgr. Petr Suchánek, Ph.D. (seminar tutor)
RNDr. Jindřich Vaněk, Ph.D. (seminar tutor)

Guaranteed by

doc. RNDr. František Koliba, CSc.
Department of Informatics and Mathematics – School of Business Administration in Karvina

Prerequisites

None

Course Enrolment Limitations

The course is also offered to the students of the fields other than those the course is directly associated with.

fields of study / plans the course is directly associated with

• Banking (programme OPF, B_HOSPOL)
• Economy of Tourism (programme OPF, B_EKOMAN)
• Business Economics in Trade and Services (programme OPF, B_EKOMAN)
• European Integration (programme OPF, B_HOSPOL)
• Finanční management (programme OPF, B_EKOMAN)
• Managerial Informatics (programme OPF, B_SYSINF)
• Marketing and Management (programme OPF, B_EKOMAN)
• Logistics Management (programme OPF, B_EKOMAN)
• Social Management (programme OPF, B_HOSPOL)
• Accounting and Taxes (programme OPF, B_EKOMAN)
• Public Economy and Administration (programme OPF, B_HOSPOL)

Course objectives

The aim of the course is to deepen the knowledge of information usage, to excersise the methods of information inputs, selection outputs and modifications. Further, to apply spreadsheet and database tools for simple economic tasks and data integration.

Syllabus

• 1. Spreadsheets - the first steps.
  2. Basic operations.
  3. Sheet editing, print.
  4. Graphs.
  5. Extended operations.
  6. Drawing and files administration.
  7. Lists.
  8. Analytic tools.
  9. Database system MS Access - first steps.
  10. Database structure.
  11. Queries.
  12. Forms, reports.
  13. Macros.
  

Literature

required literature
• PÍSEK, S. Access 2007. Praha: Grada. ISBN 978-80-247-1966-5. info
• Manzo, J., M. How to Use Microsoft? Excel?: The Careers in Practice Series, v. 1.0. Flatworld Knowledge, 2012. ISBN 978-1-4533-3021-0. info
• Shelly, G., B., Vermaat, M. Microsoft Office 2010: Introductory. Boston: Course technology, 2010. ISBN 978-1439078389. info
• BŘÍZA, V. Excel 2007. Praha: Computer Press, 2007. ISBN 978-80-247-1964-1. info

recommended literature
• A lot of examples can be found by Google under the keywords, MS Office Textbooks. info
• PÍSEK, S. Access 2003, podrobný průvodce začínajícího uživatele. Praha: Grada. ISBN 80-247-0788-8. info
• PÍSEK, S. Access 2007. Praha: Grada. ISBN 978-80-247-1966-5. info
• PÍSEK, S. Access 2007 - podrobný průvodce. Praha: Grada. ISBN 978-80-247-1967-2. info
• Časopisy a web. URL info
• PECINOVSKÝ J. Excel 2002, podrobný průvodce začínajícího uživatele. Praha: Grada. ISBN 80-247-0150-2. info
• BŘÍZA, V. Excel 2007. Praha: Grada. ISBN 978-80-247-1964-1. info
• BŘÍZA, V. Excel 2007 (podrobný průvodce). EDUCA s.r.o. ISBN 978-80-247-1965-8. info
• VIESCAS, J., CONRAD, J. Mistrovství v Microsoft Office Access 2007. Praha: Computer Press. ISBN 978-80-251-2162-7. info
• DODGE, M., STINSON, C. Mistrovství v Microsoft Office Excel 2007. Praha: Computer Press. ISBN 978-80-251-1980-8. info
• BROŽ, M. Microsoft Office Excel 2007. Praha: Computer Press, 2007. ISBN 978-80-251-1822-1. info
• FIKÁČEK, I., FIKÁČEK, M., ROZEHNAL, I. Access 2000 - podrobný průvodce začínajícího uživatele. Praha: GRADA, 2000. ISBN 80-7169-879-2. info
• PECINOVSKÝ, J. 2000 - PODROBNÝ PRŮVODCE ZAČÍNAJÍCÍHO UŽIVATELE. Praha:GRADA, 2000. ISBN 80-7169-872-5. info
• HALODOVÁ, R. Microsoft Excel 97: snadno a rychle. Praha: Grada, 1999. ISBN 80-7169-265-4. info
• MORKES, D. Microsoft Access 97 cz: uživatelská příručka. Praha: Computer Press, 1998. ISBN 80-7226-053-7. info
• FIKÁČEK, I., ROZEHNAL, I., FIKÁČEK, M. Microsoft Access 97: snadno a rychle. Praha: Grada, 1998. ISBN 80-7169-529-7. info
• BROŽ, M., BROŽOVÁ, P. Microsoft Excel 97: podrobná příručka uživatele. Praha: Computer Press, 1997. ISBN 80-7226-008-1. info

Teaching methods

Lecture with a video analysis
Skills demonstration
Seminar classes

Assessment methods

Grade

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.

Teacher's information

attendance in seminars 70%, combined exam

Activity	Difficulty [h]
Ostatní studijní zátěž	40
Přednáška	13
Seminář	26
Zkouška	40
Summary	119

• Enrolment Statistics (Summer 2014, recent)
  
• Permalink: https://is.slu.cz/course/opf/summer2014/INFBPNIE