Computer Science School Based Project
Name of School: Phakamani High School
Name of Pupil: Mishel Ndhlovu
Level: 4 Scie
Year: 2026
Project title: Student Academic Tracking System Using a Console Application
PROJECT OBJECTIVES
1. To design and implement a system that records, calculates, and displays student
marks, totals, averages, and class rankings.
2. To provide a user-friendly interface for teachers to input marks efficiently and
accurately.
3. To allow easy identification of top-performing and low-performing students using
visual cues like color highlights.
4. To enhance learning by demonstrating practical programming skills in Visual Basic
.NET.
5. To generate a digital report that can be saved, printed, or analyzed further.
STAGE 1: PROBLEM IDENTIFICATION
1.1 Description of the problem, innovation, or identified gap
- Many schools still record student marks manually, which is time-consuming and
prone to errors.
- Teachers spend a lot of time calculating totals, averages, and rankings for a class of
students.
- Manual calculations make it difficult to quickly identify top performers or students at
risk.
- There is a need for a digital solution that allows for accurate, fast, and user-friendly
processing of student academic records.
- This system will benefit teachers and students by providing instant performance
insights.
1.2 Brief statement of intent
- I aim to develop a console-based Student Tracking System that automates the
process of recording, calculating, and displaying student academic results.
- The project will allow input of student names and marks, compute totals and
averages, sort students by performance, and display results in an organized, colored
format.
1.3 Design / Project specifications or parameters
- Must be able to handle at least 10 students and 5 subjects (configurable for smaller
or larger classes).
- Input validation must ensure marks are between 0 and 100.
- The system should highlight the top and lowest performer using colors.
- Must be implemented as a console application using Visual Basic .NET.
- Should allow easy expansion to include features like saving reports to a file or adding
subject names.
STAGE 2: INVESTIGATIONS OF RELATED IDEAS
2.1 Evidence of a related idea
1. Microsoft Excel Markbook:
- Teachers use Excel spreadsheets to record student marks.
- Formulas calculate totals and averages automatically.
2. Online Grade Trackers:
- Systems like Edmodo or Google Classroom allow online submission and tracking of
grades.
- Offer visual dashboards for student performance.
3. Simple [Link] Student Tracker (local examples in Zimbabwe schools):
- Some students develop basic VB programs to enter and calculate marks.
- Mostly lack user-friendly interfaces or features like color highlighting.
2.2 Analysis of ideas
- Excel Markbook
- Merits:
1. Easy to calculate totals automatically.
2. Can create charts and graphs.
3. Data can be printed or shared.
- Demerits:
1. Requires Excel software.
2. Limited automation for large datasets.
3. Cannot enforce input validation easily.
- Online Grade Trackers
- Merits:
1. Accessible from any device.
2. Automatic calculations and dashboards.
3. Can integrate notifications for students.
- Demerits:
1. Requires internet access.
2. Data privacy issues.
3. Usually subscription-based.
- Simple [Link] Tracker
- Merits:
1. Fully offline.
2. Customizable by the developer.
3. Can include user-friendly prompts.
- Demerits:
1. Limited features without additional programming.
2. No graphical interface by default.
3. Requires programming knowledge to extend.
2.3 Overall quality of presentation
- The above ideas are clearly explained and organized, highlighting advantages and
limitations for school use.
STAGE 3: GENERATION OF IDEAS/POSSIBLE SOLUTIONS
3.1 Evidence of possible solution
1. Console-Based Student Tracker in [Link]:
- Students and teachers can input names and marks.
- System calculates totals, averages, and ranks students.
- Color highlighting for top and lowest performers.
- Already proven effective in small classroom settings in Zimbabwe.
2. Excel-Based Tracker with Macros:
- Uses formulas and macros to automate calculations.
- Can highlight top/lowest performers automatically.
3. Web-Based Tracker (Future Idea):
- Online system for multiple classes.
- Secure login for teachers and students.
- Can produce reports and analytics.
3.2 Merits/advantages of each solution
- Console-Based Tracker
- Simple and fast to implement.
- Works offline.
- Easy to customize for different class sizes.
- Excel-Based Tracker
- Familiar interface for teachers.
- Supports charts and graphs.
- Can be printed directly.
- Web-Based Tracker
- Accessible anywhere with internet.
- Multi-user functionality.
- Scalable for large schools.
3.3 Demerits/disadvantages of each solution
- Console-Based Tracker
- Limited graphical interface.
- No automatic file saving unless programmed.
- Less visually interactive.
- Excel-Based Tracker
- Requires Excel software.
- Not as automated as a dedicated program for input validation.
- Web-Based Tracker
- Requires web development skills.
- Requires hosting and internet access.
- Security and privacy concerns.
3.4 Overall quality of presentation
- The ideas were carefully considered, showing the pros and cons of each approach.
The console-based tracker was chosen for simplicity, offline usage, and school-based
practicality.
STAGE 4: DEVELOPMENT/REFINEMENT OF CHOSEN IDEA
4.1 Indication of choice
- I chose the Console-Based Student Tracking System in Visual Basic .NET.
4.2 Justification of choice
1. Offline usability: The program can run on any school computer without internet,
ensuring accessibility for all teachers.
2. Customizability: I can easily add features such as color highlighting, input validation,
and report generation, making it adaptable to different school needs.
4.3 Developments/refinements
1. Added input validation to ensure marks are within 0-100.
2. Incorporated color-coded output for top and lowest performers.
3. Designed the system to calculate totals, averages, and rankings automatically,
making data entry fast and accurate.
4.4 Overall presentation
- The program is organized into a single module, using a Student structure, functions
for validation, and a clear Sub Main.
- The code is documented with comments, making it easy to read and maintain.
STAGE 5: PRESENTATION OF THE FINAL SOLUTION
•Console application in Visual Basic .NET program code
•Functional program for classroom use
STAGE 6: EVALUATION AND RECOMMENDATIONS
6.1 Relevance to statement of intent
- The final solution solves the original problem by allowing teachers to input marks,
calculate totals and averages, and quickly identify top and low performers.
- It replaces manual calculation and improves speed and accuracy in class
performance tracking.
6.2 Challenges encountered
- Learning proper structure in [Link] for modules, structures, and functions.
- Debugging input validation for marks to prevent errors.
- Sorting arrays of structures by average marks.
- All issues were solved by reorganizing the code, using correct syntax, and testing
each part carefully.
6.3 Recommendations
1. Add subject names for more descriptive reports.
2. Implement file saving to keep historical student records.
3. Include graphical charts for visual representation of performance.
4. Extend the program to allow more students and subjects dynamically.
5. Develop a web-based version for multi-class and multi-teacher usage in the future.