Lesson plan 3

Long-term plan unit:
10.4 A Information systems

School:

Week:

Lesson:  3

Teacher name:

Grade: 10

Number present:

absent:

Theme of the lesson

SQL query language DDL, DML, Data Dictionary

Learning objectives that are achieved at this lesson(Subject Programme reference)

·         To make reports using extracted data

Lesson objectives

·         explain the purpose of data dictionary

·         compare the data definition language (DDL), and the data manipulation language (DML)

·         describe the basic SQL queries for working with tables in a database: CREATE, ALTER and DROP

·         describe the basic SQL queries for working with one table in a database: SELECT, UPDATE, INSERT and DELETE

·         use SQL SELECT for data selection in more tables

Assessment criteria

Language

objectives

Make sure that all language statements being used are grammatically correct.

Subject-specific vocabulary & terminology:
The language of queries for SQL DDL, DML, SELECT, UPDATE, INSERT, and DELETE

Useful sets of phrases for dialogue and writing:
Primary key is…, while the foreign key is ...

To select ... you need to create the following query ...

Values instilled

within  the lesson

Students are developing independent working skills, collaborative group work and time management.Teachers to Instill and promote in students the intended willingness to follow the norms of behavior, accepted in Intellectual School.The norms of behavior based on mutual respect, responsibility and cooperation. Teachers to provide advisory support for students to make decisions in a given situation.

Cross-curricularlinks

Students are working on an individual project. Students are expected to integrate aspects of Art in graphics, aspects of Mathematics in programming and English in their report.

ICT skills

ICT skills are covered as this is a computer science subject. See objectives.

Previous learning

define the connections between tables in database

create an entity-relationship (ER) model

Course of the lesson

Planned stages of the lesson

Planned activities at the lesson

Resources

0-5 Mins

Starter:Teacher to go through last lesson Learning Objectives.

Teacher and students repeat the terms such as DDL, DML.

Learning Objectives

5-15mins

Teacher determines the lesson topic and shows learning objectives. Teacher explains the purpose of Data Dictionary.

Learning Objectives

Presentation

15-20 mins

Teacher shows the example of Data Dictionary

20-25 mins

Learn UPDATE   table_name    SET   Field = new_Value

           WHERE  selection condition;

To change the values in one or more columns of the table used UPDATE statement.

Show example

Presentation

http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

25-35 mins

Task  2

Go to this link

http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

Update London to Berlin  for CustomerID = 4

Perform the task. Show your answers for teacher

Learn  INSERT INTO table_name (field1, field2, field3, ...)

           VALUES (value1, value2, value2, ...);

To add records to the table, use the INSERT statement

Show example

Task  3

Go to this link

http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

INSERT VALUES ('Bala', 'AskarNagay', 'Abai 1', 'Taraz', '200000', 'Kazakhstan');

End

35-40Mins

Teachers to go through and recap todays topics

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

As this is a small group I will be working closely with the students, meeting their individual needs and ensuring active participation. As they will be working in small groups they are encouraged to think aloud, take risks, and develop deeper understandings and higher order thinking. Students with lower IELTS/Baseline result will require extra attention as they have a lower level of English and computer skills compared to their peers in class. Supportive Co-Teaching method will be used at time for these students, where one co- teacher is in the lead role and the other provides support.

This class is of mixed ability and level, I will ensure that I am willing to adapt the lesson as necessary.  If all students understand the topic I will move on to higher levels otherwise I will use different examples to support all students. Students with higher abilities, will be encouraged to work at a higher level, think out aloud and support their peers who are struggling.

In Class Work

(1)Group and individual feedback to tasks set against the learning objectives.
(2)Observation of learner work when circulating around the room.
(3)Review of tasks against the learning objectives
(4)Answers to teachers questions
(4)Peer and self-assessment
(5)Performance of Presentation
(6)Plenary session, recap of the overall learning objective for the lesson

Visually looking for any loose cables or PC working intermittently.

Contacting IT support in event of an ICT problem

Reflection

Were the lesson objectives/learning objectives realistic? Did all learners achieve the LO?
If not, why?
Did my planned differentiation work well?
Did I stick to timings?
What changes did I make from my plan and why?

Use the space below to reflect on your lesson. Answer the most relevant questions from the box on the left about your lesson. 

Summary evaluation

What two things went really well (consider both teaching and learning)?

1:

2:

What two things would have improved the lesson (consider both teaching and learning)?

1:

2:

What have I learned from this lesson about the class orachievements/difficulties of individuals that will inform my next lesson?