Student Performance Analysis
Freelance Project
Description
This project aimed to analyze student performance in an 8-week learning program. The client provided raw data in Excel files, spread across different sheets, containing information about questions, scores, and overall results.
Tools
Files
Data cleaning & Analysis
I cleaned and prepared the data in Excel by organizing it into a clear format, fixing errors, handling missing values, and calculating key metrics such as the percentage of correct, incorrect, and unanswered questions for each student. This step made the data ready for analysis and visualization.
Data Visualization & Dashboards
After preparing the data, I created interactive graphs and dashboards in Tableau. These visualizations showed overall student improvement, score distributions, the effect of attendance on performance, and detailed analysis of individual questions, such as which questions were answered correctly or incorrectly most often.
Insights & Presentation
To make it easy for the client to present the results, I also created a PowerPoint presentation that included the analysis, key insights, and final visualizations, ready to be shown to stakeholders. I added extra metrics to the Excel file, built an additional Tableau dashboard, and included extra slides in the presentation to explain important trends and observations.