Informatic Skills B
- Credits: 3
- Ending: Examination
- Range: 0P + 2C
- Semester: summer
- Year: 2
- Faculty of Economic Informatics
Teachers
Included in study programs
Teaching results
The development of ICT brings with it constant changes in its applications in practice and therefore students should acquire these competences:
A. To be oriented in the application of current information and communication technologies in practice with emphasis on the use of PC.
B. Acquire information literacy skills in solving specific economic assignments using knowledge of MS Excel in a clear format.
C. Interactive learning in solving specific economic assignments.
D. Promote constructive learning with a focus on the application of knowledge in practice.
E. Present and defend at a professional level the semester projects they have created.
Indicative content
1. Introduction to working with MS Excel spreadsheet . Working with sheets in a file - renaming, inserting and removing sheets in a workbook. Addressing and inserting data. Automatic filling and creating sequences and lists. Types of sequences. Creating custom lists. Saving and opening files.
2. Working with a table, input data validation options, data restriction types. Creating cell annotations. Methods of formatting cells. Formatting the sheet background. Options for creating and using styles.
3. Working with cell names and constants. Rules for creating formulas. Methods of inserting functions. Mathematical, logical and statistical functions.
4. Functions for date and time, text, information and search functions. Compound functions. Practical demonstration of the importance of anchoring rows and columns in a table.
5. Working with the database. Database structure, working with records through forms, sorting records - ascending, descending and by custom order. Filtering records. Types of filters. Types of selection criteria (conditions) when using an extended filter.
6. Matrix operations. Use of matrix formulas.
7. Graphical presentation of data. Creating graphs. Use of database functions.
8. Creating worksheet reports, use of report symbols. Merging data and creating summaries.
9. Creating scenarios, viewing scenarios, managing scenarios
10. Goal seek - looking backwards for solutions. What if analysis - sensitivity analysis.
11. Forms of data protection. Protection at cell, sheet, workbook and file level. Scenario Manager..
12. Problem analysis using the Solver. Creating and using a contingency table.
13. Interaction of MS Excel with other MS Office applications.
Support literature
NAVARRU, M.: Ms EXCEL 2019, GRADA, 2019, ISBN 9788024720265
LAURENČÍK, M.: Excel 2016 a 2019 - pokročilé nástroje, GRADA, 2019,
PYTHON, A.: Excel 2021, Martinus, 2021, ISBN 847231544Y
SCHMIDT, P.: IKT pre začínajúcich používateľov MS Word 2007, MS Excel 2007. Bratislava, 2013. 116 s. ISBN 978-80-971532-0-5.
Requirements to complete the course
Continuous problem solving during exercises 20%, for the exam 51% of this obligation is required
Final exam - elaboration and defense of the project 80% (passing the exam means getting at least 51% of the exam grade)
Student workload
Student workload (in hours): 78 h
Participation in seminars 26 h, preparation for seminars 13 h, project preparation 19 h, exam preparation 20 h
Date of approval: 10.02.2023
Date of the latest change: 22.05.2022