INMBAINF Informatics

Obchodně podnikatelská fakulta v Karviné
zima 2025
Rozsah
1/2/0. 6 kr. Ukončení: zk.
Vyučující
Ing. Radim Dolák, Ph.D. (přednášející)
Garance
doc. Mgr. Petr Suchánek, Ph.D.
Katedra informatiky a matematiky – Obchodně podnikatelská fakulta v Karviné
Kontaktní osoba: doc. Ing. Jan Górecki, Ph.D.
Rozvrh
Út 14:45–15:30 A216
  • Rozvrh seminárních/paralelních skupin:
INMBAINF/01: Út 15:35–17:10 A216, R. Dolák
Omezení zápisu do předmětu
Předmět je určen pouze studentům mateřských oborů.

Předmět si smí zapsat nejvýše 10 stud.
Momentální stav registrace a zápisu: zapsáno: 6/10, pouze zareg.: 2/10
Mateřské obory/plány
Cíle předmětu
The aim of the course is to teach students the basics of working with the Microsoft Office suite (MS Word, MS Excel, MS Access, and MS PowerPoint).
Výstupy z učení
Students are able to create text documents in Microsoft Word with using text formatting, paragraphs, styles and creating of content. Students are able to work with tables, images and charts in MS Word. Students are able to create spreadsheets in Microsoft Excel with using relative and absolute cell references, creating table with data, using styles for table, filtering data, working with charts, using formulas and functions, using grouping and subtotals, creating a pivot table and a pivot chart. Students are able to create databases in Microsoft Access with using right database structure, data import, query design, form design and report design. Students are able to create presentations in Microsoft Power Point.
Osnova

1. Informatics in Business Practice

Informatics as a field of science. Hardware. Software. Data. Information. Knowledge. Information and communication technology. Information system. Informatics as a management support. 

2. Operating Systems

Operating system services. Operating system architecture. Operating system Windows. System hardware requirements. Start menu. Start screen configuration. Taskbar. Toolbars. Applications.

3. Text Editors

Text editors. Text formatting. Character. Paragraphs. Styles. Numbering. Sections. Editing and proofreading tools. Preparing printouts. Tables. Graphic objects. References. Inter-application communication. 

4. Spreadsheet Calculator

Data file. Data sources. Cells. Table and list. Formulas and functions. Charts. Filters. Subtotals. Pivot table. Sensitivity analysis. Solving specific economic tasks. 

5. Creation of Presentations

Business presentation. Main principles of creating presentations. Templates. Slides. Objects. Animations. Timing. Effects. Import and export slides.

6. Database Management System

Database structure. Data import. Relational database. Query wizard. Query design. Form wizard. Form design. Report wizard. Report design. Case studies of creating specific databases.

Literatura
    povinná literatura
  • Holler, J. (2025). The Microsoft Office 365 bible: The most updated and complete guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access and Publisher from beginners to advanced. James Holler Teaching Group.
Výukové metody
lectures, seminars, independent work on assigned practical tasks in Microsoft Office Suite
Metody hodnocení

Student requirements: minimum 70% attendance at seminars, preparation and presentation of seminar paper in the form of a PowerPoint presentation, independent completion of practical tasks (Word, Excel, Access).  

Assessment methods: independent completion of practical tasks in Word, Excel, and Access (30% of assessment), preparation and presentation of seminar paper (30% of assessment), final exam (40% of assessment).

Vyučovací jazyk
Angličtina
Další komentáře
Studijní materiály
Předmět je zařazen také v obdobích zima 2021, zima 2022, zima 2023, zima 2024.
  • Statistika zápisu (nejnovější)
  • Permalink: https://is.slu.cz/predmet/opf/zima2025/INMBAINF