Alfred Mavwu

Project Case Studies

Problems, solutions, and build decisions.

A broader look at the software systems behind the portfolio: detailed walkthroughs for the strongest work, followed by a wider showcase of web, mobile, workflow, developer, and simulation projects.

Browse Project Showcase Discuss a Project
Detailed builds Broader showcase Truthful scope

Detailed Case Studies

The strongest work, in context.

These two detailed walkthroughs show how I frame the problem, make implementation decisions, and communicate the limitations of a project in progress.

ClassReport ZM Polished Offline Demo

ClassReport ZM

A polished offline academic workflow demo for school records, classes, subjects, assessments, marks, attendance, grades, averages, positions, academic performance insights, and end-of-term learner report cards.

Type: School Academic Workflow Demo Status: Polished offline demo Stack: HTML, CSS, JavaScript, localStorage Target: Zambian Schools Approach: Browser/local-first

The Problem

School academic workflows often require the same learner, class, subject, attendance, assessment, marks, grading, averages, positions, and report-card information to be organised across teacher and administrator tasks.

The product question is how to keep those workflows structured without exposing private learner information or relying on scattered manual records.

The public description stays at system-scope level: it does not reveal real learner data, credentials, or internal school data.

The Solution

Learner Records

Organises learner and class information for teacher and administrator workflows.

Subjects and Attendance

Provides structure for subjects and attendance-related academic records.

Assessments and Marks

Supports assessment and mark organisation without exposing real learner data.

Grading and Reporting

Connects grades, averages, positions, insights, and reporting needs in one flow.

Report Cards

Supports end-of-term learner report-card workflows where printable outputs are still needed.

Offline-First Approach

Keeps the system usable where permanent connectivity cannot be assumed.

How it Works

The browser provides the application interface, JavaScript handles the academic workflow logic, and the interface is designed around school records, classes, subjects, marks, attendance, grading, academic insights, and reporting tasks.

Current Scope

  • Organises learners, classes, subjects, attendance, assessments, marks, grading, averages, positions, and reporting.
  • Supports teacher and administrator workflow thinking.
  • Includes academic performance insight and end-of-term learner report-card workflows.
  • Keeps private school and learner details out of the public portfolio.
  • Role views are demo/client-side workflow restrictions, not secure authentication or server-side authorization.

Live Demo

Interested in using or demonstrating this platform at your school? Get in touch.

View Live Demo Watch Demo Video Contact Me Back to All Projects
Final-Year Project Weather + CSV Crop Suggestions

Climate-Smart Agriculture Support App

Climate-Smart Agriculture Support App is a Flutter Android prototype built to explore practical climate-smart farming support for Zambia. It combines Firebase Authentication, device location, OpenWeather current conditions, forecasts and alerts, bundled crop information, and Firestore feedback.

Its crop suggestion feature runs locally using bundled CSV data. Forecast temperature, humidity, and rainfall are compared against crop dataset values, and crops with the lowest similarity-distance scores are ranked higher. The project demonstrates mobile development, API integration, location handling, Firebase workflows, structured error handling, and explainable recommendation logic. It is presented as a technical prototype rather than validated agricultural advice or an active machine-learning system.

Type: Flutter Android Prototype Status: Final-Year Project / Working Prototype Stack: Flutter, Dart, Firebase, Firestore, OpenWeather API Integrations: Firebase, OpenWeather API, device geolocation Focus: Zambia-focused farming support

The Problem

Farmers need timely weather-aware guidance and crop information in one place. The challenge is making location-aware weather data, forecasts, alerts, and planting suitability guidance feel usable in a mobile app instead of scattering them across separate tools.

The Solution

Location-Aware Weather

Displays current weather and forecast information for the user's device location.

Weather Alerts

Checks OpenWeather alerts and separates empty, permission, configuration, and service failure states.

Crop Information Library

Loads bundled crop profiles and educational content from local JSON assets.

CSV Crop Suggestions

Ranks crop names with explainable similarity scoring from forecast temperature, humidity, and rainfall.

Firebase Workflow

Uses Firebase Authentication and Cloud Firestore feedback submission.

How it Works

Location is retrieved through device geolocation, weather is requested from OpenWeather, and the app transforms that response into current conditions, alerts, forecast views, and daily forecast details. A recent saved location can be reused, while weather data still depends on the external API.

For crop suggestions, the daily detail view calculates average forecast temperature from the maximum and minimum values, then compares temperature, humidity, and rainfall against bundled crop dataset rows. The absolute differences are added into a similarity-distance score; lower scores rank better, and the first ten unique crop names are shown.

Outcome

  • Location-aware current weather and forecasts are available in the mobile workflow.
  • Weather alerts include explicit error and empty states.
  • Crop suggestions use explainable CSV-based similarity scoring.
  • Firebase authentication and feedback submission are part of the supported app surface.
  • The project remains a technical prototype, not validated agricultural advice.

CTA

A project showcase is available for screenshots and further discussion.

View Project Showcase Back to All Projects

Broader Software Projects

More systems built around real work.

A wider project showcase for serious software builds that are not expanded into full narrative case studies yet. Each entry stays specific about purpose, implementation, current status, and what is publicly available.

Local Work Intelligence Working MVP

Alfy Work Intelligence

A local-first work management and reporting system that turns day-to-day technical activity into searchable evidence and reliable progress reports.

Status

Working MVP / Local-first

Core technologies

React, FastAPI, SQLAlchemy, SQLite, FTS5

Implementation

  • Captures structured work activity for later review.
  • Indexes evidence for local search and audit workflows.
  • Generates deterministic progress reports from stored records.
View on GitHub
Academic Project Guidance Working MVP

Thought2Project

A database-backed platform that helps students turn broad project or research ideas into feasible directions they can explore, save, compare, and refine.

Status

Working MVP / Ongoing Development

Core technologies

Next.js, TypeScript, Prisma, PostgreSQL / Neon

Implementation

  • Supports account and session workflows for returning users.
  • Stores saved ideas and history so project directions can be revisited.
  • Separates protected administrative workflows from the public experience.
View Live Demo
Accommodation Management Working Prototype

LodgeDesk

An accommodation management system where guests can browse rooms and submit booking requests while administrators manage rooms and bookings.

Status

Working Prototype

Core technologies

React, Vite, Node.js, Express.js, Prisma, PostgreSQL

Implementation

  • Provides a public room-browsing path for prospective guests.
  • Captures booking requests as a structured workflow.
  • Connects room and booking management to an administration dashboard.
View on GitHub
Developer Productivity Tool Working MVP

repo-doctor

A read-only developer productivity tool that inspects multiple repositories and produces structured findings about documentation, testing, deployment evidence, and repository hygiene.

Status

Working MVP

Core technologies

TypeScript, Node.js, Git, Vitest

Implementation

  • Inspects local Git repositories without modifying their contents.
  • Checks documentation, tests, deployment evidence, and repository signals.
  • Outputs findings as readable Markdown and machine-friendly JSON reports.
View on GitHub
Offline Communication Working Prototype

NearbyLynk

An Android-first Flutter prototype for discovering nearby devices and exchanging text without relying on internet access.

Status

Working Prototype

Core technologies

Flutter, Dart, Android platform permissions

Implementation

  • Discovers compatible nearby devices for a direct communication workflow.
  • Coordinates Android permissions, discovery, and connection state.
  • Exchanges text between connected devices without an internet-hosted backend.
Private preview available on request.
Full-Stack Publishing Published Demo

Mavwu Blog

A simple full-stack publishing application built to explore content management, routing, and a clean publishing workflow.

Status

Published Demo

Core technologies

Node.js, Express.js, SQLite, HTML, CSS, JavaScript

Implementation

  • Connects server-side routes to a lightweight SQLite data layer.
  • Explores authentication, sessions, and content CRUD workflows.
  • Separates publishing actions from the public reading experience.
View Live Demo
Inventory and Cash Flow Prototype

StockFlow

A Flutter and Firebase prototype exploring inventory, sales, expenses, and cash-flow tracking for small operational teams.

Status

Prototype / Refinement Required

Core technologies

Flutter, Dart, Firebase, Cloud Firestore

Implementation

  • Explores stock-in and inventory movement workflows.
  • Records sales and expenses so cash movement is visible together.
  • Uses Firestore-backed data for a daily profit and activity view.
No public demo; review and preview available on request.
Personal Finance Utility Local-First Prototype

KwachaFlow

A mobile app for tracking personal money flow in Zambian Kwacha, with transaction, budgeting, debt, and export workflows kept on the device.

Status

Local-first mobile prototype / Ongoing refinement

Core technologies

Flutter, Dart, SharedPreferences, Excel export, share_plus

Implementation

  • Persists income, expenses, lending, borrowing, and repayments locally.
  • Supports personal and business budgets with one-time or weekly planning.
  • Exports budget details to Excel and shares the generated file.
No public demo or repository link is currently available.

Secondary Explorations

Serious experiments, shown with scope.

These projects are substantial enough to document, but remain secondary because they are experimental, private, or still being shaped.

Web Utility Working Demo

Public Profile Analyzer

A lightweight Flask utility that performs an initial username presence check across multiple public platforms.

Status

Working Demo / Narrow Public-Data Scope

Core technologies

Python, Flask, HTML, CSS, JavaScript

Implementation

  • Accepts a username and coordinates checks against public profile URLs.
  • Handles HTTP responses through a small Flask backend.
  • Presents availability results in a lightweight browser interface.
Try Live Demo
Procedural Life Simulation Active Offline Prototype

Life Unscripted

An Android-first offline life simulation where player choices and autonomous people shape careers, relationships, health, finances, faith, and society over time.

Status

Active prototype / Iterative development

Core technologies

Flutter, Dart, Provider, SharedPreferences, audioplayers

Implementation

  • Persists player, NPC, relationship, career, and consequence state offline.
  • Runs procedural life events where choices can create delayed consequences.
  • Uses simulation and widget tests to exercise state transitions and UI flows.
Private local project; no public demo or repository link.
Evolution and Civilization Simulation v0.10 Vertical Slice

EvoCivilization

A fully offline Godot simulation where autonomous people seek food, form relationships, migrate, organize settlements, make discoveries, and can be observed through history.

Status

Active development / 3D Life Mode vertical slice

Core technologies

Godot 4, GDScript, deterministic data-oriented simulation

Implementation

  • Keeps simulation truth separate from rendering, UI, and player intent.
  • Shares identity and state between 2D evolution and 3D Life Mode.
  • Uses deterministic simulation checks and bounded rendering for larger worlds.
Local development project; no public repository link currently wired.