Lesson Notes By Weeks and Term - Senior Secondary 2

Data models II

Term: 1st Term

Week: 2

Class: Senior Secondary School 2

Age: 16 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Data Processing

Topic:-       Data Models II

SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to

  1. Discuss the three levels of abstraction in data modelling

INSTRUCTIONAL TECHNIQUES: Identification, explanation, questions and answers, demonstration, videos from source

INSTRUCTIONAL MATERIALS: Videos, loud speaker, pictures, Data Processing for senior Secondary Education by Hiit Plc, WAPB Computer Studies for Senior Secondary I by Adekunle et al, On-line Materials.

INSTRUCTIONAL PROCEDURES

PERIOD 1-2

PRESENTATION

TEACHER’S ACTIVITY

STUDENT’S ACTIVITY

STEP 1

INTRODUCTION

The teacher reviews the previous lesson on the concept of data modeling

Students pay attention

STEP 2

EXPLANATION

He explains the conceptual and logical level of abstraction

 

Students pay attention and participates

STEP 3

DEMONSTRATION

He further explains the physical level of abstraction

Students pay attention and participate

STEP 4

NOTE TAKING

The teacher writes a summarized note on the board

The students copy the note in their books

 

NOTE

LEVELS OF ABSTRACTION IN DATA MODELING

Data modeling typically involves several levels of abstraction, including:

  1. Conceptual level: The conceptual level involves defining the high-level entities and relationships in the data model, often using diagrams or other visual representations.
  2. Logical level: The logical level involves defining the relationships and constraints between the data objects in more detail, often using data modeling languages such as SQL or ER diagrams.
  3. Physical level: The physical level involves defining the specific details of how the data will be stored, including data types, indexes, and other technical details.

 

EVALUATION:    1. Explain the three levels of data abstraction

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively