Group06 proposal

Growth Signal

Proposal

Poster

Application

Research Paper

Problem & Motivation

Problem

In Singapore, education is one of the sectors that is heavily invested by the state besides defence and health. As years progress, more data are accumulated and made available to the public by various government institutions such as Singapore Department of Statistics and data.gov. Despite the abundance of data, it is often not easy for someone fresh out of post-secondary education to plan for further studies in an efficient and thorough manner due to decentralisation and lack of visualisation (data are in raw/unstructured/tabular form).

Motivation

Enrolling in higher education such as polytechnics, especially universities is becoming a commonplace in Singapore. Not only does it prepare the next generation for the future (individual level), the country as a whole can significantly benefit as a result of a highly-educated population. This interactive visualisation will serve as a platform for post-secondary individuals to analyse the changing landscape and trends of higher education where they can uncover interesting insights and make well-informed decisions to ensure a sustainable future.

Objectives

Target Group: Post-Secondary individuals

Many of the available data such as Graduate Employment Survey, Enrolment of students in institutions of higher education and government expenditure are located either on various institutions’ website, government generated reports or on data sites. The general reader is unable to get the full information on higher learning institutions in Singapore.

As such, our Dashboard will fulfil the following objectives:

1. Visualise Singapore’s ranking in various metrics of GCI’s 5th pillar (higher Education and Training) over time
2. Identify enrolment demographic across different institutions and courses and how they changed over time.
3. Comparison of Governments’ efforts in developing Polytechnics and Universities with different sectors and other levels of education
4. Identify the courses which churns out the most successful graduates by employment rates and starting income.

Dataset

Dataset/Source	Variables & Description	Rationale of Usage
Dataset: GCI_Dataset_2007-2017 Source: World Economic Forum	Users New Users Sessions Number of Sessions Per User Page Views	abc
Dataset: Enrolment by Institutions Source: Data.gov.sg	Users New Users Sessions Number of Sessions Per User Page Views	abc
Datasets: Enrolment In Polytechnic Diploma Courses By Type Of Course And Sex, Annual Enrolment In University First Degree Courses By Type Of Course And Sex, Annual Source: SingStat	Users New Users Sessions Number of Sessions Per User Page Views	abc
Dataset: Government Operating Expenditure By Sector, Annual Government Development Expenditure By Sector, Annual Source: SingStat	Users New Users Sessions Number of Sessions Per User Page Views	abc
Dataset: Government Expenditure On Education, Annual Source: SingStat	Users New Users Sessions Number of Sessions Per User Page Views	abc
Dataset: Graduate Employment Survey - NTU, NUS, SIT, SMU, SUSS & SUTD Source: Data.gov.sg	Users New Users Sessions Number of Sessions Per User Page Views	abc

Background Survey

Research	Learning points	Improvement
	In addition to a good starting point, this visualisation allows users to select different metric of the Starting Well Index. This allows users to compare not only across different country but also Singapore’s ranking and score in the different indexes. This paints a more accurate picture of the exact area in which Singapore performed well in rather than just an overall aggregated score. In addition, the main country of study is highlighted in red to emphasis it, while the others are in grey.	However, Since Singapore ranked 30th in this index, there were too many bar graphs, making the chart and its labels too small to be seen. An area of improvement is to display only the top ten and have a separate section of the dashboard to display Singapore’s ranking. Another alternative is to fixed Singapore’s bar graph at the top of the chart while allowing users to scroll through the remaining bar graphs. Additionally, as the only displayed data is from 2012, it will be good if data from past years could be added to allow users to compare Singapore’s improvement over the years. This data can be added by including a slider bar filter for the year. Alternatively, a line chart for each country’s ranking can be plotted to compare how each country fair throughout the years.
	The dashboard is neatly organised into different sections, one side showing the salary and the other side representing data of courses. The salary range of educators is depicted in a box plot of with the higher range and lower ranges of salary. Also, for the bar graph, the main study, early childhood education, is fixed. The others can be scrolled through to allow users to compare the main study with other fields. Such a method enables easy comparison of Early childhood educators to other profession. Also, allowing for scrolling reduces the space occupied and makes the graphs easier to read as there were less data for the viewer’s eyes to read at any one time.	However, despite the pleasing colour theme and neat organisation, there was still too many words and items on the dashboard, reducing the visibility of information. The dashboard can do without the table on NIEC courses as this information is not a factor to the quality and performance of childhood education.
	Lastly, during research, our team has discovered circles packing algorithm and the bubble chart. We found it useful in representing populations from different categories, as such a graph have no need for x-axis or y-axis. Furthermore, the bubble chart allows comparison of population sizes at one glance and the bubbles can be colour coded to highlight main categories. Such a chart would be useful for us when building graphs to visualise enrolment across different institutions and courses.	However it would be hard to decipher smaller areas of the population without a legend

References

• 6 Steps to Creating a Better Marketing Dashboard
• Klipfolio - Digital Marketing Dashboard
• 100 Tasks
• Web Analytics 2.0 by Avinash Kaushik

Technical Challenges

Challenge	Description	Mitigation Plan
Unfamiliarity with Tools	Most of the team members are not too familiar with R and R Shiny.	Make use of external sources for information and troubleshooting Utilise DataCamp to learn, practice and brush up skills on R and R Shiny
Lack of policy knowledge	There may be gaps in knowledge of policy jargons.	Research online for the latest educational policy details Cross-reference and state assumptions if there are conflicting information
Data Quality & Integrity	Difficult to consolidate data as they are from different government agencies. Some of the data are in an unstructured format.	Conduct proper EDA and data cleaning methods to minimise quality problems Apply filters and follow best practices from the industry to reduce data abnormalities

Storyboard

Dashboards	Description
Dashboard 1: Higher Education Ranking	The GCI assesses the ability of countries to provide high levels of prosperity of citizens. There are 12 pillars of competitiveness. Here, we analyse the 5th pillar, namely Higher Education and Training, and its subcategories. The chart displays the ranking among the top 10 countries for the selected category. Singapore is denoted by the red line. If Singapore is not among the top 10, each country will be represented by a different colour. Select an option from the filter to view the ranking by category (5th pillar - the overall, or its subcategories).
Dashboard 2: Enrollment	The line charts show the number of enrollment for both polytechnic and university institutes over the years. Breakdown by course types are displayed on the second graph. Dropdown bar and year range slider are available on both graph and this allows for further segmentation.
Dashboard 3: Government Expenditure	The 100% stacked bar chart shows the proportion of government expenditure by sector. The education sector is shown at the top of each bar for ease of comparison over the years. The line chart shows the breakdown of education expenditure by level across year.
Dashboard 4: Graduate's Prospects	The GES is an annual survey conducted by the Ministry of Education (MoE) and the 6 universities on the employment conditions after graduation. The bar chart shows the gross monthly mean salary of different degrees offered under a university and school/faculty in 2018. The line chart shows the 25th, 50th (median) and 75th percentile of the salary of one of the degrees across year. Click on any bar of a degree to see its salary percentiles. Use the filters to compare the gross monthly mean salary of the degrees offered by other universities and their schools/faculties.

Project Timeline & Milestones

Detailed Project Timeline from Asana (team's task tracker)

Comments

Name	Date	Comments
(Name)	(Date)	(Comment)
(Name)	(Date)	(Comment)
(Name)	(Date)	(Comment)