1_Structured_queries_lp_l2_v1

Long-term plan unit:

 10.3A Information Systems

School

Date:

Teacher name:

Grade: 10

Number present:

Grade:

The topic of the lesson:

Structured queries

Learning objectives(s) that this lesson is contributing to

  10.3.3.2 use structured query language (SQL) to select data from tables

Assessment criteria

Knowledge and understanding:

●         explains the definition and purpose of requests;

●         Knows the algorithm for creating a sample request;

●         knows the types of requests;

Application:

●        creates queries using the constructor

Success criteria

All learners will be able to know:

Know what structured queries (SQL) are,

know the syntax of an SQL query per sample,

be able to create structured queries.

Language objectives

Students can:

Explain the purpose of sample queries, the difference between SQL and a QBE query.

Vocabulary and terminology specific to the subject:

Query, structured query language, selection, DBMS, condition, SQL, QBE, SELECT, FROM, ORDER BY, WHERE.

Useful expressions for conversations and writing:

The SQL query has the following syntax ...

To fulfill this request, you must ...

The structure of ... query uses the following keywords: ...

Value links

Group work , co-operation, time management, academic integrity

Cross curricular links

English

Previous lear

 -

Course of the lesson

Planned stages of the lesson

Planned activities at the lesson

Resources

Beginning

0-2

Warm up

Definition of the topic.

Setting lesson objectives and success criteria

Knowledge update

Announcement of the topic and objectives of the lesson

The topic of the lesson, as you can see, remains the same, but the goals and success criteria for the lesson have changed.

Introduction to the main types of data queries and their various functions

Using a SELECT query to select the desired data.

Students complete the first and second assignments and share their answers with classmates.

Middle

2-12

 For example, let's create a simple request for receiving data from the "name" and "phone" fields of the "friends" table:

SELECT name, phone FROM friends

If you need to get all the fields of the table, then it is not necessary to list them, it is enough to put an asterisk (*):

SELECT * FROM friends

In order to consolidate this knowledge, let's carry out practical work.

Presentation

https://www.youtube.com/watch?v=cLzgqDyfxEA

12-22

Practical work

Before performing the work, it is necessary to repeat the rules of SE and behavior in the computer science office.

In the course of practical work, students will learn how to create SQL queries for sampling in Access DBMS, as well as get acquainted with ORDER BY, WHERE statements. Practical work is recommended to be performed by the student individually, the teacher acts as an assistant and consultant during the course of work.

After completing the work, the teacher must give feedback on the tasks performed.

To create SQL queries in Access Database, you need:

1. Go to the tab "Create", select the command "Query Design".

2. Next you need to close the “Add Table” window.

3. In any empty place in the window, right-click and select "SQL Mode" in the context menu

Or in the “Designer” tab you can click on the “SQL Mode” button.

4. In the window that appears, you can enter your commands. By default, the “SELECT” command is already specified here.

22-32

Practical tasks – appendixes 1-4

End

 38-40

Reflection

Each student is asked to continue phrases (can be written):

I learned that…

SQL queries differ from QBE in that ...

In order to create a SQL query you need ...

Now I can use SQL queries for ...

I had difficulties ...

I overcame them with the help of ...

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.

Answers questions and a session of answers.

Use questions when completing a task.

Use survey questions to understand the results / success of learners at each stage of the lesson.

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.