Amogelang Alicia Seipone

📁 My Projects Portfolio

Welcome to my public project portfolio. Below are selected academic and personal projects that showcase my skills in data analysis, programming, and statistical modeling. Click on any project title to view the repository or live site.


💻 Personal Projects

South Africa Unemployment Dashboard (Power BI)

Interactive Power BI dashboard analyzing youth vs adult unemployment trends in South Africa (2000-2024). Cleaned ILO data using Power Query, built DAX measures, and designed visualizations showing youth unemployment is 2.1× higher than adults.

South African Crime Analysis (Python)

Analyzed and visualized South African crime trends (2011–2023) using real SAPS data. Used pandas, matplotlib, and seaborn to highlight provincial and national crime trends, with markdown explanations and insights.

Causal Analysis of Smoking on Medical Costs (R)

Comprehensive statistical analysis investigating the relationship between smoking and medical insurance charges using real-world data.

Car Insurance Premium Calculator (C#)

Developed a Windows Forms application in C# to calculate insurance premiums based on user inputs. Includes logic for dynamic updates and a user-friendly interface.

Insurance Risk Analysis (R)

Worked with synthetic insurance risk data in R. Used exploratory analysis and visualizations (histograms, scatter plots) to examine risk patterns across user demographics.

Insurance Premium Calculator (HTML & CSS)

Designed a responsive front-end web tool that lets users estimate car insurance premiums. Built using HTML and CSS with a focus on clean layout and usability.


🎓 Academic Projects

Event Management System (ASP.NET 9.0 MVC)

Full-stack web application developed as part of CSIS3734 at UFS. Users can browse upcoming events, view details, register as attendees, and see confirmation of their registration. Built with C#, ASP.NET 9.0 MVC, EF Core, SQL Server, Bootstrap 5, HTML, and CSS. A glimpse of how the website works has been provided in the screenshot folder. Achieved 97% for the assignment.

Library Management System (SQL Server)

Developed a relational database to manage library operations, including books, members, and borrowing history. Designed tables, relationships, and constraints to ensure data integrity. Implemented T-SQL queries for searching, sorting, and reporting. Documented database structure and query functionality for clarity.

Nedbank Stock Volatility Analysis (R)

Analyzed historical Nedbank stock prices (2005–2012) to understand how volatility behaved across different market conditions.

Sample Distribution Theory and Inference Portfolio

Used R to analyze statistical distributions with real-world data. Covered topics like hypothesis testing, variance analysis, and data visualization. Demonstrated strong independent research and problem-solving.

UFS Recruitment System - Software Design

This was a capstone academic project focused on the design phase of the software development lifecycle. The system is designed to be a comprehensive platform that bridges the gap between University of the Free State (UFS) students and employers, facilitating recruitment, profile management, and career development.

WildLifeHaven Website (Game Reserve Guide)

Informative website about South African game reserves. Features visitor recommendations, conservation info, and wildlife sightings. Built with HTML and CSS to be clean, responsive, and easy to navigate.