PROJECT TITLE:

DESIGN AND DEVELOPMENT OF A TEACHER LESSON PLANNER MANAGEMENT SYSTEM

USING VISUAL BASIC 2013 AND MICROSOFT ACCESS

Candidate Name: Mufaro Mukodzongi

Candidate Number: _________________________

centre name : Mutoko high school

Centre Number: ____________________________

Subject: Computer Science

paper code :04

Subject Code:

project title A TEACHER LESSON PLANNER MANAGEMENT SYSTEM

Level: O Level

Year: 2026
# STAGE 1: PROBLEM IDENTIFICATION

## 1.1 Description of the Problem

At Mutoko high school the Staff still use manual methods such as exercise books and
files for preparing and storing lesson plans. This creates challenges because lesson
plans can be lost or damaged, searching for previous work is difficult, and teachers
spend more time rewriting records. School administrators also face challenges when
monitoring teachers' lesson preparation. Therefore, there is a need for a computerised
system that can improve the storage, management and retrieval of lesson plans.

## 1.2 Statement of Intent

The purpose of this project is to design and develop a Teacher Lesson Planner
Management System using Visual Basic 2013 and Microsoft Access. The system will
allow teachers to enter, store, update and retrieve lesson planning information such as
subjects, classes, topics, objectives, teaching methods and assessments. It will reduce
paperwork, save time and improve the management of teaching records.

## 1.3 Project Specification / Parameters

The system will be developed as a desktop application with user-friendly forms and
navigation buttons. It will use a Microsoft Access database to store related information
securely. The system will provide data entry forms, searching facilities and reports to
assist teachers and school administrators in managing lesson plans effectively.
# STAGE 2: INVESTIGATION OF RELATED IDEAS (10 MARKS)

## Idea 1: Manual Lesson Planning Books and Files

Was used Artillery Secondary school

This method involves teachers writing lesson plans in exercise books and storing them
in physical files.

**Advantages:**

* It is simple to use and does not require computer knowledge.

* It has a low cost of implementation.

* It can be used without electricity or computer equipment.

**Disadvantages:**

* Lesson plans can easily be lost, damaged or misplaced.

* Searching for previous lesson plans is difficult and time-consuming.

* It requires a lot of physical storage space.

---

## Idea 2: Microsoft Word Lesson Planning System

Was used at mutoko government high school

This method involves teachers preparing and storing lesson plans using Microsoft Word
documents.

**Advantages:**
* Lesson plans can be edited and updated easily.

* Documents can be formatted professionally and printed.

* Most teachers are familiar with word processing software.

**Disadvantages:**

* It does not provide proper database organisation.

* Searching through many documents can be difficult.

* Files can be accidentally deleted or misplaced.

---

## Idea 3: Online Lesson Planning System

Was used at Nyadire High School

This method involves using internet-based applications to create and store lesson
plans.

**Advantages:**

* Lesson plans can be accessed from different locations.

* Information can be shared easily between users.

* Data can be stored electronically and organised.

**Disadvantages:**
* It requires a reliable internet connection.

* It may involve subscription and maintenance costs.

* Some schools may lack the required technological resources.

---
# STAGE 3: GENERATION OF POSSIBLE SOLUTIONS (10 MARKS)

## Solution 1: Spreadsheet Based Lesson Planner

This solution involves using Microsoft Excel to record and manage lesson planning
information.

**Advantages:**

* It is easy to create and use.

* It has a low cost because Excel is commonly available.

* Information can be edited and printed easily.

**Disadvantages:**

* It has limited security features.

* It cannot manage relationships between different types of data effectively.

* Searching and generating complex reports can be difficult.

---

## Solution 2: Database Based Teacher Lesson Planner System

**Advantages:**
* It provides organised storage of lesson information using related tables.

* It allows quick searching, updating and retrieval of records.

* It can generate reports automatically for teachers and administrators.

**Disadvantages:**

* It requires programming knowledge to develop.

* Development and testing may take a long time.

* It requires computers and electricity to operate.

---

## Solution 3: Web-Based Lesson Planner System

This solution involves developing an online system where teachers can create and
access lesson plans through the internet.

**Advantages:**

* Teachers can access lesson plans from different locations.

* Information can be shared easily among authorised users.

* Data can be backed up online.

**Disadvantages:**

* It requires a stable internet connection.

* Development and maintenance costs are high.

* It may require specialised technical support.

---
# STAGE 4: DEVELOPMENT/REFINEMENT OF CHOSEN IDEA (10 MARKS)

## Chosen Solution

The selected solution is the **Database Based Teacher Lesson Planner Management
System** developed using Visual Basic 2013 and Microsoft Access.

## Justification of Choice

The database-based system was selected because:

* It provides organised and reliable storage of lesson planning information.

* It allows quick searching, updating and retrieval of lesson records.

* It can generate reports to assist teachers and school administrators.

## Developments and Refinements

### 1. Development of User Input Forms

User-friendly forms were created for entering teacher details, subjects, classes and
lesson plans. The forms contain text boxes, combo boxes and command buttons to
make data entry easier and reduce errors. Navigation buttons were also added to allow
users to move between records efficiently.

### 2. Development of Database Tables and Relationships

The database was improved by creating related tables for teachers, subjects, classes
and lesson plans. Primary keys and foreign keys were used to connect the tables. This
reduces duplication of information, improves data accuracy and makes searching for
records easier.

### 3. Development of Queries and Reports

Queries were created to allow users to search and retrieve specific lesson information
such as lessons by teacher, subject or date. Reports were developed to present stored
information in a clear and organised format that can be printed and used by teachers
and school administrators.
# STAGE 5: PRESENTATION OF THE FINAL SOLUTION

STAGE 5: PRESENTATION OF THE FINAL

SOLUTION (20 MARKS)
5.1 Introduction
The final solution is a Teacher Lesson Planner Management System developed using
Visual Basic 2013 and Microsoft Access. The system helps teachers at Mutoko High
School prepare, store, edit and retrieve lesson plans electronically. It replaces the manual
use of exercise books and files, making lesson planning faster and more organised.

5.2 System Features

The system has the following features:

 Login system for authorised users.

 Main menu for easy navigation.
 Teacher registration form.
 Subject management form.
 Class management form.
 Lesson plan entry form.
 Search lesson plans by teacher, subject or class.
 Print lesson plan reports.
 Logout option.

5.3 Forms Designed

Login Form

Purpose: Allows only authorised teachers to access the system.

Controls Used:

 Username TextBox
 Password TextBox
 Login Button
  Exit Button

Main Menu

The Main Menu provides navigation to all parts of the system.

Buttons include:

 Teachers
 Subjects
 Classes
 Lesson Plans
 Reports
 Logout

Teacher Form

This form stores teacher information.

Fields include:

 Teacher ID
 Full Name
 Department
 Phone Number

Buttons:

 Save
 Update
 Delete
 Search
 Clear

Lesson Plan Form

This is the main form used by teachers.

Information entered includes:

 Teacher Name
  Subject
 Class
 Date
 Topic
 Lesson Objectives
 Teaching Methods
 Learning Activities
 Assessment

Buttons:

 Save
 Update
 Delete
 Search
 Print

5.4 Database Tables

The Microsoft Access database contains the following tables:

Table Name Purpose

Teachers Stores teacher details
Subjects Stores school subjects
Classes Stores class information
LessonPlans Stores lesson plan records

5.5 Sample Lesson Plan Record

Teacher Subject Class Topic Date
Mrs Chikore Mathematics Form 4A Quadratic Equations 15/03/2026
Mr Moyo Computer Science Form 4C2 Visual Basic Forms 16/03/2026
Mrs Nyamande Biology Form 3B Photosynthesis 17/03/2026

5.6 Reports Produced

The system can produce:
  Teacher Lesson Plan Report
 Subject Report
 Class Lesson Report
 Daily Lesson Report

These reports can be printed and submitted to the Head of Department or School
Administration.

5.7 Testing the System

The system was tested to ensure that it worked correctly.

Test Performed Expected Result Actual Result Status

Login User accesses system Successful Pass
Save lesson plan Record saved Successful Pass
Search lesson Lesson displayed Successful Pass
Update lesson Record updated Successful Pass
Delete lesson Record removed Successful Pass
Print report Report printed Successful Pass

5.8 Benefits of the System

The developed system:

 Saves teachers' time when preparing lessons.

 Stores lesson plans securely.
 Reduces paperwork.
 Makes searching for lesson plans easier.
 Improves record keeping.
 Reduces loss of lesson plans.
 Produces neat printed reports.
 Helps school administrators monitor lesson preparation.
# STAGE 6: EVALUATION AND RECOMMENDATIONS (5 MARKS)

## Evaluation

The developed Teacher Lesson Planner Management System successfully addressed

the problem of managing lesson plans manually. The system improved the storage,
retrieval and organisation of lesson information. Teachers can now enter lesson details
electronically, search for previous plans quickly and produce reports when required.
The system achieved its objectives of reducing paperwork, saving time and improving
lesson record management.

## Challenges Encountered

During the development of the system, some challenges were experienced, including:

* Designing correct database relationships between tables.

* Connecting Visual Basic 2013 with the Microsoft Access database.

* Debugging errors during programming and testing.

## Recommendations

The system can be improved in future by:

* Adding different user accounts with different access levels.

* Creating a backup system to prevent loss of information.

* Developing a mobile application version for easier access.