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. |
|||
Скачано с www.znanio.ru
Материалы на данной страницы взяты из открытых источников либо размещены пользователем в соответствии с договором-офертой сайта. Вы можете сообщить о нарушении.