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