|
Lecturer(s)
|
-
Perůtka Karel, Ing. Ph.D.
|
|
Course content
|
- Understanding the working environment. Working with an existing workbook. Navigation workbook. Setting cells. Properties workbook. - Save the workbook. Creating a new workbook. Inserting data into a workbook. Cells, columns, rows (Inserting, deleting, partitioning, formatting styles and formatting cells, conditional formatting). - Searching and replacing data. Working with data. Restrictions on entering data, sorting data. Data filtering, filter settings. - Working with formulas (addition, subtraction, multiplication, division). Linking to cells in samples (absolute, relative). Creating named ranges and constants. - Basic functions (sum, count, enumerate, average, minimum, maximum). - Advanced functions (conditional functions, logic functions, statistical functions). - Presentation of data (graphs and their types, suitability of data, properties of graphs). - Advanced data processing. - Introduction to email and planning tool. Working environment applications. - Basic processing emails (receipt, viewing, editing, reply, forward, attributes). - Working with attachments delivered. Creating a signature. Personalization of messages. Types of reports. Inline attachments. Automatic report. - Encryption and digital signature in electronic mail. News organizations (use of components and their maintenance). - Rules for sending and receiving mail (meaning and configuration). Working with contacts (adding, editing, business cards). - Distribution list (meaning creation). Calendar (planning, event management, event types, sharing). Management tasks (creation, sorting, allocation).
|
|
Learning activities and teaching methods
|
Monologic (Exposition, lecture, briefing), Demonstration, Exercises on PC
- Home preparation for classes
- 28 hours per semester
- Participation in classes
- 46 hours per semester
- Preparation for course credit
- 10 hours per semester
- Term paper
- 10 hours per semester
|
| learning outcomes |
|---|
| Knowledge |
|---|
| The student has knowledge about the office software. The student is able to create a tables and data. The student takes advantage of spreadsheets. The student knows how to a spredsheet editor. The student knows how to analyse a set of requirements of a spreadsheet document. The student is well informed about a spreadsheet building methodolodgy. |
| Student/ka umí vyjmenovat jednotlivé funkce pro výpočet vzorců |
| Student/ka umí vyjmenovat jednotlivé funkce pro výpočet vzorců |
| The student has knowledge about the office software. The student is able to create a tables and data. The student takes advantage of spreadsheets. The student knows how to a spredsheet editor. The student knows how to analyse a set of requirements of a spreadsheet document. The student is well informed about a spreadsheet building methodolodgy. |
| Student/ka umí analyzovat zadaný úkol pro realizaci v MS Excel |
| Student/ka umí analyzovat zadaný úkol pro realizaci v MS Excel |
| Student/ka umí definovat model a ten následně implementovat v MS Excel |
| Student/ka umí definovat model a ten následně implementovat v MS Excel |
| Student/ka umí popsat vlastnosti tabulek a grafů |
| Student/ka umí popsat vlastnosti tabulek a grafů |
| Student/ka umí vysvětlit způsob práce v programu MS Excel. |
| Student/ka umí vysvětlit způsob práce v programu MS Excel. |
| Skills |
|---|
| The student can design the structure of the task solution |
| The student can design the structure of the task solution |
| The student can create a table and a graph |
| The student can create a table and a graph |
| The student can implement an independent task in MS Excel software |
| The student can implement an independent task in MS Excel software |
| The student can solve tasks from the field of technical calculations in MS Excel |
| The student can solve tasks from the field of technical calculations in MS Excel |
| The student can improve results using the chosen method in MS Excel. |
| The student can improve results using the chosen method in MS Excel. |
| teaching methods |
|---|
| Knowledge |
|---|
| Exercises on PC |
| Demonstration |
| Demonstration |
| Monologic (Exposition, lecture, briefing) |
| Exercises on PC |
| Monologic (Exposition, lecture, briefing) |
| assessment methods |
|---|
| Preparation of a presentation |
| Analysis of seminar paper |
| Analysis of seminar paper |
| Preparation of a presentation |
| Essay |
| Essay |
|
Recommended literature
|
-
Josef Pecinovský, Rudolf Pecinovský. Office 2019 - Průvodce uživatele. 2019. ISBN 978-80-247-2303-7.
-
Marek Laurenčík. Excel 2016 a 2019 pokročilé nástroje - Funkce, databáze, kontingenční tabulky, prezentace, příklady. 2019. ISBN 978-80-271-2471-8.
-
Miroslav Navarrů. Excel 2019 - Podrobný průvodce uživatele. 2019. ISBN 978-80-247-2026-5.
-
Schels, Ignatz. Excel 2007 : vzorce a funkce. 1. vyd. Praha : Grada, 2008. ISBN 978-80-247-2074-6.
|