INMBANIE Informatics for Economists II

School of Business Administration in Karvina
Summer 2015
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)
doc. Mgr. Petr Suchánek, Ph.D. (seminar tutor)
Guaranteed by
doc. RNDr. František Koliba, CSc.
Department of Informatics and Mathematics – School of Business Administration in Karvina
Contact Person: doc. Mgr. Petr Suchánek, Ph.D.
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
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
  • 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
    recommended literature
  • A lot of examples can be found by Google under the keywords, MS Office Textbooks. info
Teaching methods
Lecture with a video analysis
Skills demonstration
Seminar classes
Assessment methods
Grade
Language of instruction
English
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 2016, Summer 2017, Summer 2018, Summer 2019.
  • Enrolment Statistics (Summer 2015, recent)
  • Permalink: https://is.slu.cz/course/opf/summer2015/INMBANIE