1_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:

Requests

Learning objectives(s) that this lesson is contributing to

  10.3.3.1 create queries for a sample using the constructor

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 a request is

know the types of requests

be able to create sample queries using the constructor.

Language objectives

Students are able to:

Explain the algorithm for creating a request, its purpose.

Vocabulary and terminology specific to the subject:

Query, structured query language, selection, DBMS, condition.

Useful expressions for conversations and writing:

To create a request you need ...

There are different kinds of queries, such as ...

In order to get the request ..., you need ...

Value links

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

Cross curricular links

English

Previous learning

 -

Course of the lesson

Planned stages of the lesson

Planned activities at the lesson

Resources

Beginning

0-5

Warm up

Pupils with teacher remind the topic of the last lesson.

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).

Middle

5-20

Practical work:

At the beginning of work it is necessary for students to remember how to sit at a computer.

Students in pairs do practical work on creating queries for sampling, deleting, and creating a table.

Requests must be created:

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.

After completing the students demonstrate the work of the teacher. The teacher provides feedback.

https://youtu.be/VNe56WIY8so

20-30

Differentiated tasks:

Create queries:

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).

30-38

Individual work:

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 Access Database?

https://goo.gl/FFHQJf

https://goo.gl/93mXoA

End

 38-40

Reflection

Fill in the empty table cells with a “+” sign if you agree with the statement or “-” if you disagree with the statement.

Appendix 1

Cards

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.