Practical Lessons Stuff
Here, you can find links to the stuff for the practical lessons (excercises and solutions) and potential presentations from lessons (for students on lessons of Tomáš Potužák only).
Lesson 1 (2025/9/15 and 25) - Registration of User Accounts
- Due to the teacher's business trip, the first seminar on Thursday 2025/9/18 in Cheb will not take place. Information about the subject will be provided on the second lesson (on Thursday 2025/9/25). User account registration can be done individually using the instructions provided with the JIS card.
- zi-cv01-prezentace.pdf - Lesson 1 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 1 - Lesson 1 stuff
Lesson 2 (2025/9/22 and 25) - Getting Familiar with UWB Web Services
- zi-cv02-prezentace.pdf - Lesson 2 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 2 - Lesson 2 stuff
Lesson 3 (2025/9/29 and 2025/10/2) - MS Excel - Fundamentals, Addressing
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 3 - Lesson 3 stuff
Lesson 4 (2025/10/6 and 2025/10/9) - MS Excel - Basic Operations with Table, Functions, Formulas
- zi-cv04-prezentace.pdf - Lesson 4 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 4 - Lesson 4 stuff
Lesson 5 (2025/10/13 and 16) - Creating of Charts and Handling of Strings
- zi-cv05-prezentace.pdf - Lesson 5 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 5 - Lesson 5 stuff
Lesson 6 (2025/10/20 and 23) - MS Excel - Filters and Sorting
- zi-cv06-prezentace.pdf - Lesson 6 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 6 - Lesson 6 stuff
Lesson 7 (2025/10/27 and 30) - MS Excel - Matrix Formulas and Subtotal
- zi-cv07-prezentace.pdf - Lesson 7 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 7 - Lesson 7 stuff
Lesson 8 (2025/11/3 and 6) - MS Excel - Logical Functions and Exercise
- zi-cv08-prezentace.pdf - Lesson 8 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 8 - Lesson 8 stuff
Lesson 9 (2025/11/10 and 13) - MS Excel - Pivot Tables
- zi-cv09-prezentace.pdf - Lesson 9 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 9 - Lesson 9 stuff
Lesson 10 (2025/11/24 and 20) - MS Excel - Rehearsing
- zi-cv10-prezentace.pdf - Lesson 10 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 10 - Lesson 10 stuff
Lesson 11 (2025/12/1 and 2025/11/27) - MS Excel - Data Import and Export
- zi-cv11-prezentace.pdf - Lesson 11 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 11 - Lesson 11 stuff
Lesson 12 (2025/12/8 and 4) - MS Excel - Rehearshing
- zi-cv12-prezentace.pdf - Lesson 12 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 12 - Lesson 12 stuff
Lesson 13 (2025/12/15 and 11) - Consultation Lesson (for Pilsen students) / Early Bird Exam (for Cheb students)
- Consultation lesson - for students studying in Pilsen
- Early bird exam in the time of the lesson (starting at 13:55) - For students studying in Cheb. Students have to register at portal in order to be able to attend the exam
- zi-zk-teoreticke_okruhy.pdf - Theoretical domains for the exam of the KIV/ZI subject