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
Pupils with teacher remind the topic of the last
Division into pairs: with warm-up elements
All students must stand in a circle.
Calculate on the first-second, with the first
numbers doing 1 squat, the second number 2 tilt (left and right).
At the beginning
of work it is necessary for students to remember how to sit at a computer.
pairs do practical work on creating queries for sampling, deleting, and
creating a table.
Requests must be
1) For a sample
of all actors aged 40 years.
2) For a sample
of all married actors.
3) On a
selection of all films released from 1990 to 2000 and their directors.
4) On the
creation of the table "Old films" (until 1990)
5) To delete a
movie from the table by the entered id.
the students demonstrate the work of the teacher. The teacher provides
1) To create a table with the names of
films with 2 or more Oscars.
2) For a sample of all actors who are
married and younger than 35 years old.
3) To add a new movie to the table (the
user must enter all the data about the movie).
Students are asked to answer 3 questions
using the Internet (or handout). Students are not required to write answers
to questions. The main thing is for students to read and make brief notes.
1. What is a query and what is it for?
2. What are the types of queries in
Fill in the
empty table cells with a “+” sign if you agree with the statement or “-” if
you disagree with the statement.
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.