Practical Database Management - SSS 1 Plan

LESSON PLAN

PRACTICAL DATABASE MANAGEMENT

Subject	Digital Technologies
Class	SSS 1
Term	Third Term
Week	8
Topic	Practical Database Management
Duration	80 minutes (Double Period)
Date	________________

Behavioural Objectives

By the end of the lesson, students should be able to:

1. Create a simple database.
2. Create and manage database tables.
3. Run simple queries to retrieve specific information.
4. Generate simple reports from a table or query.

Previous Knowledge

Students have learnt the meaning of a database and DBMS, as well as tables, records and fields.

Instructional Materials

• Computers with a DBMS such as Microsoft Access, where available.
• Database diagrams and sample student records.
• Projector or board for demonstrating database operations.
• Prepared sample database or printed screenshots if computers are unavailable.

Teaching Methods

Demonstration, explanation, guided practice, questioning and hands-on activities.

Lesson Presentation

Time	Teacher’s Activities	Students’ Activities
5 minutes	Reviews the previous lesson by asking students to define a database, DBMS, table, record and field.	Answer questions and recall key database concepts.
10 minutes	Explains practical database management and demonstrates how to create and save a simple database.	Observe the demonstration and identify the main steps.
15 minutes	Demonstrates creating a student table, defining fields and entering sample records. Explains how to add, edit and delete records carefully.	Create or outline a student table and practise entering and editing sample records.
15 minutes	Explains queries and demonstrates selecting fields and setting a simple criterion, such as displaying only SSS 1 students.	Identify the purpose of a query and practise or describe how to retrieve selected records.
15 minutes	Demonstrates generating and previewing a simple report using a table or query.	Create or outline a simple class-list report and explain its usefulness.
10 minutes	Guides students through a practical task: create a database, make a table, run a simple query and prepare a report.	Perform the task individually or in small groups, depending on available computers.
10 minutes	Evaluates students through oral and practical questions, corrects errors and summarises the lesson.	Answer questions, demonstrate understanding and record the assignment.

Total Duration: 80 minutes

Evaluation

1. State the steps involved in creating a simple database.
2. What is a database table, and how can it be managed?
3. Explain a query and give one example of its use.
4. What is a report, and how is it generated?
5. Demonstrate or describe how to retrieve students belonging to a particular class.

Assignment

1. Draw a student table with five fields and five sample records.
2. Write the steps for creating a simple query to display students in SSS 1.
3. Explain the purpose of a database report.

Reference

CMPNOTE SSS 1 Digital Technologies Lesson Note: Practical Database Management — Week 8, Third Term.