0% found this document useful (0 votes)
2 views5 pagesUpdated Computer Science Project 1
The document outlines a school-based project to develop a digital book management system for the library, addressing issues with the current manual tracking process. The chosen solution is a Microsoft Access system that allows for efficient record-keeping, searching, and reporting of book loans. The project evaluation indicates successful implementation, with recommendations for user training and database backups for future improvements.
Uploaded by
odellmandazaCopyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
2 views5 pagesUpdated Computer Science Project 1
The document outlines a school-based project to develop a digital book management system for the library, addressing issues with the current manual tracking process. The chosen solution is a Microsoft Access system that allows for efficient record-keeping, searching, and reporting of book loans. The project evaluation indicates successful implementation, with recommendations for user training and database backups for future improvements.
Uploaded by
odellmandazaCopyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
school-based project for *Computer Science (Ordinary Level - ZIMSEC)*
Developing a Simple Book Management System f or the School
Library
*STAGE 1: Problem Identification (5 Marks)*
*1.1 Description of the Problem:*
Our school library currently uses a manual record book to track the borrowing and returning of books.
This process is slow, disorganized, and books are sometimes lost or not returned on time due to poor
tracking.
*1.2 Statement of Intent:*
This project aims to design and develop a simple, digital book management system to help the library
store, search, and update book records more efficiently.
*1.3 Project Specification / Design Parameters:*
- Must record book details (title, author, ID)
- Should allow tracking of borrowed books
- Should allow searching and reporting
- Should run on school computers without internet
- Should be easy to use by the librarian
*STAGE 2: Investigation of Related Ideas (10 Marks)*
*Idea 1: Manual Record Book*
Done by shapilo Page 1
- *Evidence:* Traditional paper logbook
- *Advantages*
-No power needed
-Easy to use
- *Disadvantages*
-Prone to damage/loss
- hard to search records
- time-consuming
*Idea 2: Excel Spreadsheet*
- *Evidence:* Basic digital list of books in Excel
- *Advantages*
-Simple to use
-Searchable
-Familiar to most users
- *Disadvantages*
-No user interface
-Lacks security
-Not suitable for many users
*Idea 3: Online Library App*
- *Evidence:* Web-based systems like SLIMS or Koha
- *Advantages*
-Access from anywhere
Done by shapilo Page 2
-Advanced features
- *Disadvantages*
-Needs internet and hosting
-Too complex for school use
*STAGE 3: Generation of Ideas / Possible Solutions (10 Marks)*
*1. Microsoft Access System*
- *Advantages*
-Easy form design
-No internet required
-Manages moderate data
- *Disadvantages*
-Requires basic training
-Not mobile accessible
*2. Excel with Macros*
- *Advantages*
-Simple setup
-Familiar software
- *Disadvantages*
-No user control
-Error-prone macros
Done by shapilo Page 3
*3. Visual Basic Application*
- *Advantages*
-Fully customized
-Includes interface and logic
- *Disadvantages*
-Needs programming skills
-Longer setup time
*STAGE 4: Development of Chosen Idea (10 Marks)*
*Chosen Idea:* Microsoft Access System
*Why Chosen:*
- Easy to create and understand
- Does not require coding
- Already available in most school computers
*System Design Includes:*
- Book Table: ID, Title, Author, Availability
- Student Table: Name, ID, Book Borrowed
- Borrow/Return Form
- Search/Report Queries
*Advantages:*
- Reduces paperwork
Done by shapilo Page 4
- Tracks books easily
- Works offline
*Disadvantages:*
- Not accessible on phones
- Requires a basic Access tutorial
*STAGE 5: Presentation of Results (5 Marks)*
- Developed a working prototype in MS Access
- Demonstrated to peers and teacher
- System successfully added, updated, and searched for book records
- Test run showed accurate tracking and report generation
*STAGE 6: Evaluation and Recommendation (5 Marks)*
*Evaluation:*
The project met its goals. The librarian can now easily check which student borrowed which book and
when it's due. The system is reliable and stores data safely.
*Recommendations:*
- Provide a short training to users