9 Lesson №58 Database development Lesson plan

4term.

Long-term Plan Unit:10.4А Information Systems

Lesson: №58

School: 

Date:

Teacher Name:

Grade: 10

Number Present: 

Absent:

Theme of the Lesson:

Database Development

Learning

Objectives

10.3.2.2 create a single-table database (SQL);

Lesson

Objectives

-create a single-table database using SQL queries and a constructor

Success

Criteria

Knowledge and understanding:

- to know queries for creating and working with single-table database;

- to know what a local server is, its purpose and composition;

Applying:

- write a query to create a single-table database;

- create a single-table database, in constructor mode;

Analysis:

- explain the structure of the created database, according to the SQL query.

Language

Objectives

Specific vocabulary and terminology:

Queries, MySQL, phpMyAdmin, local server, primary key.

Useful phrases for conversation / writing

For ... is necessary to use the query ...

To add a column to the table, you need ...

After completing this request, it will be executed ...

Values

Instilled

Ability to work in a team to achieve a result. Respect for other people's opinions.

Mutual respect and support.

Cross-curricular

Links

Geography

Previous

Learning

Data types in MySQL DBMS;

SQL queries.

Course of the lesson

Planned
Timings

Planned Activities

Resources

Beginning

0-2 minutes

3-4minutes

5-6minutes

7-12minutes

13-14 minutes

15-17 minutes

Middle

18-30minutes

31-36minutes

End

37-40minutes

Class room management: greeting, checking absentees.

Discussion:

The teacher asks questions to determine if students are familiar with the concept of a local server. What local web servers are familiar with, what is their purpose? (Previous homework to installDENWER).Focus student on that to work in MySql BDMS is necessary to install local server.

Introduction lesson topic, objectives and discussion of assessment criteria.

Explanationanddemonstrationbytheteacher:

explain what a local server is, give a definition. Explain what software is included. Give examples of local web servers. Explain the purpose of the application phpMyAdmin and ways to work with MySQL.

Launch a local server and demonstrate the process of logging into the PhpMyAdmin panel for working with MySQL databases. Show the tab in which you need to write SQL queries.

Divisionintopair:using the online service to divide students into pairs.

Actualization of knowledge:show the “Regions” table. Together with students, identify the key field and data types for the fields. Discuss student opinions.

Pair work:

Task: Using the proposed resources, students learn the process of writing a query to create a single-table database.

Write queries for:

1. Creating a DB “Qazaqstan”

2. Creatinga table “Regions”

3. Adding data to the table “Regions”

(You must add at least 5 regions)

4. Delete the record where the population is less than 200000

5. Update of data (increase population in Nur-Sultan per 1000 people)

As a support, the teacher can prepare blanks of ready-made queries or discuss each query with the class during the work.

1. A query to create a DB «Qazaqstan»:

CREATE DATABASE Qazaqstan;

2. A query to create a table «Regions»:

CREATE TABLE Regions (

ID CHAR(2) NOT NULL Primary key,

Region VARCHAR(30) NOT NULL,

Population INTEGER NULL);

3. A query to insert data into table “Regions”:

INSERT INTO Regions (ID, Region, Population) VALUES (1,"Нур-Султан",1070196);

4. A query to delete a record by condition:

DELETE FROM Regions WHERE Population < 200000;

5. A query to update a record by condition:

UPDATE Regions SET Population = Population + 1000 WHERE Region = "Нур-Султан";

Differentiation task:

Students who perform the main task before the others can independently start developing a database that will be used in the next lesson.

1. Develop a DB“Mobile_store” and a table“Clients”by using the interface PhpMyAdmin.

2. Add the fieldsId, Name, Surname, Gender, Phone

in thetable “Clients”

Formativeassessment:

Students perform 4 tasks, for checking the level of learning. Then students complete the work and hand over to the teacher. The teacher gives written feedback and returns the work to the next lesson.

Reflection:

The teacher verbally asks the students:

1. What difficulties did you face during the lesson?

2. What did you learn in the lesson?

3. Where can you apply this knowledge in real life?

Presentation (slide_1)

Presentation (slides_2-3)

Presentation (slides_4-6)

Online service:

https://castlots.org/razdelit-na-gruppy/

Presentation (slide_8)

Presentation (slide_9)

https://tproger.ru/translations/sql-recap/

https://php-myadmin.ru/learning/

Presentation (slide_10)

Presentation (slide_11)

https://metanit.com/web/php/7.1.php

Presentation (slide_12)

Document «Formative Assessment»

Presentation (slide_13)

Differentiation

Assessment

Health and Safety

Reflection

Were the lesson objectives/learning objectives realistic? Did I stick to timings?

What changes did I make from my plan and why?

Did all learners achieve the LO?

Did my planned differentiation work well?

If not, why?

Summary Evaluation

What two things went 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 achievements/difficulties of individuals that will inform my next lesson?