1_Structured_queries_lp_l2_v2

Long-term plan unit:

 10.1D Graphical objects

School:

Date:

Teacher name:

Grade:

Number present:

absent:

The topic of the lesson:

Structured queries

Learning objectives(s) that this lesson is contributing to

10.3.3.2 use SQL to select data in a table

Lesson objectives

Use SQL to select data in a table

Success criteria

All learners will be able to:

Use SQL to create and change tables

Language objectives

Subject vocabulary and terminology:

Speaking and writing helpful phrases:

Methods to identify….

Different types of…

How can we use…

What is a purpose of…

Value links

Soft skills

Respect for each other when working in groups

Cross curricular links

English

Previous learning

Video Applications

Plan

Planned lesson stages

Planned activities

Resources

Beginning

0-3

3-5

mins

Organizational moment:  

Question for students:

Can you remember what we discussed in our previous lesson?

Teacher names today’s topic

PPT Slide (2)

PPT Slide (3)

Video

5-17min

Personal work

17-30min

30-35

min

Students watch video about DDL commands

Students use electronic devices and video to find definition on words from the desk

Students check their answers

PPT Slide (4)

PPT Slide (5)

PPT Slide (6)

The end of the lesson

35 - 40

At the end of the lesson, learners reflect on their learning:

✓            What has been learned

✓            What remained unclear

✓            What needs more attention

Reflection Thermometer:

                          36,6⁰С  interesting, useful

                          38⁰С is not interesting, hard

                          34⁰С useless, priceless

PPT Slide (7)

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 learners’ learning?

Health and safety check
ICT links

Differentiation can be expressed in the selection of tasks, in the expected result from a particular student, in providing individual support to the student, in selecting the educational material and resources, taking into account the individual abilities of the students (Theory of Multiple Intelligence by Gardner). Differentiation can be used at any stage of the lesson, taking into account the rational use of time.

Use this section to record the methods that you will use to assess what the students have learned during the lesson.

Health and safety check links.

Used active exercises.

Items applied from the Safety Rules in this lesson.

Reflection

Were the lesson objectives/learning objectives realistic? Did all learners achieve the LO?

If not, why?

Did my planned differentiation work well?

Did I stick to timings?

What changes did I make from my plan and why?

Use the space below to reflect on your lesson. Answer the most relevant questions from the box on the left about your lesson. 

Summary evaluation

What two things went really well (consider both teaching and learning)?

1:

2:

What two things would have improved the lesson (consider both teaching and learning)?

1:

2:

What have I learned from

this lesson about the class or individuals that will inform my next lesson?