TASK LIST FOR MS WORD - 10 points until 31.10.2024.

Plain text document at least 5 pages about city, country, sport, music etc.

[1] working with styles
[2] creating the content of document
[3] headers and footers for example adding page numbering
[4] proofreading tools for example adding some comments into document
[5] working with tables / add caption for it
[6] working with images / add caption for it
[7] working with charts / add caption for it
[8] creating tables of contenst for tables, images and charts
[9] working with SmartArt for example hierarchy structure
[10] creating final pdf file

TASK LIST FOR MS EXCEL - 10 points until 21.11.2024.

Prepare dataset in MS EXCEL with at least 30 rows and 4 columns. You can download datasets from internet for example some statistics from the following webistes statista.com, https://www.czso.cz/csu/czso/home or you can prepare your own data.

Example of dataset - movies
https://en.wikipedia.org/wiki/2020s_in_film
https://en.wikipedia.org/wiki/List_of_animated_feature_films_of_the_2020s

https://office-watch.com/2022/get-movie-info-easily-into-microsoft-excel/

Example of dataset - songs
https://cs.uwaterloo.ca/~dtompkin/music/list/Best9.html

[1] working with relative and absolute cell references
[2] creating table with data
[3] using styles for table
[4] filtering data – autofiltering
[5] filtering data – advanced filter
[6] working with charts / add names
[7] using some formulas and functions
[8] using grouping and subtotals
[9] creating a pivot table
[10] creating a pivot chart

TASK LIST FOR MS ACCESS - 10 points until 19.12.2024.

Prepare database in MS ACCESS

[1] create table (manual)
[2] create table (import data from excel)
[3] format text in one table (bold, size 12)
[4] create select query number 1
[5] create select query number 2
[6] use some sorting in both previous queries
[7] create form
[8] add some image to the form
[9] create report
[10] add some image to the form