Projects

ACADEMIC PROJECT CLEARENCE SYSTEM

Project Title

Digitized Student Clearance and Academic Clearance Tracking System

1. Project Overview & Objective

Manual clearance processes at universities are time-consuming and prone to errors. The objective of this project is to develop a centralized Web-based Information System that allows graduating students to seamlessly get clearance from various departments (Academics, Library, Finance, and Hostel) and track their academic progression. 

2. Proposed Technology Stack

• Frontend: HTML5, CSS3, JavaScript, and React.js (or Bootstrap for responsive design).

• Backend: Node.js with Express.js or Python (Django/Flask).

• Database: MySQL or MongoDB for storing student records and clearance statuses.

• Tools: Visual Studio Code, Git/GitHub for version control, and XAMPP (if using PHP/MySQL).

3. Proposed Modules and Features

• Student Dashboard: View clearance status across departments, track CGPA and transcript readiness.

• Departmental Portals (Finance, Library, etc.): Staff can verify student dues or unreturned books, and update the student's status to "Cleared" with a single click.

• Administrator Panel: Manage user accounts (students and staff), generate clearance reports, and back up the database.

• Notification Engine: Send email/SMS alerts to students when a department clears them or requests more information. 

4. Software Development Life Cycle (SDLC)

Following standard Agile methodology, your project should include the following phases:

1. Requirement Analysis: Gathering the exact clearance workflow specifications from ISBAT University administration.

2. System Design:

   1. Use Case Diagram: Shows interactions between students, departmental heads, and the administrator.

   2. Entity-Relationship Diagram (ERD): Illustrates tables for Students, Departments, Clearances, and Academics.

3. Implementation: Writing the code for authentication, role-based access control, and database integration.

4. Testing: Unit testing of individual modules (e.g., login, clearance form submission) and integration testing.

5. Visual Blueprint & Component Descriptions

To add visuals to your academic report, mock up or generate screenshots of these core pages:

Module A: System Authentication

• Description: The secure login portal where users log in according to their roles (Student, HOD, or Admin).

• Photo to include: A screenshot of the Login Page featuring the Institution logo, username/password fields, and role dropdown.

Module B: Student Dashboard

• Description: The central hub for the student to see a progress bar for their clearance and a breakdown of departmental status (e.g., Finance - Pending, Library - Cleared).

• Photo to include: A screenshot of the student's homepage displaying a visual timeline of the clearance workflow and academic profile.

Module C: Departmental Clearance View

• Description: The interface for a staff member (e.g., Library Administrator). It lists pending clearance requests and buttons to approve or reject them.

• Photo to include: A screenshot of the Library Department dashboard showing a data table with student IDs, names, "Clear" buttons, and a remarks text area.

Module D: Admin Reporting & Analytics

• Description: The master panel for the central IT/Academic admin to generate a summary report of cleared students in CSV or PDF format.

• Photo to include: A screenshot showing dashboard analytics (e.g., Pie Chart of Cleared vs. Pending students) and a generated report. 

Next Steps for Implementation

1. Scope the Project: Draft a 2-page project proposal defining the Problem Statement and Scope.

2. Setup your IDE: Download Visual Studio Code to start building your user interfaces.

3. Draft the ERD: Use tools like Lucidchart or Draw.io to design your database schema before implementation.

PERSONAL PROJECT(NETWORKING)

Project Title: Secure Enterprise Network Design & Implementation

Objective: Build a scalable, secure, and segmented Local Area Network (LAN) for a growing business, complete with secure remote access for employees. 

Tools & Technologies

• Design & Simulation: Cisco Packet Tracer (Ideal for mapping devices and testing configurations).

• Protocols: TCP/IP, DHCP, DNS, OSPF, NAT, and IPsec VPN.

• Network Devices: 1x Enterprise Router, 2x Managed Switches (e.g., Cisco Catalyst), and multiple end-devices (PCs, Servers). 

• Facebook·ISBAT University Kampala +1

• 
  

Key Features You Will Implement

1. Subnetting & VLANs: Segment the network into distinct Virtual Local Area Networks (VLANs) like HR, Engineering, and Guest to improve performance and security. 

2. Facebook·ISBAT University Kampala

3. 
   

4. Dynamic Routing: Configure the OSPF (Open Shortest Path First) routing protocol on the router to allow seamless communication between VLANs. 

5. Network Security:

   1. Set up Access Control Lists (ACLs) to prevent unauthorized VLANs from accessing sensitive corporate servers.

   2. Configure a site-to-site or remote-access IPsec VPN so remote staff can connect securely.

6. Dynamic Addressing (DHCP & DNS): Set up a centralized DHCP server to automatically assign IP addresses and a DNS server for internal web mapping.

Step-by-Step Execution

1. Plan: Draw a topology diagram defining your IP addressing scheme and subnet sizes.

2. Build: Drag and drop your routers, switches, and PCs into the Cisco Packet Tracer workspace and connect them using copper straight-through/crossover cables.

3. Configure: Use the Command Line Interface (CLI) to configure switch ports, trunking, VTP, router interfaces, and routing protocols.

4. Test: Use the ping and traceroute commands to verify connectivity. Use the simulated simulation mode in Packet Tracer to observe packet flow (ICMP, TCP, UDP) in real-time.