OPF:INFBPNIE Informatics for Economists II - Course Information
INFBPNIE Informatics for Economists II
School of Business Administration in KarvinaSummer 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.
- 1. Spreadsheets - the first steps.
- 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