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

The table in Figure 5 shows how many books are in our database without showing total amount of books.

To insert a chart choose “Insert” » “Chart” option. You can change “Chart type” to “Pie chart“ from “Setup” menu in “Chart editor”.

Activity

Analyze the charts below and discuss with your classmates the information that they give.

Practice

Apply charts for different pivot tables from the previous lesson.

Literacy

1. How to make charts in Google Sheets?

2. Discuss for which databases each chart type can be applied?

Terminology

representation - көрсету - представление

chart - диаграмма - диаграмма

purpose - мақсаты - цель

insert - кірістіру - вставить

recommendation - ұсыныс - рекомендация

2.7 MINI PROJECT: FAMILY SHOP

You will:

Create a database that will help to count goods in a shop;

Get information about Database types.

Would you like to help your family to arrange goods in your family shop?

Familyshopdatabase

В этом уроке мы будем разрабатывать небольшую базу данных, которая поможет нам подсчитать товар в магазине. Сначала сделаем форму для ввода данных в нашу базу данных.

Создайте форму с названием: «Our shop». Add 5 fields with the following types:

1. Name of the product - Short answer;

2. Category of product - Dropdown (at least 4 categories);

3. Quantity - Short answer;

4. Price - Short answer;

5. Expire date - Date.

Practice 1

Заполните форму как минимум с 5 записями.

Practice 2

1. Now start working with the database table. Apply “sorting” of all goods according to ‘Price’ in descending order.

2. Filter all goods according to any two categories.

3. Add a pivot table to show all the records according to some types. For example: Show goods quantity in different categories

4. Finally, create a chart to represent information details.

Types of Database

Centralized database - Users from different locations can access this database from a remote location at the central database, that store entire information and application programs at a central computing facility for processing.

Operational database - This is more of a basic form of data that contain information relating to the operations of an enterprise.

End-user database - End user is the user of software, application or a product. This is a shared database which is shared by users and is meant for use by the end users, just like managers at different levels.

Commercial database - This is a database that contains information which external users may require. However, they will not be able to afford to maintain such huge database by themselves.