INFBPNIE Informatics for Economists II

School of Business Administration in Karvina
Summer 2014
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
there are 11 fields of study the course is directly associated with, display
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
ActivityDifficulty [h]
Ostatní studijní zátěž40
Přednáška13
Seminář26
Zkouška40
Summary119
The course is also listed under the following terms Summer 2013, Summer 2015.
  • Enrolment Statistics (Summer 2014, recent)
  • Permalink: https://is.slu.cz/course/opf/summer2014/INFBPNIE