VCE Results Over the Year, Australia – Victoria, High School

In this blog we would like the share the data set, we collected over multiple public sources – related to VCE Results.

What is VCE? - The VCE is Victorian Certificate of Education, is the credential awarded to secondary school students who successfully complete high school level studies (Year 11 and 12 or equivalent) in the Australian state of Victoria.

The data set contains:

• School information
• VCE completion rated,
• Median VCE student score and
• Percentages of students with VCE score of 40

Below are the URLs to point to the Public Tableau reports, visualising the data set:

Raw Data Set

Learn About Tableau

High School Ranked by VCE Score

Learn About Tableau

High School Map

Learn About Tableau

Dashboard - Shows VCE High School Results Over the Years 
There are three sheets: (No.1) School ranking, (No.2) School map and (No.3) School VCE information over the years. 
Please note! Report (No.1) and (No.2) are used as a filters.

Learn About Tableau

References and Tech. Information 
(*) The data sources VCE Results files is sourced from this URL http://www.vcaa.vic.edu.au/Pages/vce/statistics/schoolstats/index.aspx
(*) Post Codes location, geo mapping was sourced from this web site http://www.corra.com.au/australian-postcode-location-data/
(*) Ranking Website (used for data validation) 
 (**) Private - http://www.bettereducation.com.au/Results/vce.aspx 
 (**)Public - http://www.bettereducation.com.au/Results/vcePublicSchoolResults.aspx  
(*) School Locations (Victoria) http://data.gov.au/dataset/school-locations-victoria (Listing of all school locations in Victoria. Includes primary and secondary schools, government and non-government)
(*) Data Base For the data we used MySQL - version 5.6. 
(*) For data visualisation we used Tableau Public - version 8.2. 
(*) Hardware/OS Apple iMac, OS X - version 10.9.4