View source for T15 Final Delivery

<!--Logo-->
[[File:G15PISA_HOME.png|1300px|]]<br>
<!--/Logo-->

<center>
<!--Header Start-->
{|style="background-color:#ffff00; color:#F8F8F8; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
| style="padding:0.3em; font-size:100%; background-color:#e5e5e5;  border-bottom:0px solid #3D9DD7; text-align:center; color:#1a2155" width="10%" | 
[[T15_Home |<font face = "Palatino Linotype" color="#1a2155" size=2><b><u>HOME</u></b></font>]]

| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp; 
| style="padding:0.3em; font-size:100%; background-color:#e5e5e5;  border-bottom:0px solid #3D9DD7; text-align:center; color:#1a2155" width="10%" | 
[[T15_Team|<font face = "Palatino Linotype" color="#1a2155" size=2><b>ABOUT US</b></font>]]

| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
| style="padding:0.3em; font-size:100%; background-color:#e5e5e5;  border-bottom:0px solid #3D9DD7; text-align:center; color:#1a2155" width="12%" | 
[[T15_Overview |<font face = "Palatino Linotype" color="#1a2155" size=2><b>PROJECT OVERVIEW</b></font>]]

| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
| style="padding:0.3em; font-size:100%; background-color:#1a2155;  border-bottom:0px solid #1e708d; text-align:center; color:#F5F5F5" width="10%" | 
[[T15_Final_Delivery |<font face = "Palatino Linotype" color="#FFFFFF" size=2><b><u>FINAL DELIVERY</u></b></font>]]

| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
| style="padding:0.3em; font-size:100%; background-color:#e5e5e5;  border-bottom:0px solid #3D9DD7; text-align:center; color:#1a2155" width="12%" | 
[[T15_Project_Management |<font face = "Palatino Linotype" color="#1a2155" size=2><b>PROJECT MANAGEMENT</b></font>]]

| style="border-bottom:0px solid #3D9DD7; background:none;" width="1%" | &nbsp;
| style="padding:0.3em; font-size:100%; background-color:#e5e5e5;  border-bottom:0px solid #3D9DD7; text-align:center; color:#1a2155" width="10%" | 
[[T15_Project_Documentation| <font face = "Palatino Linotype" color="#1a2155" size=2><b>DOCUMENTATION</b></font>]]

|}

</center><br>

== Dataset ==
=== Data Retrieval ===
The data used in this project is questionnaire result from the latest PISA survey in 2012. All raw data files are publicly available on PISA website (https://pisa2012.acer.edu.au/downloads.php). However, the raw data is in flat file text format, where a fix number of characters represent a value (eg. first 3 letters indicate country code), as follows:
[[File:3_1.1.png|500px]]
The raw data in this form is not ready for cleaning and analysis. PISA database has scripts to convert the raw text data into table forms.
* Download raw questionnaire results (zipped text files) from PISA 2012 website and extract
* Retrieve SAS programs for appropriate data files
* Open the SAS scripts in SAS Enterprise Guide
* Ensure that the path to raw text files are correct
[[File:3.1.2.png|500px]]
* Run the programs in SAS Enterprise Guide to get output SAS data table
* Export the output SAS data table in desired formats (.sas7bdat, .csv and so on); display labels as column names for easy interpretation later on.

=== Data Extraction ===
=== Data Preparation ===
== Methodology ==
=== Framework of analysis ===
=== Techniques of analysis and variable selection ===
'''K-means clustering'''
'''Partition analysis for school profiling'''
'''Constructing regression model'''
== School-level Findings ==
=== Exploratory Data Analysis ===
=== Profiling high performance and low performance schools ===
=== Multiple regression model ===

== Student-level Findings ==
=== Exploratory Data Analysis ===
=== Multiple regression model ===

== Discussion ==
=== General recommendation ===
=== Gaps identified in data for future research efforts ===
=== Conclusion ===