An Investigation on Students Performance

Project Description

The project is developed from scratch as a team with anonymised live student data from the Academic year 2018-2019. This project aims to design and develop web-based interactive data visualisation using JavaScript, HTML, CSS and d3js. This is a lightweight web-based application that enables the end-user to read the information from hugely available data more easily with the help of interactive graphics.

Data Pre-Processing

Technical Implementation

  1. JSON file – The raw data was provided in a JSON file, which had lots of missing, duplicate and corrupt data as it was captured from the live environment.
  2. Power BI – We have used Power BI to understand and do the basic data processing. This data cleaning process was centralised with all members of the team.
  3. Python – we have implemented python code to convert the CSV files to JSON and vice versa, and also to analyse the data (as live data was huge)

Exploratory Data Analysis

  1. Understand and visualise the different aspects of the real-time data
  2. Identify the research questions and how the data can be presented
  3. Identify the appropriate visuals/graphs

Analysis

1. Visual 1: A COMPARISON BETWEEN NUMBER OF FEMALE AND MALE STUDENTS

Purpose: This visual is addressing the difference between the number of Male and Female Students in the university, then expand to different departments and age groups.

Functionality: This is an interactive sequence sunburst chart presenting the percentage of students by gender in each department and age group.

2. Visual 2: PERFORMANCE COMPARISON BY GENDER AND AGE GROUPS

Purpose: This visual is addressing the difference in students’ performance in term of average marks and grade by gender and age groups.

Functionality: There are two graphs in this visual. The first graph is an interactive lollipop illustrating the average marks by gender and age groups. The second graph is an interactive bar chart showing the number of students for each type of grade. There is an option to easily switching between the Stacked and Grouped bar chart to help users investigate the information.

Skip to content
%d bloggers like this: