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 studying in Cheb only).

Lesson 1 (2018/9/27) - Registration of User Accounts

Lesson 2 (2018/10/4) - Getting Familiar with UWB Web Services

Lesson 3 (2018/10/11) - MS Excel - Fundamentals, Addressing

Lesson 4 (2018/10/18) - MS Excel - Basic Operations with Table, Functions, Formulas

Lesson 5 (2018/10/25) - Creating of Charts and Handling of Strings

Lesson 6 (2018/11/1) - MS Excel - Filters and Sorting

Lesson 7 (2018/11/8) - MS Excel - Matrix Formulas and Subtotal

Lesson 8 (2018/11/15) - MS Excel - Logical Function and Exercise

Lesson 9 (2018/11/22) - MS Excel - Pivot Tables

Lesson 10 (2018/11/29) - MS Excel - Rehearsing before the Test

Lesson 11 (2018/12/6) - MS Excel - Cooperation between Applications, MS Word

Lesson 12 (2018/12/13) - MS Excel - Rehearshing

Lesson 13 (2018/12/20) - Early Bird Exam

  • 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
  • zkouska-zi-teoreticke-okruhy.pdf - Theoretical domains for the exam of the KIV/ZI subject