1_Developing_db_lp_l2_v2

Long-term plan unit:

 10.1D Graphical objects

School:

Date:

Teacher name:

Grade:

Number present:

absent:

The topic of the lesson:

Developing a database

Learning objectives(s) that this lesson is contributing to

10.3.2.1 define the types of data in an SQL database;

Lesson objectives

Define datatypes of data in SQL tables

Success criteria

All learners will be able to:

Define datatypes in SQL database

See difference between datatypes in sql

Language objectives

Subject vocabulary and terminology:

Datatype, SQL, integer, numeric, char, string, define, rules, store.

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 asks learners about their knowledge on the topic of the lesson.

PPT Slide (2)

PPT Slide (3)

Middle

5-15min

Work

15-20min

20-35

min

Teacher introduces students to a new topic that they will discuss on this lesson and answer to learner’s questions.

Teacher shows a slide and asks student one-by-one to name datatypes of given data

Students in their copybook writes examples of datatypes they’ve learned today, then evaluate each other in pairs

PPT Slide (4-7)

PPT Slide (8)

PPT Slide (9)

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 (10)

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?