structure of ... query uses the following keywords: ...
Group work ,
co-operation, time management, academic integrity
Cross curricular links
Course of the lesson
Planned stages of the lesson
Planned activities at the lesson
Definition of the topic.
Setting lesson objectives and success criteria
Announcement of the topic and objectives of the
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.
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.
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.
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”
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
Practical tasks – appendixes 1-4
is asked to continue phrases (can be written):
differ from QBE in that ...
In order to
create a SQL query you need ...
Now I can
use SQL queries for ...
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
Work in pairs / groups - support for
Help the teacher, if required.
More capable learners can demonstrate
aspects of their decisions that seem interesting / more complex to the other
Answers questions and a
session of answers.
Use questions when completing
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.