Student Advisory System
The Purpose of this project was to group students with same background and mentality in same section which will help them in understanding and getting along with each others and help teachers to design their lectures accordingly. This project also predict students next SGPA and help then in plan their future studies and register course accordingly.
Guide to run the project: Install Xampp server for mySQL Import .sql file into mysql DataBase Octane GUN must be installed to Run Linear Regression and K-Mean Algorithm NeatBeans ide and Java JDK must be installed to inport and run project
UserName: hassaan Password: 1234
1 sex - student's sex (binary: 'F' - female or 'M' - male)
2 age - student's age (numeric: from 15 to 22)
3 Pstatus - parent's cohabitation status (binary: 'T' - living together or 'A' - apart)
4 Medu - mother's education (numeric: 0 - none, 1 - primary education (4th grade), 2 – 5th to 9th grade, 3 – secondary education or 4 – higher education)
5 Fedu - father's education (numeric: 0 - none, 1 - primary education (4th grade), 2 – 5th to 9th grade, 3 – secondary education or 4 – higher education)
6 Mjob - mother's job (nominal: 'teacher', 'health' care related, civil 'services' (e.g. administrative or police), 'at_home' or 'other')
7 Fjob - father's job (nominal: 'teacher', 'health' care related, civil 'services' (e.g. administrative or police), 'at_home' or 'other')
8 traveltime - home to school travel time (numeric: 1 - <15 min., 2 - 15 to 30 min., 3 - 30 min. to 1 hour, or 4 - >1 hour)
9 studytime - weekly study time (numeric: 1 - <2 hours, 2 - 2 to 5 hours, 3 - 5 to 10 hours, or 4 - >10 hours)
10 schoolsup - extra educational support (binary: yes or no)
11 famsup - family educational support (binary: yes or no)
12 activities - extra-curricular activities (binary: yes or no)
13 nursery - attended nursery school (binary: yes or no)
14 famrel - quality of family relationships (numeric: from 1 - very bad to 5 - excellent)
15 freetime - free time after school (numeric: from 1 - very low to 5 - very high)
16 goout - going out with friends (numeric: from 1 - very low to 5 - very high)
17 health - current health status (numeric: from 1 - very bad to 5 - very good)
18 absences - number of school absences (numeric: from 0 to 93)
19 SGPA1 - GPA of semester 1
20 SGPA2 - GPA of semester 2