INMBANIE Informatics for Economists II

School of Business Administration in Karvina
Summer 2018
Extent and Intensity
1/2/0. 4 credit(s). Type of Completion: zk (examination).
Teacher(s)
doc. Mgr. Petr Suchánek, Ph.D. (lecturer)
Ing. Josef Botlík (seminar tutor)
RNDr. Zdeněk Franěk, Ph.D. (seminar tutor)
Ing. Jan Górecki, Ph.D. (seminar tutor)
Ing. Dalibor Hula (seminar tutor)
Mgr. Milena Janáková, Ph.D. (seminar tutor)
doc. RNDr. František Koliba, CSc. (seminar tutor)
doc. Mgr. Petr Suchánek, Ph.D. (seminar tutor)
Guaranteed by
doc. Mgr. Petr Suchánek, Ph.D.
Department of Informatics and Mathematics – School of Business Administration in Karvina
Contact Person: doc. Mgr. Petr Suchánek, Ph.D.
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 course is designed to acquaint students with working with data and information with main focus on input, selection, modification, analysis and output of data and information. Students will gain the ability to apply simple task of economic character using spreadsheet and database system.
Syllabus
  • 1. Spreadsheet. Information about the structure and possibilities of using spreadsheets in corporate practice.
    2. Workbooks and sheets. Data file. Table and list. Identification of cells. Creation of formulas. Functions.
    3. Cell formatting. Tables formatting. Styles. Print output settings. Graphic objects in cells and sheets.
    4. Working with lists. Automatic and advanced filter. Subtotals. Pivot table.
    5. Charts. Types of charts. Sources of data and data series. Charts formatting. Export of charts. Trendline.
    6. Analysis tools. Goal Seek. What-If Analysis. Procedures for data analysis. Macro recording and editing.
    7. Practical tasks of usage of the spreadsheet program for solving typical examples of corporate practices.
    8. The characteristics of database programs and their usage. Database. The basics of creating databases. Relational Database. Modules of MS Access.
    9. Tables. Tables editting. Tables format. Sort records. Filters. Relations. Referential integrity.
    10. Queries. Simple Query Wirazd. Parameter Query. Find Query Wizard. Crosstab Query Wizard. Action Queries (Make Table, Append, Update, Delete).
    11. Forms and Reports. Form and Report Wizard. Form and Report Design.
    12. Macros. Basic activities while working with the macro. Macro creation. Macro editting.
    13. Practical tasks of use of the database program for solving model examples of corporate practices.
Literature
    required literature
  • PRATT, P. J., LAST, M. Z. Microsoft Access 2013: Complete (Shelly Cashman Series). Course Technology, 2013. ISBN 978-1285169071. info
  • FREUND, S. M., JONES, M., STARKS, J. L. Microsoft Excel 2013: Complete (Shelly Cashman Series). Michigan: Cengage Learning, 2013. ISBN 978-1285168449. info
  • VERMAAT, M. E. Microsoft Office 2013: Introductory (Shelly Cashman). Boston: Cengage Learning, 2013. ISBN 978-1285166025. info
    recommended literature
  • FRAE, V. Microsoft Excel 2013 Step By Step. Microsoft Press, 2014. ISBN 978-0735681019. info
  • LAMBERT, J., COX., J. Microsoft Access 2013 Step by Step. Microsoft Press, 2013. ISBN 978-0735669086. info
Language of instruction
English
Further comments (probably available only in Czech)
The course can also be completed outside the examination period.
Teacher's information
Compulsory attendance at seminars 70 %. Final exam. Searching and processing resources on the Internet.
The course is also listed under the following terms Summer 2015, Summer 2016, Summer 2017, Summer 2019.
  • Enrolment Statistics (Summer 2018, recent)
  • Permalink: https://is.slu.cz/course/opf/summer2018/INMBANIE