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 (2023/9/21) - Registration of User Accounts
- zi-cv01-prezentace.pdf - Lesson 1 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 1 - Lesson 1 stuff
Lesson 2 (2023/10/5) - 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 (2023/10/12) - MS Excel - Fundamentals, Addressing
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 3 - Lesson 3 stuff
Lesson 4 (2023/10/19) - 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 (2023/10/26) - 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 (2023/11/2) - 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 (2023/11/9) - 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 (2023/11/16) - 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 (2023/11/23) - 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 (2023/11/30) - MS Excel - Rehearsing
- zi-cv10-prezentace.pdf - Lesson 10 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 10 - Lesson 10 stuff
Lesson 11 (2023/12/7) - 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 (2023/12/14) - MS Excel - Rehearshing
- zi-cv12-prezentace.pdf - Lesson 12 presentation
- https://portal.zcu.cz --> Courseware --> KIV/ZI --> Lesson 12 - Lesson 12 stuff
Lesson 13 (2023/12/19) - Early Bird Exam (for Cheb students)
- Early bird exam in the time of the lesson (starting at 13:55) - 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