1_Primary_key_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:

Primary key in the database

Learning objectives(s) that this lesson is contributing to

10.3.1.3 determine the primary key in the database

Assessment criteria

●        Be able to determine the primary key of the table

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

Subject vocabulary and terminology:

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

A series of useful phrases for dialogue / writing:

Primary key 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 formulate a topic, lesson objectives, and evaluation criteria to achieve the objectives of the lesson.

Task 1. Create a tree of associations associated with this concept of "Database"

The teacher discusses with the students what the key is.

Task 2. Match the notions with definitions on the slide.

https://www.youtube.com/watch?v=6fXVL_uJ1I0

Middle

11-20

Explaining a new topic

Each row in relational database tables must meet the requirement of uniqueness. Some fields can be repeated from record to record, but the combination of all fields of a line is found only once. If you do not follow this rule, then you can mistakenly attribute the properties of one object to another.

Let’s imagine there is a table with a list of students

The lines contain names of students who are full namesake, who study in the same group. This situation is unlikely, but possible. If one of these students does not pass the exams and expels him, then by mistake you can expel the other, who has no problems with academic performance.

To eliminate such errors, you will need to add an additional property that could potentially serve as an identifier: passport data, personal case number, etc.

20-38

Group work on 4 variants - Appendix 1

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.