Informatics 9. Билингвальный учебник | страница 18

Finally, you should have a table showing quantity of books in total.

Pivot table by rows and columns

Теперь нам нужно показать количество книг разных жанров и разным рейтингом популярности. Добавьте три поля и выберите «Жанр» для «Строки», «Рейтинг популярности» для «Столбцы» и «Количество» для «Значений».

Finally, you will have a preview of the table shown below.

We can see that we have 3 books with “Classical” genre which popularity rate is 4 and 10 books which popularity rate is 5. Also, the biggest amount of books are in “Other” genre with the popularity rate of 5 that has 100 items in total.

If we want to show information about a particular item, but not a total quantity, we can use “COUNTA” method in Summarize by menu:

Keep in mind

By using “Edit range...” we can change ranges of a table. We must add new records to use this function within a pivot table.

Practice 1

Show information about how many books of different authors are stored in your database.

Practice 2

Now prepare different pivot tables according to the following criteria:

1. How many books from different authors with different genres are stored?

2. How many particular books do you have from different authors with different popularity rates?

Practice 3

1. Apply Filter to the books which “Quantity” is greater than 5.

2. Apply Filter to the books which “Popularity rate” is less than 5.

Literacy

1. In which situations can we use pivot table?

2. What is needed for making reports?

Terminology

pivot - жиынтық кесте - сводная таблица

to consider - қарастыру - рассматривать

record - жазба - запись

quantity - саны - количество

2.6 CHARTS

Youwill:

Apply charts forpresenting a database information.

What is the best way to present information?

Charts/Graphs

A chart, also called a graph, is a graphical representation of data. Charts have different formats such as bar chart, line chart and a pie chart.

Линейный график

Мы используем линейные графики для просмотра изменений в коротком или длительном периоде времени. Линейные графики являются лучшими при показе небольших изменений.

Круговая диаграмма

Мы используем круговые диаграммы для сравнения частей целого элемента.

Гистограмма.

Мы используем гистограммы, чтобы сравнивать вещи между различными группами и просматривать изменения по течению времени. Гистограммы лучше всего показывают большие изменения.

The best way for presenting your information is to prepare graphs. Previously we have made pivot tables which main purpose was to filter information. Now we are going to learn how to make graphs from pivot tables.