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 (2017/9/21) - Registration of User Accounts

Lesson 2 (2017/10/5) - Getting Familiar with UWB Web Services

Lesson 3 (2017/10/12) - MS Excel - Fundamentals, Addressing

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

Lesson 5 (2017/10/26) - Creating of Charts and Handling of Strings

Lesson 6 (2017/11/2) - MS Excel - Filters and Sorting

Lesson 7 (2017/11/9) - MS Excel - Matrix Formulas and Subtotal

Lesson 8 (2017/11/16) - MS Excel - Logical Function and Exercise

Lesson 9 (2017/11/30) - MS Excel - Pivot Tables

Lesson 10 (2017/11/23) - MS Excel - Rehearsing before the Test

Lesson 11 (2017/12/7) - MS Excel - Cooperation between Applications, MS Word

Lesson 12 (2017/12/7) - MS Excel - Rehearshing

Lesson 13 (2017/12/14) - 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