Prehľad témy

  • Všeobecné

    Zbaliť všetko Rozbaliť všetko

    Managerial Informatics 

    E15-0058-B          
              


    Course description:

    Course content is build on the knowledge from the subject Informatics and it is aimed at working with word processor (MS WORD), spreadsheets (MS EXCEL), database (MS ACCESS), and presentation software (MS POWERPOINT) and use them to solve practical problems of managers and economists.

    Subject objectives:
    The subject aims to apply theoretical knowledge and practical skills from work with MS Office applications. The student will be able to work actively with the text, tables, charts, and data in the database system and create presentations. The gained knowledge will be able to be used in other subjects, in the preparation of semestral projects, individual assignments, the bachelor thesis, and eventually the diploma thesis. At the same time, the student will become familiar with other topics related to the work of a manager, such as project management and the MS Project application, working with websites, working with large amounts of data (Big Data), programming, cyber security, artificial intelligence, and information systems. Students get a basic overview of each topic and have the opportunity to choose subjects that follow these topics.

    Supervisor: 
    doc. Ing. Klára Hennyeyová, CSc.

    Lecturers: 

    doc. Ing. Marcela Hallová, PhD.     marcela.hallova@uniag.sk


     

  • Lectures

  • Topic 1

    MS Word - the selection of word processing problems

    What you will learn in this lesson:

    • work on the file, make the basic file settings, 
    • work with different tools for formatting text, paragraphs, styles,
    • insert and modify various objects,
    • work with tools such as table of contents, footnotes, bibliographic references, table and picture titles and registers,
    • using mail merge tools.

    Key words: text editor, typography, font editing, paragraph editing, inserting and formatting of pictures and objects, inserting of formulas...

  • Topic 2

    MS Excel - selection of issues of data processing in the form of tables and graphs

    What you will learn in this lesson:
    • work with different sequences,
    • create and edit formulas, 
    • use functions (logical, date, time, mathematical, statistical)
    • edit and search data by using conditional formatting,
    • use some advance tools in graphs,
    • create pivot tables and graphs.

    Key words: table, cell address - relative, absolute, mixed, formulas, functions, graph, database...

  • Topic 3

    Presentations in MS PowerPoint

    What you will learn in this lesson:

    • create presentations and edit it,
    • insert object to presentations,
    • modify the presentation with transition effects and animations,
    • check the presentaton,
    • save and print presentation,
    • principles of good presentation and creation of presentations.

    Key words: presentation, inserted objects, effects...

  • Tematika 6

    MS Access - creating and editing database
    What you will learn in this lesson:
    • understanding the database, how it is organized and how to work with database,
    • create simple database and basic methods of working with database,
    • create table, define the fields and its properties, insert and edit records in tables,
    • sorting and filtering of table,
    • create forms, queries and reports,
    • simple editing of forms, queries and reports.

     

    Key words: database, database object, record, field, table.