1_Developing_db_lp_l4_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.3 create a multi-table SQL database

Lesson objectives

Create a multi-table SQL database using Microsoft Access

Success criteria

All learners will be able to:

Create multi-table SQL database

Add connections between tables in Microsoft Access

Language objectives

Subject vocabulary and terminology:

SQL, database, connection, links, files, Microsoft Access

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

mins

Organizational moment:  

Question for students:

Can you remember what we discussed in our previous lesson?

Teacher gives task to open database from previous lesson and create new table with new PK, adding records, etc.

PPT Slide (2)

PPT Slide (3-4)

video

20-25min

work

25-35min

Teacher shows short video about making links

Students make links in their database. Teacher helps. Student share their databases to each other.

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?