1_Concepts_of_DB_lp_l1_v1

Long-term plan unit:

 10.3A Information Systems

School:

Date:

Teacher name:

Grade: 10

Number present:

Grade:

The topic of the lesson:

Basic concepts of database

Learning objectives(s) that this lesson is contributing to

10.3.1.1 explain the concept of "relational database";

10.3.1.2 formulate definitions of terms: field, record, index

Assessment criteria

●        Know the advantages of relational database

●        Be able to analyze the tables

●        Creates a table based on the findings

Success criteria

All learners will be able to know:

The notion of relational database

The structures of relational database, methods of table creation

Language objectives

Students will be able to:

Structure information, analyze and create tables

Subject vocabulary and terminology:

field, record, index, key field, primary key, length, format, Relational database

A series of useful phrases for dialogue / writing:

The field contains …

The main advantage of the tables is ...

Value links

Group work , co-operation, time management, academic integrity

Cross curricular links

English

Previous learning

 -

Course of the lesson

Planned stages of the lesson

Planned activities at the lesson

Resources

Beginning

0-10

Warm up

Students formulate a topic, lesson objectives, and evaluation criteria to achieve the objectives of the lesson.

Glossary discussion

A relational database is a database that contains information organized in the form of a rectangular table (the simplest relational database) or a set of interrelated tables.

The relational type of database is used most often and is universal, since with the help of tables any data system can be reflected.

The main advantage of the tables is their clarity. We deal with tabular information almost every day - a schedule of lessons, a list of grades, a cool magazine, a telephone directory, a train schedule at a train station, a poster in cinemas, etc. Using the tables is easy and convenient.

The structure of the simplest database can be considered as a rectangular table consisting of vertical columns and horizontal rows.

Vertical columns are called fields, and horizontal lines are called records.

The unit of stored information is a horizontal line-record that stores information about a single object (book, employee, product). Each record is a collection of fields.

The field contains a brief description (attribute) of this object (surname, name, price). Each field has its own name (column heading)

Each record must be different from the other value of at least one field, which is called a key.

Student assignment

Convert the information below to a table view, determine the name of the table and the name of each field:

Acceleration, S, m / s, m / s2, velocity, initial speed, 3, t, m / s, 2, time, s, v, 1, distance, 4, a, m, v0

https://www.youtube.com/watch?v=Z48epmyw39c

Middle

11-20

20-25

Comprehension

The explanation of the new material is accompanied by a presentation.

The teacher talks about the differences between relational databases and others.

Acquaintance with the MS Access  main window.

The teacher shows and demonstrates the work in the program and methods for creating tables.

25-38

Formative assessment:

During the lesson the teacher makes a mark on the assessment criteria for groups. At the same time writes down which students need additional help.

The survey on the new concepts studied on the lesson:

• Relational database

• Record

• Records field

• Primary key (simple, composite)

• Types and formats of fields

Assignment: Invent and describe the structure of a database table, which contains four fields of different types: character, numeric (integer or real), date, logical. The table should contain real information and have a name.

End

 38-40

Reflection

The learners speak in a circle with one sentence, choosing the beginning of a phrase from the reflective screen on the board:

today i found out ...

it was interesting…

it was difficult…

I was doing the job ...

I realized that ...

Now I can…

I felt that ...

I learned ... I did it ...

I could ...

I'll try…

I was surprised ...

The board

Differentiation – how do you plan to give more support? How do you plan to challenge the more able learners?

Assessment – how are you planning to check students’ learning?

Health and safety regulations

Additional support.

Work in pairs / groups - support for classmates.

Help the teacher, if required.

More capable learners can demonstrate aspects of their decisions that seem interesting / more complex to the other learners.

Assessment is carried out at each stage of the lesson:

- according to the assessment criteria, analyze the successes and difficulties that will allow the teacher to look at the lesson through the eyes of students, to analyze it in terms of value for each student.

Remind of some safety rules when working with computer equipment, for example, that you must be careful when installing the screen, keyboard and mouse; beware of wires, as they pose a threat to movement.