Lesson plan 2

Long-term plan unit:
10.4A Information systems

School:

Week:

Lesson:  2

Teacher name:

Grade:

Number present:

absent:

Theme of the lesson

SQL query language

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

·         10.3.3.1 to make queries using extracted data (SQL (эс кю эль))

Lesson objectives

·         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

Success 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 ERD, Normalisation, connections in databases.

Learning Objectives

5-10 mins

Teacher determines the lesson topic and shows learning objectives

What is SQL? Teacher explains the basics of Structured Query Language.

Learning Objectives

Presentation

10-20 mins

Students to be divided into two groups and make a research about DDL and DML

Each group prepare a presentation about DDL and DML

DML wikibooks

DDL wikibooks

20-25 mins

Students show their findings in front of other students

25-30 mins

Teacher to go through the commands of DML

Presentation

30-38 mins

Students perform the task of 1, 2, 5, 8, 12

http://sqlzoo.net/wiki/SELECT_from_Nobel_Tutorial

End

38-40 Mins

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

Project:

(1)Portfolio Assessment
(2)Rubrics

Students given/shown exemplar material. Success criteria shared with students/ rubric is used. Students answer questions/ draw diagrams/ take notes. Where useful work is uploaded Moodle, TeachDirect to record and evidence students’ own progression and achievement.

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?