Competency 14
🏆 Grade 13 Project
Design & Implement a
Simple Information System
The project is an individual practical work carried out throughout Grade 13. Select a real-world problem, apply SDLC and SSADM methodologies from Unit 07, design and implement a working information system with database and programs, then present a full project report and live demonstration. Teacher-led discussions span 30 periods; additional lab access outside timetabled sessions is arranged for independent work.
📚 Competency Levels — Project (Competency 14)
COMPETENCY 14.1 — One period per week for one year
Conduct a Project on Designing an Information System
Apply SDLC stages — from problem identification through feasibility study, requirements analysis (BAM, DFD, LDS, EPD), system design, ER diagram, logical schema normalisation to 3NF, data dictionary and user interface design.
COMPETENCY 14.2 — One period per week for one year
Implement and Demonstrate the Information System
Build the database and programs, test all modules, maintain the activity logbook, write the complete project report and present a working live demonstration to the teacher and evaluators.
⚙️ Project Development Phases
🔍
PHASE 1 — INITIATION
Problem Identification & Feasibility
Select a real-world problem. Conduct preliminary investigation, define objectives and scope. Complete technical, economic, operational and organisational feasibility studies.
Topic proposalFeasibility studyTeacher approval
📊
PHASE 2 — ANALYSIS
Requirements Analysis & Current System Study
Gather functional and non-functional requirements. Draw Business Activity Model, context diagram, Level 1 DFD, Document Flow Diagram, and Logical Data Structure for the current system. Write Elementary Process Descriptions.
BAMContext diagramDFD Level 1LDSEPD
🎨
PHASE 3 — DESIGN
System & Database Design
Select the best Business System Option. Draw proposed system DFD. Design ER diagram, convert to logical schema, normalise to 3NF. Create data dictionary, table specifications and UI wireframes.
ER diagramLogical schema3NF normalisationData dictionaryUI design
💻
PHASE 4 — IMPLEMENTATION & TESTING
Build, Test & Debug
Create the MySQL/SQLite database. Code Python or PHP programs for all modules. Write and run test cases (unit, integration, system, acceptance). Fix all bugs. Maintain the activity logbook throughout.
Database SQLProgram codeTest casesBug fixesActivity logbook
🏆
PHASE 5 — REPORT & DEMONSTRATION
Documentation, Report & Presentation
Write the complete project report with all diagrams, code listing, test results and screenshots. Demonstrate the working system live to the teacher, explain design decisions and answer questions.
Project reportSource codeLive demoQ&A
💡 Sample Project Ideas
Student Management
Register students, manage marks, attendance and generate reports.
PythonMySQL
Library Management
Book borrowing, returns, overdue fines and member records.
PHPMySQL
Patient Records
Patient registration, appointments and medical history.
PythonSQLite
Inventory Management
Stock tracking, purchase orders and sales records.
PHPMySQL
Hotel Reservation
Room booking, check-in/out and customer billing.
PHPMySQL
Employee Payroll
Staff records, salary calculation and payslip generation.
PythonMySQL
Transport Booking
Seat reservations, schedule management and ticketing.
PythonMySQL
Agriculture Stock
Crop yield, fertiliser stock, farmer registration and sales.
PHPMySQL
📄 Project Report Structure
01
Title Page
Project title, name, school, index number, date
02
Acknowledgements
Thank teacher, school and all who assisted
03
Table of Contents
All sections with page numbers
04
Introduction
Background, problem statement, objectives and scope
05
Feasibility Study
Technical, economic, operational and organisational feasibility
06
Current System Analysis
BAM, context diagram, DFD Level 1, document flow diagram, LDS, EPD
07
Proposed System Design
ER diagram, logical schema, 3NF tables, data dictionary, UI wireframes, proposed DFD
08
Implementation
Database SQL, program code (Python/PHP), system screenshots
09
Testing
Test cases, results (black/white box), bug fixes
10
Conclusion & Evaluation
Achievements, limitations, future improvements
11
References
Books, websites and resources used
12
Appendices
Activity logbook, extra diagrams, full code listing
💡 Project Success Tips
Plan Early
Start in Term 1. Set deadlines per phase. Never leave the report to the last week.
Keep the Logbook
Record every activity. Teacher signs it regularly. It is part of the assessment mark.
Database First
Design and normalise your database before writing any code — it makes coding much easier.
Test as You Build
Write and run test cases module by module. Do not wait until the end to find all bugs.
Screenshot Everything
Capture running screens, database content and test results for your report evidence.
Apply What You Learned
Use Unit 07 (SDLC), Unit 08 (SQL), Unit 09 (Python) or Unit 10 (PHP+MySQL) in your build.
📥 Project — Available Downloads
📄
Project Guide & Instructions
PDF · 2.2 MB · 24 pages
📝
Project Report Template
DOCX · 0.8 MB · Ready to fill
📝
Activity Logbook Template
DOCX · 0.5 MB · Weekly log
🗜️
Sample Project — Student Mgmt
ZIP · 4.1 MB · Full example
🗜️
Sample Project — Library System
ZIP · 3.8 MB · Full example
📄
Marking Scheme Reference
PDF · 0.6 MB · Assessment criteria
📊
Presentation Slide Template
PPTX · 1.4 MB · Demo ready
🗜️
Complete Bundle — All Files
ZIP · 14.4 MB · All resources