Module 9: Computer Studies
Database concepts and data retrieval.
Use this workbook to practice core KCSE communication skills and record evidence of progress.
Module navigation
Move module to module
Use the navigation buttons to move through the workbook in sequence.
SECTION: COMPUTER STUDIES
MODULE: 9
Part A: Units
1. Database systems
a. Database concepts
b. Data storage
c. Data retrieval
Part B: Project
Design a simple database concept for a real use case.
Project Title: Simple Database Design
Objective: Define a basic database structure and retrieval approach.
Project Instructions:
- 1. Choose a use case (library, clinic, shop records).
- 2. List key data fields for storage.
- 3. Draw a simple table structure.
- 4. Write three sample questions the database should answer.
- 5. Consult your coach where necessary.
Evidence to Submit:
- • Use case and field list.
- • Table structure sketch.
- • Sample retrieval questions.
Submission
Part C: Training Others
Teach a peer about database basics.
Guidance:
- • Explain what a database is and why it is used.
- • Demonstrate a simple table with fields.
- • Ask the learner to suggest retrieval questions.
Reflection:
- • What did the learner understand well?
- • What needed more explanation?
- • What support do you need from your coach?
Submission
Part D: Assessment
Competency Levels:
1 = Expectations not met
2 = Partially met
3 = Satisfactorily met
4 = Excellently met
Self-assessment:
- • Database concepts:
- • Data storage structures:
- • Data retrieval basics:
Coach assessment:
- • Database concepts:
- • Data storage structures:
- • Data retrieval basics:
Submission
Ready for the next module?
Keep your learning rhythm steady and record your reflections as you progress.