Presentation on computer science tabular information models. Table information models (grade 9)

Slide 1.

Table Type "Object Property" Table. Home Library Number Author Name Year Regiment 0001 Belyaev A.R. Amphibian man 1987 5 0002 Kerwood. Tramps of the North 1991 7 0003 Turgenev I.S. Stories and stories 1982 1 0004 Olechay. Favorites 1987 5 0005 Belyaev A.R. Star CEC 1990 5 0006 Tynyanov Yu.N. Kuhl 1979 1 0007 Tolstoy L.N. Stories and stories 1986 1

Clade 2.

Slide 3.

Slide 4.

Why do you need a lot of models? Studying body structure fitting clothes study of heredity Training rescuers accounting for citizens of the country

Slide 5.

What is the model? The model is a simplified similarity of a real object. The model reflects only some object properties substantial in terms of modeling target.

Slide 6.

What is modeling? Modeling is a person's activities to create a model (inventory or informational)

Slide 7.

The concept of modeling object should be understood in the broadest sense. It can be a material object: ship, comet, live cell; Nature phenomenon: thunderstorm, solar eclipse; Process: Flying Rockets, Changing the value of shares on the stock exchange and much more.

Slide 8.

Give the definition of formalization. Formalization is the result of the transition from the real properties of the modeling object to their formal designation in a specific iconic system.

Slide 9.

1) What is the simplified representation of the real object? original; prototype; model; system. Answer: 3.

Clade 10.

2) the process of building models is called: modeling; constructing; experimentation; design. Answer: 1. When use modeling?

Clade 11.

3) the information model consisting of rows and columns is called: graph; scheme; drawing; table. Answer: 4. In addition to information, what are the models in nature?

Slide 12.

4) what is the general name of the models that are a totality of useful and necessary information About the object? material; information; subject; verbal; Answer: 2

Slide 13.

5) the geometric model of the rectangular triangle is: layout; definition; drawing; A + B + C \u003d 180 °, AU2 \u003d AC2 + SU2. Answer: 3.

Slide 14.

Structure Models Table Models (Couplings) Hierarchical (Multi-Level) Models Network Models (Graphs) Start Finish 1 3 2 4 6 7 8 5

Slide 15.

Slide 16.

Table models - objects and their properties are presented as a list, and their values \u200b\u200bare placed in a rectangular shape cells. The list of similar objects is placed in the first column (or row), and the values \u200b\u200bof their properties are placed in the following columns (or lines)

Slide 17.

Task: With the help of a table, solve the task: Masha, Olya, Lena and Valya - wonderful girls. Each of them plays on some musical instrument and speaks in one of the foreign languages \u200b\u200b(English, Ital., Franz., Spanish.). They have different tools and languages: Masha plays a piano; A girl who speaks French playing a violin; Olya plays a cello; Masha does not know the Italian language, and Olya does not speak English; Lena does not play on the harp, and the cellist does not speak Italian. Determine what tool every girl is playing, and how she owns it. Piano Skyrp Viol Arp English, French, French, Masha Olya Lena Valya

Slide 18.

The verbal description of the cost of landing 1 hectares of gardens and berries in the central regions of Russia in 1980 was given. Build a model that helped more clearly imagine this picture. The cost of landing 1 hectares of gardens and berries in the central regions of Russia in 1980. Wage during the landing of the gooseberry - 167 rubles. Fuel, Yadochimikati and herbicides for planting strawberries - 115 rubles. Fertilizers when planting black currant - 585 rubles. Material on a shpaller when boarding raspberries - 780 rubles. Fuel, Nadah Mikati and herbicides for planting black currant - 90 rubles. Planting material when planting strawberries - 1750 rubles. Payment of work when landing black currant - 150 rubles. Confusion when landing raspberries - 532 rubles. Fertilizers when boarding the gooseberry - 555 rubles. Fuel, Yadochimikati and herbicides for landing raspberries - 89 rubles. Planting material when boarding the gooseberry - 594 rubles. Other expenses when landing strawberries - 584 rubles. Warry pay when landing raspberries - 235 rubles. Fuel, Yadochimikati and herbicides for landing gooseberry - 92 rubles. Fertilizers when planting strawberries - 313 rubles. Other expenses when boarding black currant - 260 rubles. Planting material when landing raspberries - 1200 rubles. Remuneration when landing strawberries - 316 rubles. Other expenses when boarding the gooseberry - 388 rubles. Planting material when planting black currant - 1100 rub. Other expenses when landing raspberries - 474 rubles.

Slide 19.

The costs of landing 1 hectares of gardens and berries in the central regions of Russia in 1980. Raspberry Raspberry Smorodina Strawberry Payments for labor when landing 167,00R. 235.00r. 150.00r. 316,00r. Fuel, Yadochimikati and herbicides 92,00r. 89,00r. 90.00r. 115.00r. Material on a 1880.00p holder. Planting material 594.00. 1 200.00. 1 100.00. 1 750.00r. Other expenses when landing 388.00. 474.00r. 260.00r. 584,00r. Fertilizers when landing 555,00r. 532.00r. 585.00r. 313.00.

Slide 20.

Clade 21.

Graphic information models (Scheme, structure, graph) Scheme is a graphical display of the composition and structure of a complex system. The structure is the order of combining the elements of the system into a single whole. The schedule is a process model.

Slide 23.

Slide 24.

1. Types of type "Object property" 2. Table type "Object" 3. Binary matrices

Slide 25.

Table Type "Object Property" Table. Weather Day Sediment Temperature Pressure Humidity 15.03.2015 Snow -3,5 746 67 16.03.2015 Without precipitation 0 750 62 03/17/2015 Fog 1.0 740 100 03/18/2015 Rain 3.4 745 96 03/19/2015 No precipitation 5.2 760 87.

Clade 26.

Table Type "Object" Table. Roads This table contains information about the availability of direct roads between settlements of summer houses Lake Podgorny Elovo Beavers Dacha 1 1 1 1 0 Lake 1 1 0 1 1 Podgorno 1 0 1 0 1 Elovo 1 1 0 1 1 Bobras 0 0 1 1 1

Clade 27.

Binary matrices table. Optional The table shows information about the visit to four disciples of the three electives. You should already be clear that the unit means visiting, zero - fisos. In the tables representing binary matrices, the qualitative nature of communication between objects is reflected. Pupil Geology Flower Dance Rusanov 1 0 1 Semenov 1 1 0 Zotova 0 1 1 Sankin 0 0 1 Table design rules
Table type "Object properties"
Types of "object objects-one"
Computing tables
Solution of logical tasks

Keywords

Table type "Object properties"
Table type
"Object objects-one"
Computing table
Mutually unambiguous compliance

Tables around us

Chronological tables

Basic dates in computer history
№
date
Event
1.
3000 BC.
Accounts in China
2.
1642
Summing car Pascal
3.
1694
Accounting machine Leibnitsa
4.
1801
Jacquar cards
5.
1830s
Programmable Babbja Machine
6.
1890
Hollyrite countable car
7.
1946
First EUM.
8.
1948
The invention of the transistor
9.
1964
The appearance of integrated circuits

schedule of lessons

TV program

Table D.I. Mendeleev

let's discuss

Tables are for describing a number of objects,
possessing identical sets of properties.
Specify objects and the same
Properties of objects
?

the National costume

In Spain, women's national clothing is magnificent
Dress with Bata de Cola swans, headdress - Mantilla
or Kofya de Papos, instrument - guitar and cassays.
In Russia, National Women's Clothing - Sarafan, Kokoshnik
or handkerchief. Tools - Balalaika and harmonica.
In India, women wear sari, chole, dupattu, and national
The tool is sitar.
Bata de Cola is a magnificent dress with flocks and frills.
Mantilla - lace cape
Kofya de Pospos - lace cape on the head with high raised
base
Sari - a material of 5-7 meters long, which is special
The way turns around the body.
Choli is a short T-shirt dressed in Sari.
Dupaatta - light silk handkerchief.

the National costume
Country
Type of dress
Headdress
Tool
Spain
Dress
Bata de Cola.
Mantilla,
Kofya de Pospos
Guitar,
castanets
Russia
Sarafan.
India
Sari, Choli.
Balalaika,
Kokoshnik, scarf.
harmonic
Dupatta
Sitar
Information in the table is visual, compact,
Easy to foresee.

Table structure

Title
Head Table
B.
ABOUT
TO
ABOUT
IN
AND
TO
Programmer
Strings
CELL
Graphs (columns)

Table design rules

1. The title of the table should give
The idea of \u200b\u200bthe contained in it
information.
2. The headlines of the graph and lines must be brief.
3. The table must contain units
Measurements.
4. All table cells must be filled.
If necessary, they are asked the following
Signs:
? - data are unknown;
- data is impossible;
- The data must be taken from
overlying cell.

Classification of tables

Types of tables
Simple
Tables
OS.
Ltd
Sophisticated
Tables
UN
OSO

Table type "Properties" (OS)

OS Tables contain information about
properties of individual objects belonging
one class.
Class name
Objects
Property Name 1 Property Name 2
...
Object name 1.
Object name 2.
...
The value of the properties of the object

Sample OS Type Table

Unusual things
View
Product
Year
manufacturing
Length
(m)
Country
Jumper
1999
Portugal
3
Scarf
1998
USA
1073
Sandals
2002
Pakistan
3.93
Sakvoyuzh
2003
Brazil
3.7

Ltd. Tables contain information
about some one property of object pairs,
Most often owned by different classes.
First name
class objects
The name of the second class of objects
Name of the 1st object
2nd class
Name of the 2nd object
2nd class
Name of the 1st object
First class
Name of the 2nd object
First class
Value Property Couple Objects
...

Examples of tables OOO

Estimates on computer science
Student
Period of study
I DNTV.
II CHTV.
1st half.
4
5
4
5
5
4
5
5
4
Period
Training Bautin D.
Student
Bautin Dima
Skolina Ira
Zaitsev Ilya
Skolina I.
Zaitsev I.
I DNTV.
4
5
5
II CHTV.
5
4
5
4
5
4
1st half.

Table type "Object objects-several"

Computer science and mathematics
Period of study
Student
I quarter
II quarter
Informatik
but
Mathematician
but
Informati
ka
Mathematician
but
Bautin
4
4
5
4
Dima
Skolina
5
5
5
5
Tables
UN type contain information
Ira
About multiple properties of several pairs
Zaitsev
4
3
4
4
Objects belonging to different classes.
Ilya

Table type "Object object objects"

Anthropometric data
and sports results
The exercise
Student
Height Weight,
cm
kg
Long jump
from place
Result,
cm
Evaluation
Running per 1000 m
Result,
Evaluation
from
Bautin D.
168
56
197
5
220
5
Zaitsev I.
159
46
178
4
263
4
OSO Types contain properties information
pairs of objects belonging to different classes,
and about single properties of objects of one of the classes.

Computing tables

Computing tables - tables in which

From the same table.
Product
Price, rub.)
Number of cost
Notebook
3
10
30
Album
5
4
20
Pen
10
5
50
...
Table type OS.

Computing tables

Man
Drink
Total
Dunno
Donut
Toropany
Pilyulkin
Kvass
2
0
0
1
3
Hazing
1
3
2
0
6
Syrup
1
2
0
0
3
Castor oil
0
0
0
1
1
TOTAL:
4
5
2
2
13

Solution of logical tasks using multiple tables

Objects of two classes may be
in relation to mutually unambiguous
Compliance:
1) in these sets the same amount
objects;
2) each object of the 1st set is associated

2nd set;
3) each object of the 2nd set is associated
object
1st set.

let's discuss

?
Masha, Olya, Lena and Valya play on one of the musical
Tools and speak in one of the foreign languages.
They are different tools and languages. Masha plays a piano.
A girl who speaks French playing a violin.
Olya plays a cello. Masha does not know italian
Language, and Olya does not speak English. Lena does not play on
The harp, and the cellist does not speak Italian.
Determine which tool is playing each of
Girls and what foreign language she owns.
Girl
Musical
tool
Foreign
language

The solution of the problem

Enthusiasm
Piano
Music violin
Cello tool
Girl
Masha
Olya
Lena
1
1
Harp
French
Foreign German
language
English
Italian
Olya
Masha
Playing
on cello
on the
Lena
does not play
Playing
on the piano
Arfe
0
Valya

The solution of the problem

Enthusiasm
Piano
Music violin
Cello tool
Harp
Girl
Masha
Olya
Lena
Valya
11
0
0
0
0
0
1
0
0
11
0
0
0
0
00
1
French
Foreign German
language
English
Italian
Fill the first part
Tables

The solution of the problem

Enthusiasm
Piano
Music violin
Cello tool
Harp
Girl
Masha
Olya
Lena
Valya
1
0
0
0
0
0
1
0
0
1
0
0
0
0
0
1
French
1
Foreign German
language
English
Italian
0
0
0
Masha
Sleepy
knows
Italian
Girl,
that
He speaks
French,
CIOLOCELECT
Olya
not
not
He speaks
English
in Italian
playing the violin

The solution of the problem

Enthusiasm
Girl
Masha
Olya
Lena
Valya
1
0
0
0
0
0
1
0
0
1
0
0
Harp
0
0
0
1
French
0
0
1
0
0
1
0
0
1
0
0
0
0
0
0
1
Piano
Music violin
Cello tool
Foreign German
language
English
Italian
We get that the hobbies of Masha - Piano and English,
Oli - Cello and German, Lena - Violin
And French, Vali - Harp and Italian.

The most important thing

Tables are used to describe a number.
objects possessing the same
set properties.
The table consists of columns and rows.
The information presented in the table
Visual, compact, easy to see.
Table type "Object properties"
contains information about properties
individual objects belonging
one class.

The most important thing

Table type "object objects-one"
contains information about some one
Property of pair of objects, most often
belonging to different classes.
Computationally called tables, where
The values \u200b\u200bof some properties are calculated
using the values \u200b\u200bof other properties
From the same table.

The most important thing

Objects of two classes are in
With respect to mutually unambiguous
Conformity, if:
- in these classes the same amount
objects;
- Each first class object is associated
specified property with only one
second class object;
- Each second class object is associated
specified property with only one
First class object.

let's discuss

?
1. Give examples of tables with which
You faced life.
2. Is it always convenient to a table
Presentation of information?
3. What advantages provide
Table models compared to
verbal description?
4. any verbal description can
Replace table?
5. What rules should be held
When drawing up tables?
6. Give an example of the OS table.
7. Give an example of the Table LLC.

"Table Information Models"

Objectives lesson:

a) educational:

repeat the classification of models by the presentation method, defining the information model;

get acquainted with various forms of information models (graphic, verbal, mathematical, tabular);

remember what a table is from which parts it consists;

introduction of concepts Table object object, object-property, combined table, matrix, binary matrix.

b) developing:

development of interest in the subject due to the novelty of some concepts (matrix, binary matrix) and the forms of information presentation (presentation);

development of logical thinking with logical operation analysis;

c) Educational:

education of the cognitive activity of students.

Equipment: PC for teacher, presentation, projector, distribution material (test).

Type of lesson - Combined.

Form lesson - At the beginning of the lesson - individual, the rest of the time is frontal.

Method - Explanatory-illustrative.

Organizing time 5 minutes.

Checking homework 5 minutes.

Repetition (test) 5 minutes.

Studying a new material 25 min.

Summing up the lesson and job task. 5 minutes.

During the classes:

I.. Discussion of the performance of homework (because not all do it). The praise of individual students for activity in the previous lesson.

II. . Today you were asked to come up with the example of educational, scientific and technical, experienced, game and imitation models. Who coped with this task? (I check the presence of D.R., I ask you to read the most successful examples)

III. And now check how you learned the material of the previous lesson. Close, please, all notebooks and textbooks. I will give you a test. It gives 3 minutes. For each question you need to choose one correct answer. Started.

(See Test 3)

IV. . And now proceed to the study of a new material. We write down the topic of today's Table Information Models lesson.

Guys, you have already met with the classification of models according to the presentation method. What two large groups share models?

- Material and informational.

(2 slide)

Let's remember what information model is?

- Information model - This is a combination of information that characterizes the properties, the state of the object and the relationship with the outside world.

Thus, the information model is a set of information. In turn, this set of information can be represented in different form. What do you think in what form it can be represented?

(3 slide all that is on the slide is recorded)

First, she M.B. Presented in graphical form, for example, in the form of a scheme, graphics, drawing, cards.

Secondly, in verbal form. What do you think is a verbal form?

Verbal shape.

That's right, the verbal form is a verbal description.

The third form is mathematical. This description of relations between the quantitative characteristics of the object on the mathematical language. For example, a triangle area formula.

And the last form, what do you think, what? This is a tabular form. It is in this form that we will stop more in detail.

Well, we got acquainted with you with four forms of the information model. But then there is such a question: what form to choose when creating a model? And the answer is actually very simple.

(4 slide, write)

The form of the information model depends on the purpose of its creation.

Let's look at this on the example.

(5 Slide orally)

We are faced with the goal to trace the temperature change in June 2006. What information do we possess? We have a temperature for every day of June. What do you think, in what form we can imagine this information?

In graphical form.

Correctly we can imagine it in graphical form in the form of a graph.

(5 slide)

What can we see on this schedule?

Where the temperature grew, and where he dropped.

What day was the maximum temperature and what is it equal to?

What day was the minimum temperature and what is it equal to?

(Answer, but what day cannot say for sure.)

Thus, we see that the schedule gives us clarity, but the accuracy of the PI is lost.

Can we submit this information in any other form?

It is possible in the form of a table.

What is the convenience of this form of presentation?

The data is more accurate.

But then we will lose clarity. Well, let's consider another example.

(6 Slide orally)

We need to study which seas and oceans are washed by mainland Australia. What form of information model we are most convenient to choose.

Graphic shape, namely the card.

Is it possible anyhow somehow? Of course you can, for example, verbally. From the West Australia is washes the Indian Ocean, from the east of Tasmanovo Sea, etc. We can list all words, but will it be convenient for us to study geography thus? Not. We will not be clear.

Thus, we see that the graphic form is selected if an important requirement is visibility.

Now consider the following example. We need to explore estimates of three students for the first quarter. In what form can we submit this information model?

In graphical form in the form of a graph.

Well, look at the schedule built by me.

(7 Slide orally)

Is it convenient to study academic performance on it? And if there are a lot of students, all the graphs are confused, and it will be even more not more convenient.

How else can this information model be present?

In the form of a table.

This form is most convenient in this case, since the information is written more compact, systematized.

Thus, we see that the tabular form is selected if we need to systematize information.

Today at the lesson we will get acquainted with the tabular form of the information model. We will discuss from what the table consists of what it is characterized by what types of tables are.

As an example, consider the table. This is a testing table. This table includes estimates of three students in four subjects.

(8 Slide orally)

How many lines in this table? Name the names of the lines.

How many columns in this table? Name the names of the columns.

At the intersection of rows and columns are cells. What is listed in the cells? Thus, we can say that each table is characterized by:

the title (and if there are several tables, then another number)

the number of lines and their names (string headers)

the number of columns and their names (column headers)

content cells located at the intersection of columns and lines.

Once again inspect the table. It contains a combination of information about objects, that is, we can call this table with the information model of the academic process.

And now you will learn what types of tables exist.

(9 Slide write all that is on the slide)

The first type is the Table Object-property, the second type - the object object object and the third type - combined tables. What is this table? (Switch by reference).We write a definition:

Table object-property- This is a table in which several properties are reflected, and all objects belong to one set.

Consider an example of such a table. Table "Data on students". This table reflects four properties: date of birth, growth, etc. All objects belong to one set - a variety of students. Leave after defining the place, at home you will give your example of the Table object-property.

And now consider the Type Table Type object. We write a definition:

Table object object - This is a table that reflects one property characterizing two or more objects.

Consider an example of such a table. Table "Football Games". In this table, one property (date of the game) characterizes three objects (three classes). Leave after defining the place, at home you will give your example object object.

(next slide)

To which type refers this table? As you have already noticed in this table, several properties that characterize three objects, i.e. The table consists of two tables. Such a table is called combined. We write a definition:

Combined Table - This is a table obtained by combining in one table of several tables of the form "O.-O." and "O.-S.". Leave after defining a place, at home you will give your example of a combined table.

(next slide)

What type of table is the following table?

Object object.

Please look at the contents of its cells. The cells contain numbers. So now the rectangular table, composed of numbers, is called a matrix. We write this definition.

You probably have already noticed that the table consists of zeros and units. This table is called a binary matrix. We write this definition:

Binary matrix - This is a matrix made up of zeros and units.

It reflects the qualitative nature of the relationship between objects.

At home, come up with your example of the matrix and binary matrix.

V.. So guys, what's new you learned today at the lesson?

What is a matrix, binary matrix, what are the types of tables, how to choose the form of information model.

Are there any questions about the new material?

Table information

7th grade

Performed a presentation

iT-teacher

Kulik E.N.

Chronological tables

Basic dates in computer history

date

Event

3000 BC.

1642

Scores in China

Summing car Pascal

1694

1801

Accounting labnica machine

Jacquar cards

1830s

1890

Programmable Babbja Machine

Hollerit counting machine

1946

1948

First EUM.

The invention of the transistor

1964

The appearance of integrated circuits

Examples of objects possessing the same

properties sets

Specify objects and identical properties of objects

the National costume

Country

Spain

Type of dress

Russia

Headdress

Tool

Mantilla,

kofya de Pospos

India

castanets

Sari, Choli.

Kokoshnik, scarf.

Balalaika,

harmonic

Information in the table is visual, compact, easy to see.

Structure tables

Tabular room

Tabular room
Tabular room
Tabular room
Tabular room

General Table Title

General Table Title
General Table Title
General Table Title
General Table Title

Name Count (upper header)

String name (sideboards or side header)

Table design rules:

The title of the table should give an idea of \u200b\u200bthe information contained in it.
Headers Count and lines must be brief.
The table must contain units of measurement.
All table cells must be filled. If necessary, they are asked the following legend:

? - data are unknown;

X - data is impossible;

Data must be taken from the overlying cell.