OPF:INFBANIE Informatics for Economists II - Course Information

INFBANIE 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)
• Business Economics in Trade and Services (programme OPF, B_EKOMAN)
• Managerial Informatics (programme OPF, B_SYSINF)

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

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

• Enrolment Statistics (recent)
  
• Permalink: https://is.slu.cz/course/opf/summer2014/INFBANIE