1_Concepts_of_DB_lp_l2_v1

Long-term plan unit:

 10.3A Information Systems

School:

Date:

Teacher name:

Grade: 10

Number present:

Grade:

The topic of the lesson:

Basic database concepts

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

●        names the benefits of a relational database

●        can analyze the table

●        creates a table based on the findings

Success criteria

All learners will be able to know:

Be able to create tables, analyzing data

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-15

Warm up

Definition of the topic.

Students should answer the following questions:

1) Which data types are the following values:

1) 54.06 2) “abc” 3) false 4) -1.3 5) “123” 6) 15/06/96?

2) The “Rivers of the World” DB table contains the following fields: name, continent, length (in km), maximum depth (in m), where it flows, presence of reservoirs (available or not). Describe the type and width of each field. Determine the primary key of the table.

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

Middle

11-35

Practical part

Creating a relational database "European countries"

1. Run the Microsoft Access program.

2. In the dialog box that appears, check the box next to “New Database”, then select the folder where the database will be stored and set the name of the database, then click the “Create” button.

3. The program will automatically create the first table, use the right mouse button to go to the “Designer” creation mode, when you go, the program will ask for the name of the table, set the name “European Countries”.

4. Switch to the table mode (Appendix 1).

5. Using the website http://worldgeo.ru fill in the table so that it contains data on 20 European countries.

6. Save the database

http://worldgeo.ru

End

 35-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.