-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathEntrylevelSQLProjectReport.html
1 lines (1 loc) · 68.9 KB
/
EntrylevelSQLProjectReport.html
1
<html><head><meta content="text/html; charset=UTF-8" http-equiv="content-type"><style type="text/css">@import url('https://themes.googleusercontent.com/fonts/css?kit=yrPxF2fzIbKO47OcVFfZ2CvhBULzVSj67-CyYQmQBzclLT34rKZNjX_x5wwcqB1FJcp4QFgPPqKvq4Bp_6u4rQ');.lst-kix_k60se73x99eg-2>li:before{content:"\0025a0 "}.lst-kix_se6fud6whwkx-7>li{counter-increment:lst-ctn-kix_se6fud6whwkx-7}.lst-kix_k60se73x99eg-0>li:before{content:"\0025cf "}.lst-kix_k60se73x99eg-4>li:before{content:"\0025cb "}.lst-kix_k60se73x99eg-3>li:before{content:"\0025cf "}ol.lst-kix_dvm78mxbk83c-2.start{counter-reset:lst-ctn-kix_dvm78mxbk83c-2 0}.lst-kix_k60se73x99eg-1>li:before{content:"\0025cb "}ol.lst-kix_vo1hiqfr384s-6.start{counter-reset:lst-ctn-kix_vo1hiqfr384s-6 0}.lst-kix_vo1hiqfr384s-0>li{counter-increment:lst-ctn-kix_vo1hiqfr384s-0}ol.lst-kix_se6fud6whwkx-1.start{counter-reset:lst-ctn-kix_se6fud6whwkx-1 0}ol.lst-kix_y0svcngzxe8t-6.start{counter-reset:lst-ctn-kix_y0svcngzxe8t-6 0}.lst-kix_sxb9z6pqma74-4>li{counter-increment:lst-ctn-kix_sxb9z6pqma74-4}ol.lst-kix_y0svcngzxe8t-0.start{counter-reset:lst-ctn-kix_y0svcngzxe8t-0 0}ol.lst-kix_sxb9z6pqma74-5.start{counter-reset:lst-ctn-kix_sxb9z6pqma74-5 0}ol.lst-kix_cgwr04oh042b-3.start{counter-reset:lst-ctn-kix_cgwr04oh042b-3 0}ol.lst-kix_dvm78mxbk83c-8.start{counter-reset:lst-ctn-kix_dvm78mxbk83c-8 0}.lst-kix_se6fud6whwkx-5>li{counter-increment:lst-ctn-kix_se6fud6whwkx-5}.lst-kix_y0svcngzxe8t-6>li{counter-increment:lst-ctn-kix_y0svcngzxe8t-6}.lst-kix_vo1hiqfr384s-2>li{counter-increment:lst-ctn-kix_vo1hiqfr384s-2}ol.lst-kix_vo1hiqfr384s-1.start{counter-reset:lst-ctn-kix_vo1hiqfr384s-1 0}ol.lst-kix_dvm78mxbk83c-7.start{counter-reset:lst-ctn-kix_dvm78mxbk83c-7 0}ol.lst-kix_y0svcngzxe8t-1.start{counter-reset:lst-ctn-kix_y0svcngzxe8t-1 0}.lst-kix_sxb9z6pqma74-8>li{counter-increment:lst-ctn-kix_sxb9z6pqma74-8}.lst-kix_sxb9z6pqma74-2>li{counter-increment:lst-ctn-kix_sxb9z6pqma74-2}.lst-kix_se6fud6whwkx-3>li{counter-increment:lst-ctn-kix_se6fud6whwkx-3}.lst-kix_cgwr04oh042b-1>li{counter-increment:lst-ctn-kix_cgwr04oh042b-1}ol.lst-kix_sxb9z6pqma74-4.start{counter-reset:lst-ctn-kix_sxb9z6pqma74-4 0}.lst-kix_y0svcngzxe8t-1>li{counter-increment:lst-ctn-kix_y0svcngzxe8t-1}.lst-kix_vo1hiqfr384s-7>li{counter-increment:lst-ctn-kix_vo1hiqfr384s-7}.lst-kix_dvm78mxbk83c-3>li{counter-increment:lst-ctn-kix_dvm78mxbk83c-3}ol.lst-kix_vo1hiqfr384s-7.start{counter-reset:lst-ctn-kix_vo1hiqfr384s-7 0}ol.lst-kix_cgwr04oh042b-2.start{counter-reset:lst-ctn-kix_cgwr04oh042b-2 0}ol.lst-kix_cgwr04oh042b-8.start{counter-reset:lst-ctn-kix_cgwr04oh042b-8 0}.lst-kix_k60se73x99eg-8>li:before{content:"\0025a0 "}.lst-kix_k60se73x99eg-7>li:before{content:"\0025cb "}.lst-kix_k60se73x99eg-6>li:before{content:"\0025cf "}ol.lst-kix_vo1hiqfr384s-0.start{counter-reset:lst-ctn-kix_vo1hiqfr384s-0 0}.lst-kix_k60se73x99eg-5>li:before{content:"\0025a0 "}.lst-kix_cgwr04oh042b-5>li{counter-increment:lst-ctn-kix_cgwr04oh042b-5}.lst-kix_vo1hiqfr384s-5>li{counter-increment:lst-ctn-kix_vo1hiqfr384s-5}.lst-kix_dvm78mxbk83c-6>li:before{content:"" counter(lst-ctn-kix_dvm78mxbk83c-6,decimal) ". "}.lst-kix_dvm78mxbk83c-8>li:before{content:"" counter(lst-ctn-kix_dvm78mxbk83c-8,lower-roman) ". "}.lst-kix_se6fud6whwkx-1>li{counter-increment:lst-ctn-kix_se6fud6whwkx-1}.lst-kix_dvm78mxbk83c-6>li{counter-increment:lst-ctn-kix_dvm78mxbk83c-6}.lst-kix_sxb9z6pqma74-5>li:before{content:"" counter(lst-ctn-kix_sxb9z6pqma74-5,decimal) ". "}.lst-kix_dvm78mxbk83c-4>li:before{content:"" counter(lst-ctn-kix_dvm78mxbk83c-4,lower-latin) ". "}.lst-kix_sxb9z6pqma74-3>li:before{content:"" counter(lst-ctn-kix_sxb9z6pqma74-3,lower-latin) ". "}ol.lst-kix_sxb9z6pqma74-6.start{counter-reset:lst-ctn-kix_sxb9z6pqma74-6 0}ol.lst-kix_vo1hiqfr384s-7{list-style-type:none}ol.lst-kix_vo1hiqfr384s-8{list-style-type:none}.lst-kix_cgwr04oh042b-4>li{counter-increment:lst-ctn-kix_cgwr04oh042b-4}.lst-kix_sxb9z6pqma74-1>li:before{content:"" counter(lst-ctn-kix_sxb9z6pqma74-1,lower-roman) ". "}.lst-kix_se6fud6whwkx-0>li{counter-increment:lst-ctn-kix_se6fud6whwkx-0}ol.lst-kix_vo1hiqfr384s-1{list-style-type:none}ol.lst-kix_vo1hiqfr384s-2{list-style-type:none}ol.lst-kix_vo1hiqfr384s-0{list-style-type:none}.lst-kix_y0svcngzxe8t-4>li{counter-increment:lst-ctn-kix_y0svcngzxe8t-4}ol.lst-kix_vo1hiqfr384s-5{list-style-type:none}.lst-kix_y0svcngzxe8t-7>li:before{content:"" counter(lst-ctn-kix_y0svcngzxe8t-7,lower-roman) ". "}ol.lst-kix_vo1hiqfr384s-6{list-style-type:none}ol.lst-kix_vo1hiqfr384s-3{list-style-type:none}ol.lst-kix_vo1hiqfr384s-4{list-style-type:none}.lst-kix_y0svcngzxe8t-1>li:before{content:"" counter(lst-ctn-kix_y0svcngzxe8t-1,lower-roman) ". "}.lst-kix_sxb9z6pqma74-1>li{counter-increment:lst-ctn-kix_sxb9z6pqma74-1}.lst-kix_y0svcngzxe8t-5>li:before{content:"" counter(lst-ctn-kix_y0svcngzxe8t-5,decimal) ". "}.lst-kix_y0svcngzxe8t-3>li:before{content:"" counter(lst-ctn-kix_y0svcngzxe8t-3,lower-latin) ". "}ol.lst-kix_y0svcngzxe8t-4.start{counter-reset:lst-ctn-kix_y0svcngzxe8t-4 0}.lst-kix_dvm78mxbk83c-8>li{counter-increment:lst-ctn-kix_dvm78mxbk83c-8}.lst-kix_se6fud6whwkx-2>li{counter-increment:lst-ctn-kix_se6fud6whwkx-2}ol.lst-kix_se6fud6whwkx-2.start{counter-reset:lst-ctn-kix_se6fud6whwkx-2 0}ol.lst-kix_y0svcngzxe8t-7.start{counter-reset:lst-ctn-kix_y0svcngzxe8t-7 0}.lst-kix_cgwr04oh042b-6>li{counter-increment:lst-ctn-kix_cgwr04oh042b-6}ol.lst-kix_vo1hiqfr384s-8.start{counter-reset:lst-ctn-kix_vo1hiqfr384s-8 0}.lst-kix_sxb9z6pqma74-7>li:before{content:"" counter(lst-ctn-kix_sxb9z6pqma74-7,lower-roman) ". "}ol.lst-kix_sxb9z6pqma74-8.start{counter-reset:lst-ctn-kix_sxb9z6pqma74-8 0}ol.lst-kix_se6fud6whwkx-0.start{counter-reset:lst-ctn-kix_se6fud6whwkx-0 0}ol.lst-kix_dvm78mxbk83c-3{list-style-type:none}ol.lst-kix_dvm78mxbk83c-4{list-style-type:none}.lst-kix_vo1hiqfr384s-3>li:before{content:"" counter(lst-ctn-kix_vo1hiqfr384s-3,lower-latin) ". "}ol.lst-kix_dvm78mxbk83c-5{list-style-type:none}ol.lst-kix_dvm78mxbk83c-6{list-style-type:none}ol.lst-kix_dvm78mxbk83c-0{list-style-type:none}ol.lst-kix_sxb9z6pqma74-7.start{counter-reset:lst-ctn-kix_sxb9z6pqma74-7 0}ol.lst-kix_dvm78mxbk83c-1{list-style-type:none}ol.lst-kix_dvm78mxbk83c-2{list-style-type:none}.lst-kix_cgwr04oh042b-0>li:before{content:"" counter(lst-ctn-kix_cgwr04oh042b-0,decimal) ". "}.lst-kix_dvm78mxbk83c-7>li{counter-increment:lst-ctn-kix_dvm78mxbk83c-7}.lst-kix_vo1hiqfr384s-6>li{counter-increment:lst-ctn-kix_vo1hiqfr384s-6}ol.lst-kix_dvm78mxbk83c-7{list-style-type:none}ol.lst-kix_dvm78mxbk83c-8{list-style-type:none}.lst-kix_vo1hiqfr384s-1>li:before{content:"" counter(lst-ctn-kix_vo1hiqfr384s-1,lower-roman) ". "}.lst-kix_y0svcngzxe8t-5>li{counter-increment:lst-ctn-kix_y0svcngzxe8t-5}.lst-kix_cgwr04oh042b-2>li:before{content:"" counter(lst-ctn-kix_cgwr04oh042b-2,lower-roman) ". "}ol.lst-kix_y0svcngzxe8t-5.start{counter-reset:lst-ctn-kix_y0svcngzxe8t-5 0}.lst-kix_dvm78mxbk83c-0>li:before{content:"" counter(lst-ctn-kix_dvm78mxbk83c-0,decimal) ". "}.lst-kix_sxb9z6pqma74-0>li{counter-increment:lst-ctn-kix_sxb9z6pqma74-0}.lst-kix_dvm78mxbk83c-2>li:before{content:"" counter(lst-ctn-kix_dvm78mxbk83c-2,lower-roman) ". "}.lst-kix_dvm78mxbk83c-1>li{counter-increment:lst-ctn-kix_dvm78mxbk83c-1}.lst-kix_cgwr04oh042b-4>li:before{content:"" counter(lst-ctn-kix_cgwr04oh042b-4,lower-latin) ". "}.lst-kix_cgwr04oh042b-8>li:before{content:"" counter(lst-ctn-kix_cgwr04oh042b-8,lower-roman) ". "}.lst-kix_sxb9z6pqma74-6>li{counter-increment:lst-ctn-kix_sxb9z6pqma74-6}.lst-kix_cgwr04oh042b-6>li:before{content:"" counter(lst-ctn-kix_cgwr04oh042b-6,decimal) ". "}.lst-kix_dvm78mxbk83c-0>li{counter-increment:lst-ctn-kix_dvm78mxbk83c-0}ol.lst-kix_y0svcngzxe8t-3.start{counter-reset:lst-ctn-kix_y0svcngzxe8t-3 0}.lst-kix_sxb9z6pqma74-5>li{counter-increment:lst-ctn-kix_sxb9z6pqma74-5}.lst-kix_se6fud6whwkx-2>li:before{content:"" counter(lst-ctn-kix_se6fud6whwkx-0,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-1,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-2,decimal) ". "}ol.lst-kix_cgwr04oh042b-7{list-style-type:none}ol.lst-kix_cgwr04oh042b-8{list-style-type:none}.lst-kix_se6fud6whwkx-3>li:before{content:"" counter(lst-ctn-kix_se6fud6whwkx-0,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-1,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-2,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-3,decimal) ". "}ol.lst-kix_y0svcngzxe8t-1{list-style-type:none}.lst-kix_se6fud6whwkx-5>li:before{content:"" counter(lst-ctn-kix_se6fud6whwkx-0,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-1,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-2,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-3,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-4,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-5,decimal) ". "}ol.lst-kix_cgwr04oh042b-1{list-style-type:none}ol.lst-kix_y0svcngzxe8t-0{list-style-type:none}ol.lst-kix_cgwr04oh042b-2{list-style-type:none}.lst-kix_se6fud6whwkx-4>li:before{content:"" counter(lst-ctn-kix_se6fud6whwkx-0,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-1,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-2,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-3,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-4,decimal) ". "}.lst-kix_se6fud6whwkx-6>li:before{content:"" counter(lst-ctn-kix_se6fud6whwkx-0,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-1,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-2,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-3,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-4,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-5,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-6,decimal) ". "}ol.lst-kix_cgwr04oh042b-0{list-style-type:none}ol.lst-kix_y0svcngzxe8t-5{list-style-type:none}ol.lst-kix_cgwr04oh042b-5{list-style-type:none}ol.lst-kix_y0svcngzxe8t-4{list-style-type:none}.lst-kix_se6fud6whwkx-6>li{counter-increment:lst-ctn-kix_se6fud6whwkx-6}ol.lst-kix_cgwr04oh042b-6{list-style-type:none}ol.lst-kix_y0svcngzxe8t-3{list-style-type:none}ol.lst-kix_cgwr04oh042b-3{list-style-type:none}ol.lst-kix_y0svcngzxe8t-2{list-style-type:none}ol.lst-kix_cgwr04oh042b-4{list-style-type:none}.lst-kix_vo1hiqfr384s-7>li:before{content:"" counter(lst-ctn-kix_vo1hiqfr384s-7,lower-roman) ". "}.lst-kix_se6fud6whwkx-8>li:before{content:"" counter(lst-ctn-kix_se6fud6whwkx-0,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-1,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-2,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-3,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-4,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-5,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-6,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-7,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-8,decimal) ". "}.lst-kix_se6fud6whwkx-7>li:before{content:"" counter(lst-ctn-kix_se6fud6whwkx-0,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-1,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-2,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-3,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-4,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-5,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-6,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-7,decimal) ". "}.lst-kix_vo1hiqfr384s-5>li:before{content:"" counter(lst-ctn-kix_vo1hiqfr384s-5,decimal) ". "}.lst-kix_vo1hiqfr384s-6>li:before{content:"" counter(lst-ctn-kix_vo1hiqfr384s-6,lower-latin) ". "}ol.lst-kix_sxb9z6pqma74-2.start{counter-reset:lst-ctn-kix_sxb9z6pqma74-2 0}.lst-kix_sxb9z6pqma74-7>li{counter-increment:lst-ctn-kix_sxb9z6pqma74-7}ol.lst-kix_y0svcngzxe8t-8{list-style-type:none}.lst-kix_vo1hiqfr384s-8>li:before{content:"" counter(lst-ctn-kix_vo1hiqfr384s-8,decimal) ". "}ol.lst-kix_y0svcngzxe8t-7{list-style-type:none}ol.lst-kix_cgwr04oh042b-6.start{counter-reset:lst-ctn-kix_cgwr04oh042b-6 0}ol.lst-kix_y0svcngzxe8t-6{list-style-type:none}.lst-kix_dvm78mxbk83c-2>li{counter-increment:lst-ctn-kix_dvm78mxbk83c-2}.lst-kix_cgwr04oh042b-0>li{counter-increment:lst-ctn-kix_cgwr04oh042b-0}ol.lst-kix_dvm78mxbk83c-5.start{counter-reset:lst-ctn-kix_dvm78mxbk83c-5 0}ol.lst-kix_cgwr04oh042b-0.start{counter-reset:lst-ctn-kix_cgwr04oh042b-0 0}.lst-kix_se6fud6whwkx-8>li{counter-increment:lst-ctn-kix_se6fud6whwkx-8}ul.lst-kix_k60se73x99eg-8{list-style-type:none}ol.lst-kix_y0svcngzxe8t-8.start{counter-reset:lst-ctn-kix_y0svcngzxe8t-8 0}ul.lst-kix_k60se73x99eg-6{list-style-type:none}ul.lst-kix_k60se73x99eg-7{list-style-type:none}ul.lst-kix_k60se73x99eg-4{list-style-type:none}ul.lst-kix_k60se73x99eg-5{list-style-type:none}.lst-kix_vo1hiqfr384s-8>li{counter-increment:lst-ctn-kix_vo1hiqfr384s-8}ul.lst-kix_k60se73x99eg-2{list-style-type:none}ul.lst-kix_k60se73x99eg-3{list-style-type:none}ul.lst-kix_k60se73x99eg-0{list-style-type:none}ul.lst-kix_k60se73x99eg-1{list-style-type:none}.lst-kix_y0svcngzxe8t-0>li{counter-increment:lst-ctn-kix_y0svcngzxe8t-0}ol.lst-kix_se6fud6whwkx-3.start{counter-reset:lst-ctn-kix_se6fud6whwkx-3 0}ol.lst-kix_cgwr04oh042b-1.start{counter-reset:lst-ctn-kix_cgwr04oh042b-1 0}.lst-kix_y0svcngzxe8t-7>li{counter-increment:lst-ctn-kix_y0svcngzxe8t-7}ol.lst-kix_y0svcngzxe8t-2.start{counter-reset:lst-ctn-kix_y0svcngzxe8t-2 0}ol.lst-kix_dvm78mxbk83c-6.start{counter-reset:lst-ctn-kix_dvm78mxbk83c-6 0}ol.lst-kix_se6fud6whwkx-4.start{counter-reset:lst-ctn-kix_se6fud6whwkx-4 0}.lst-kix_vo1hiqfr384s-1>li{counter-increment:lst-ctn-kix_vo1hiqfr384s-1}.lst-kix_cgwr04oh042b-7>li{counter-increment:lst-ctn-kix_cgwr04oh042b-7}.lst-kix_se6fud6whwkx-1>li:before{content:"" counter(lst-ctn-kix_se6fud6whwkx-0,decimal) "." counter(lst-ctn-kix_se6fud6whwkx-1,decimal) ". "}ol.lst-kix_sxb9z6pqma74-3.start{counter-reset:lst-ctn-kix_sxb9z6pqma74-3 0}ol.lst-kix_dvm78mxbk83c-0.start{counter-reset:lst-ctn-kix_dvm78mxbk83c-0 0}.lst-kix_se6fud6whwkx-0>li:before{content:"" counter(lst-ctn-kix_se6fud6whwkx-0,decimal) ". "}.lst-kix_sxb9z6pqma74-8>li:before{content:"" counter(lst-ctn-kix_sxb9z6pqma74-8,decimal) ". "}.lst-kix_dvm78mxbk83c-7>li:before{content:"" counter(lst-ctn-kix_dvm78mxbk83c-7,lower-latin) ". "}.lst-kix_dvm78mxbk83c-5>li:before{content:"" counter(lst-ctn-kix_dvm78mxbk83c-5,lower-roman) ". "}.lst-kix_y0svcngzxe8t-3>li{counter-increment:lst-ctn-kix_y0svcngzxe8t-3}.lst-kix_sxb9z6pqma74-4>li:before{content:"" counter(lst-ctn-kix_sxb9z6pqma74-4,lower-roman) ". "}.lst-kix_dvm78mxbk83c-3>li:before{content:"" counter(lst-ctn-kix_dvm78mxbk83c-3,decimal) ". "}ol.lst-kix_cgwr04oh042b-7.start{counter-reset:lst-ctn-kix_cgwr04oh042b-7 0}.lst-kix_sxb9z6pqma74-2>li:before{content:"" counter(lst-ctn-kix_sxb9z6pqma74-2,decimal) ". "}.lst-kix_sxb9z6pqma74-0>li:before{content:"" counter(lst-ctn-kix_sxb9z6pqma74-0,lower-latin) ". "}.lst-kix_y0svcngzxe8t-8>li:before{content:"" counter(lst-ctn-kix_y0svcngzxe8t-8,decimal) ". "}.lst-kix_y0svcngzxe8t-6>li:before{content:"" counter(lst-ctn-kix_y0svcngzxe8t-6,lower-latin) ". "}.lst-kix_vo1hiqfr384s-4>li{counter-increment:lst-ctn-kix_vo1hiqfr384s-4}ol.lst-kix_cgwr04oh042b-4.start{counter-reset:lst-ctn-kix_cgwr04oh042b-4 0}ol.lst-kix_dvm78mxbk83c-1.start{counter-reset:lst-ctn-kix_dvm78mxbk83c-1 0}.lst-kix_y0svcngzxe8t-2>li:before{content:"" counter(lst-ctn-kix_y0svcngzxe8t-2,decimal) ". "}ol.lst-kix_vo1hiqfr384s-2.start{counter-reset:lst-ctn-kix_vo1hiqfr384s-2 0}.lst-kix_y0svcngzxe8t-4>li:before{content:"" counter(lst-ctn-kix_y0svcngzxe8t-4,lower-roman) ". "}ol.lst-kix_se6fud6whwkx-8.start{counter-reset:lst-ctn-kix_se6fud6whwkx-8 0}.lst-kix_dvm78mxbk83c-5>li{counter-increment:lst-ctn-kix_dvm78mxbk83c-5}ol.lst-kix_vo1hiqfr384s-5.start{counter-reset:lst-ctn-kix_vo1hiqfr384s-5 0}.lst-kix_sxb9z6pqma74-6>li:before{content:"" counter(lst-ctn-kix_sxb9z6pqma74-6,lower-latin) ". "}.lst-kix_cgwr04oh042b-3>li{counter-increment:lst-ctn-kix_cgwr04oh042b-3}.lst-kix_y0svcngzxe8t-0>li:before{content:"" counter(lst-ctn-kix_y0svcngzxe8t-0,lower-latin) ". "}ol.lst-kix_se6fud6whwkx-5.start{counter-reset:lst-ctn-kix_se6fud6whwkx-5 0}.lst-kix_se6fud6whwkx-4>li{counter-increment:lst-ctn-kix_se6fud6whwkx-4}.lst-kix_cgwr04oh042b-2>li{counter-increment:lst-ctn-kix_cgwr04oh042b-2}ol.lst-kix_cgwr04oh042b-5.start{counter-reset:lst-ctn-kix_cgwr04oh042b-5 0}.lst-kix_cgwr04oh042b-8>li{counter-increment:lst-ctn-kix_cgwr04oh042b-8}ol.lst-kix_se6fud6whwkx-7.start{counter-reset:lst-ctn-kix_se6fud6whwkx-7 0}ol.lst-kix_sxb9z6pqma74-1.start{counter-reset:lst-ctn-kix_sxb9z6pqma74-1 0}ol.lst-kix_sxb9z6pqma74-5{list-style-type:none}ol.lst-kix_sxb9z6pqma74-6{list-style-type:none}ol.lst-kix_sxb9z6pqma74-7{list-style-type:none}ol.lst-kix_sxb9z6pqma74-8{list-style-type:none}ol.lst-kix_sxb9z6pqma74-1{list-style-type:none}ol.lst-kix_sxb9z6pqma74-2{list-style-type:none}ol.lst-kix_sxb9z6pqma74-3{list-style-type:none}ol.lst-kix_sxb9z6pqma74-4{list-style-type:none}ol.lst-kix_dvm78mxbk83c-4.start{counter-reset:lst-ctn-kix_dvm78mxbk83c-4 0}ol.lst-kix_vo1hiqfr384s-4.start{counter-reset:lst-ctn-kix_vo1hiqfr384s-4 0}ol.lst-kix_sxb9z6pqma74-0{list-style-type:none}.lst-kix_vo1hiqfr384s-4>li:before{content:"" counter(lst-ctn-kix_vo1hiqfr384s-4,lower-roman) ". "}ol.lst-kix_se6fud6whwkx-6.start{counter-reset:lst-ctn-kix_se6fud6whwkx-6 0}.lst-kix_dvm78mxbk83c-4>li{counter-increment:lst-ctn-kix_dvm78mxbk83c-4}.lst-kix_y0svcngzxe8t-2>li{counter-increment:lst-ctn-kix_y0svcngzxe8t-2}.lst-kix_vo1hiqfr384s-0>li:before{content:"" counter(lst-ctn-kix_vo1hiqfr384s-0,lower-latin) ". "}.lst-kix_cgwr04oh042b-1>li:before{content:"" counter(lst-ctn-kix_cgwr04oh042b-1,lower-latin) ". "}.lst-kix_y0svcngzxe8t-8>li{counter-increment:lst-ctn-kix_y0svcngzxe8t-8}.lst-kix_vo1hiqfr384s-2>li:before{content:"" counter(lst-ctn-kix_vo1hiqfr384s-2,decimal) ". "}.lst-kix_vo1hiqfr384s-3>li{counter-increment:lst-ctn-kix_vo1hiqfr384s-3}li.li-bullet-0:before{margin-left:-18pt;white-space:nowrap;display:inline-block;min-width:18pt}.lst-kix_cgwr04oh042b-3>li:before{content:"" counter(lst-ctn-kix_cgwr04oh042b-3,decimal) ". "}.lst-kix_cgwr04oh042b-5>li:before{content:"" counter(lst-ctn-kix_cgwr04oh042b-5,lower-roman) ". "}.lst-kix_sxb9z6pqma74-3>li{counter-increment:lst-ctn-kix_sxb9z6pqma74-3}.lst-kix_dvm78mxbk83c-1>li:before{content:"" counter(lst-ctn-kix_dvm78mxbk83c-1,lower-latin) ". "}ol.lst-kix_se6fud6whwkx-0{list-style-type:none}ol.lst-kix_dvm78mxbk83c-3.start{counter-reset:lst-ctn-kix_dvm78mxbk83c-3 0}ol.lst-kix_se6fud6whwkx-3{list-style-type:none}ol.lst-kix_se6fud6whwkx-4{list-style-type:none}ol.lst-kix_vo1hiqfr384s-3.start{counter-reset:lst-ctn-kix_vo1hiqfr384s-3 0}ol.lst-kix_sxb9z6pqma74-0.start{counter-reset:lst-ctn-kix_sxb9z6pqma74-0 0}ol.lst-kix_se6fud6whwkx-1{list-style-type:none}ol.lst-kix_se6fud6whwkx-2{list-style-type:none}.lst-kix_cgwr04oh042b-7>li:before{content:"" counter(lst-ctn-kix_cgwr04oh042b-7,lower-latin) ". "}ol.lst-kix_se6fud6whwkx-7{list-style-type:none}ol.lst-kix_se6fud6whwkx-8{list-style-type:none}ol.lst-kix_se6fud6whwkx-5{list-style-type:none}ol.lst-kix_se6fud6whwkx-6{list-style-type:none}ol{margin:0;padding:0}table td,table th{padding:0}.c7{-webkit-text-decoration-skip:none;color:#000000;font-weight:700;text-decoration:underline;vertical-align:baseline;text-decoration-skip-ink:none;font-size:13pt;font-family:"Open Sans";font-style:normal}.c3{margin-left:-0.8pt;padding-top:10pt;padding-bottom:0pt;line-height:1.5;orphans:2;widows:2;text-align:left;height:11pt}.c41{margin-left:-0.8pt;padding-top:24pt;padding-bottom:0pt;line-height:1.0;orphans:2;widows:2;text-align:left;margin-right:89.2pt}.c2{margin-left:-0.8pt;padding-top:10pt;text-indent:0.8pt;padding-bottom:0pt;line-height:1.5;orphans:2;widows:2;text-align:left}.c21{-webkit-text-decoration-skip:none;color:#000000;text-decoration:underline;vertical-align:baseline;text-decoration-skip-ink:none;font-size:11pt;font-family:"Open Sans";font-style:normal}.c5{margin-left:36pt;padding-top:0pt;padding-bottom:0pt;line-height:1.0;orphans:2;widows:2;text-align:left}.c37{color:#999999;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:14pt;font-family:"Economica";font-style:normal}.c34{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:10pt;font-family:"Open Sans";font-style:normal}.c18{margin-left:-0.8pt;padding-top:0pt;padding-bottom:0pt;line-height:1.0;orphans:2;widows:2;text-align:left}.c17{margin-left:72pt;padding-top:10pt;padding-bottom:0pt;line-height:2.0;orphans:2;widows:2;text-align:left}.c8{margin-left:-0.8pt;padding-top:10pt;padding-bottom:0pt;line-height:1.5;orphans:2;widows:2;text-align:left}.c1{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:11pt;font-family:"Open Sans";font-style:normal}.c38{color:#666666;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:14pt;font-family:"Economica";font-style:normal}.c0{color:#000000;font-weight:700;text-decoration:none;vertical-align:baseline;font-size:11pt;font-family:"Open Sans";font-style:italic}.c20{margin-left:-0.8pt;padding-top:0pt;padding-bottom:0pt;line-height:1.5;orphans:2;widows:2;text-align:left}.c28{margin-left:-0.8pt;padding-top:6pt;padding-bottom:0pt;line-height:1.5;orphans:2;widows:2;text-align:left}.c12{padding-top:10pt;padding-left:0pt;padding-bottom:0pt;line-height:1.5;orphans:2;widows:2;text-align:left}.c27{margin-left:-0.8pt;padding-top:3pt;padding-bottom:0pt;line-height:1.5;orphans:2;widows:2;text-align:left}.c4{color:#000000;font-weight:700;text-decoration:none;vertical-align:baseline;font-size:16pt;font-family:"Open Sans";font-style:normal}.c23{padding-top:10pt;padding-bottom:0pt;line-height:2.0;orphans:2;widows:2;text-align:left}.c19{color:#000000;font-weight:400;text-decoration:none;vertical-align:baseline;font-size:11pt;font-family:"Open Sans"}.c22{padding-top:10pt;padding-bottom:0pt;line-height:1.5;orphans:2;widows:2;text-align:left}.c39{color:#000000;text-decoration:none;vertical-align:baseline;font-size:11pt;font-family:"Open Sans";font-style:normal}.c35{padding-top:0pt;padding-bottom:0pt;line-height:1.0;orphans:2;widows:2;text-align:left}.c32{padding-top:0pt;padding-bottom:0pt;line-height:2.0;orphans:2;widows:2;text-align:left}.c30{color:#000000;text-decoration:none;vertical-align:baseline;font-size:30pt;font-family:"Economica";font-style:normal}.c6{padding-top:10pt;padding-bottom:0pt;line-height:1.0;orphans:2;widows:2;text-align:left}.c29{text-decoration-skip-ink:none;-webkit-text-decoration-skip:none;text-decoration:underline}.c25{background-color:#ffffff;max-width:504pt;padding:72pt 72pt 72pt 36pt}.c10{padding:0;margin:0}.c24{color:inherit;text-decoration:inherit}.c40{color:#000000;font-size:30pt}.c15{height:16pt}.c26{font-size:16pt}.c13{font-weight:700}.c9{margin-left:36pt}.c14{padding-left:0pt}.c36{text-indent:0.8pt}.c33{font-size:13pt}.c31{color:#1155cc}.c16{height:11pt}.c11{font-style:italic}.title{padding-top:0pt;color:#000000;font-size:30pt;padding-bottom:0pt;font-family:"Economica";line-height:1.0;orphans:2;widows:2;text-align:left}.subtitle{padding-top:0pt;color:#999999;font-size:14pt;padding-bottom:0pt;font-family:"Economica";line-height:1.0;orphans:2;widows:2;text-align:left}li{color:#000000;font-size:11pt;font-family:"Open Sans"}p{margin:0;color:#000000;font-size:11pt;font-family:"Open Sans"}h1{padding-top:10pt;color:#000000;font-weight:700;font-size:16pt;padding-bottom:0pt;font-family:"Open Sans";line-height:1.5;orphans:2;widows:2;text-align:left}h2{padding-top:24pt;color:#000000;font-weight:700;font-size:13pt;padding-bottom:0pt;font-family:"Open Sans";line-height:1.0;orphans:2;widows:2;text-align:left}h3{padding-top:10pt;color:#8c7252;font-weight:700;font-size:12pt;padding-bottom:0pt;font-family:"Open Sans";line-height:1.5;orphans:2;widows:2;text-align:left}h4{padding-top:8pt;-webkit-text-decoration-skip:none;color:#666666;text-decoration:underline;font-size:11pt;padding-bottom:0pt;line-height:1.5;page-break-after:avoid;text-decoration-skip-ink:none;font-family:"Trebuchet MS";orphans:2;widows:2;text-align:left}h5{padding-top:8pt;color:#666666;font-size:11pt;padding-bottom:0pt;font-family:"Trebuchet MS";line-height:1.5;page-break-after:avoid;orphans:2;widows:2;text-align:left}h6{padding-top:8pt;color:#666666;font-size:11pt;padding-bottom:0pt;font-family:"Trebuchet MS";line-height:1.5;page-break-after:avoid;font-style:italic;orphans:2;widows:2;text-align:left}</style></head><body class="c25 doc-content"><div><p class="c3"><span class="c1"></span></p><p class="c18"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 624.00px; height: 2.67px;"><img alt="" src="images/image7.png" style="width: 624.00px; height: 2.67px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title="horizontal line"></span></p></div><p class="c18"><span class="c38">DATA ANALYST 3 - ADVANCED SQL</span></p><p class="c35 c36 title" id="h.mbjsiz6n6jlo"><span class="c13">PROJECT PORTFOLIO REPORT</span></p><p class="c18 subtitle" id="h.vb8p0lepu9vn"><span class="c40">BY HENRY UGOCHUKWU OKAM</span></p><p class="c27"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 624.00px; height: 4.00px;"><img alt="" src="images/image16.png" style="width: 624.00px; height: 4.00px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title="horizontal line"></span></p><h1 class="c28" id="h.vydniszftb1n"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 612.00px; height: 408.00px;"><img alt="" src="images/image8.jpg" style="width: 612.00px; height: 408.00px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></h1><h1 class="c8 c15" id="h.arolcxe0i15c"><span class="c4"></span></h1><h1 class="c8 c15" id="h.gh1kb26kyyu"><span class="c4"></span></h1><h1 class="c8 c15" id="h.36mro0gainnz"><span class="c4"></span></h1><h1 class="c15 c22" id="h.kgoe0pes9dw"><span class="c1"></span></h1><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><h1 class="c22" id="h.6tdp85gik5ai"><span class="c4">Table of Contents</span></h1><ol class="c10 lst-kix_se6fud6whwkx-0 start" start="1"><li class="c23 c9 c14 li-bullet-0"><h1 id="h.lj4o8bmj3s7c" style="display:inline"><span class="c1">Introduction/Project background ……………………………………………………………………………… 3</span></h1></li><li class="c23 c9 c14 li-bullet-0"><h1 id="h.cuhmmlavj96l" style="display:inline"><span class="c1">Root cause analysis process………………………………………………………………………………………. 4</span></h1></li><li class="c9 c14 c23 li-bullet-0"><h1 id="h.ltzelrns6vh0" style="display:inline"><span class="c1">Insights from the dataset…………………………………………………………………………………………… 5 </span></h1></li></ol><ol class="c10 lst-kix_sxb9z6pqma74-0 start" start="1"><li class="c17 c14 li-bullet-0"><h1 id="h.pbl5ce4yw36r" style="display:inline"><span class="c1">SQL Codes Utilized………………………………………………………………………………………….. 5</span></h1></li><li class="c17 c14 li-bullet-0"><h1 id="h.n2p7zohrqo60" style="display:inline"><span class="c1">Key Insights…………………………………………………………………………………………………….. 8</span></h1></li></ol><ol class="c10 lst-kix_se6fud6whwkx-0" start="4"><li class="c23 c9 c14 li-bullet-0"><h1 id="h.w4zaccott7qi" style="display:inline"><span class="c1">Visualizations of these insights………………………………………………………………………………..… 10</span></h1></li></ol><ol class="c10 lst-kix_vo1hiqfr384s-0 start" start="1"><li class="c14 c17 li-bullet-0"><span class="c1">Reporting Dashboard…………………………………………………………………………………….. 17</span></li></ol><ol class="c10 lst-kix_se6fud6whwkx-0" start="5"><li class="c23 c9 c14 li-bullet-0"><h1 id="h.vwxl68gnbgtz" style="display:inline"><span class="c1">Important findings and recommendations to solve the business problem………….…… 18</span></h1></li><li class="c23 c9 c14 li-bullet-0"><h1 id="h.5rt1f222z49d" style="display:inline"><span class="c1">Conclusion……………………………………………………………………..…………………………………………..19</span></h1></li></ol><h1 class="c8 c15" id="h.zderdvigf8yv"><span class="c4"></span></h1><h1 class="c8 c15" id="h.oah1uv244ciw"><span class="c4"></span></h1><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><h1 class="c8" id="h.d8ux7vglhish"><span>Introduction to the dataset</span></h1><p class="c2"><span class="c1">The objective of this project is to evaluate the factors affecting students educational performance.</span></p><p class="c2"><span>In order to realize this objective, four csv </span><span class="c29 c31"><a class="c24" href="https://www.google.com/url?q=https://content.cloudfront.entrylevel.net/experience/data3/module-4/Module%2B4%2B-%2BTask%2BFiles.zip?_gl%3D1*pfl0lt*_ga*MTkwNzE2MzgwOC4xNjY2NzE1NTk0*_ga_8RTQ11GGMX*MTY3MDgwMTEyMS44OC4xLjE2NzA4MDUzNzcuNjAuMC4w&sa=D&source=editors&ust=1671715328057571&usg=AOvVaw3zJL1bGIy6wcFem-3gHtyd">files</a></span><span> were provided by </span><span class="c11">Entry Level</span><span class="c1"> for the purpose of this report. The four csv files contain data about the country info, student academic info, student family details and student personal details respectively for 4739 unique student id. These four files which are related contains key columns names such as :</span></p><p class="c2"><span class="c13 c11">gender</span><span class="c1">: factor indicating gender.</span></p><p class="c2"><span class="c13 c11">ethnicity</span><span class="c1">: factor indicating ethnicity (African-American, Hispanic, Asian or other).</span></p><p class="c2"><span class="c13 c11">academic_score</span><span class="c1">: student’s academic score throughout high school and college</span></p><p class="c2"><span class="c13 c11">student_tuition</span><span class="c1">: cost of tuition for the student</span></p><p class="c2"><span class="c13 c11">education</span><span class="c1">: the years of education the student has received</span></p><p class="c2"><span class="c13 c11">fcollege</span><span class="c1">: factor. Is the father a college graduate?</span></p><p class="c2"><span class="c13 c11">mcollege</span><span class="c1">: factor. Is the mother a college graduate?</span></p><p class="c2"><span class="c13 c11">home</span><span class="c1">: factor. Does the family own their home?</span></p><p class="c2"><span class="c13 c11">urban</span><span class="c1">: factor. Is the school in an urban area?</span></p><p class="c2"><span class="c13 c11">unemp</span><span class="c1">: county unemployment rate in 2020</span></p><p class="c2"><span class="c13 c11">income</span><span class="c1">: high or low income household based on county average</span></p><p class="c2"><span class="c13 c11">wage</span><span class="c1">: state hourly wage in manufacturing in 1980</span></p><p class="c2"><span class="c13 c11">distance</span><span class="c1">: distance from 4-year college (in 10 miles)</span></p><p class="c2"><span class="c13 c11">region</span><span class="c1">: factor indicating region (West, East or other)</span></p><p class="c2"><span class="c13 c11">avg_county_tuition</span><span class="c1">: average state 4-year college tuition (in 1000 USD)</span></p><p class="c2"><span>After data collection, all four csv files were imported into </span><span class="c11">sqlite online</span><span> and combined to form one reporting table known as </span><span class="c11">reports_student_colleges</span><span> with a total of 37,997 student records. It was observed that there is a one to many relationship between the </span><span class="c11">student_personal_details</span><span class="c1"> table which contained unique student records and the other three tables when combined. </span></p><p class="c2"><span>From the </span><span class="c11">reports_student_colleges</span><span> table, several tables were further created using SQL queries for the purpose of answering our research questions. These tables were then exported to google sheets, further wrangled , then used to create compelling visualizations to give insights to the problem statement.</span></p><h2 class="c41" id="h.la5jp5tnimjw"><span class="c26">Root Cause Analysis Process</span></h2><p class="c8"><span class="c1">In order to ascertain the varying factors that may have an effect on a student’s academic performance , the following questions were asked of our data.</span></p><ol class="c10 lst-kix_dvm78mxbk83c-0 start" start="1"><li class="c12 c9 li-bullet-0"><span class="c1">What are the proportion of educated students by ethnicity</span></li><li class="c12 c9 li-bullet-0"><span class="c1">How can we evaluate the Cost of college tuition against household income</span></li><li class="c12 c9 li-bullet-0"><span class="c1">What is the effect of a student's parents education on the education of the student</span></li><li class="c12 c9 li-bullet-0"><span class="c1">Is location of school a determinant on tuition </span></li><li class="c9 c12 li-bullet-0"><span class="c1">What is the differences in student's performance with respect to where the school is location</span></li><li class="c12 c9 li-bullet-0"><span class="c1">Which ethnic group has a higher performance rate in schools and which gender performs better on average?</span></li><li class="c12 c9 li-bullet-0"><span class="c1">Does the age of a student have an effect on their academic performance in school?</span></li></ol><p class="c8"><span>In order to answer these questions and for the purpose of this analysis, some assumptions were made. One is that the student data collected represents sample data for high schools/colleges in the United State of America (USA). This is due to the diversity and multicultural nature of the USA student community. We also assumed that academic scores greater than or equal to 50% would be deemed as a ‘pass’ while academic scores less than 50% would be deemed as a ‘fail’ for the purpose of this study. And lastly we assumed that the </span><span class="c13 c11">education</span><span class="c1"> variable indicates the years of education received by the student since birth.</span></p><p class="c3"><span class="c1"></span></p><p class="c8"><span class="c4">Insights from the dataset</span></p><p class="c8"><span class="c13 c33">a) </span><span class="c13 c33">SQL Codes Utilized</span></p><p class="c6"><span class="c21 c13">TABLE 1 </span></p><p class="c6"><span class="c0">Combining all tables to create reporting table called reports_student_colleges</span></p><p class="c6"><span class="c1">CREATE TABLE reports_student_colleges AS </span></p><p class="c6"><span class="c1">SELECT student_personal_details.id AS id,</span></p><p class="c6"><span class="c1"> , gender</span></p><p class="c6"><span class="c1"> , DOB</span></p><p class="c6"><span class="c1"> , ethnicity</span></p><p class="c6"><span class="c1"> , academic_score</span></p><p class="c6"><span class="c1"> , student_tuition </span></p><p class="c6"><span class="c1"> , education</span></p><p class="c6"><span class="c1"> ,unemp</span></p><p class="c6"><span class="c1"> ,wage</span></p><p class="c6"><span class="c1"> ,distance</span></p><p class="c6"><span class="c1"> ,region</span></p><p class="c6"><span class="c1"> ,avg_county_tuition</span></p><p class="c6"><span class="c1"> ,fcollege</span></p><p class="c6"><span class="c1"> ,mcollege</span></p><p class="c6"><span class="c1"> ,home</span></p><p class="c6"><span class="c1"> ,urban</span></p><p class="c6"><span class="c1"> ,income </span></p><p class="c6"><span class="c1">FROM student_personal_details </span></p><p class="c6"><span class="c1"> LEFT JOIN student_academic_info </span></p><p class="c6"><span class="c1"> ON student_personal_details.academic_info_id = student_academic_info.id </span></p><p class="c6"><span class="c1"> LEFT JOIN county_info </span></p><p class="c6"><span class="c1"> ON student_personal_details.county_id = county_info.id </span></p><p class="c6"><span class="c1"> LEFT JOIN student_family_details </span></p><p class="c6"><span class="c1"> ON student_personal_details.family_details_id = student_family_details.id </span></p><p class="c6"><span class="c1">ORDER BY 1; </span></p><p class="c6 c16"><span class="c1"></span></p><p class="c6"><span class="c29 c13">TABLE 2</span><span class="c1"> </span></p><p class="c6"><span class="c0">What is the proportion of educated students by ethnicity ?</span></p><p class="c6"><span class="c1">CREATE TABLE education_by_ethnicity AS </span></p><p class="c6"><span class="c1">SELECT COUNT(id) AS no_of_student </span></p><p class="c6"><span class="c1"> , ethnicity </span></p><p class="c6"><span class="c1"> , AVG(education) AS avg_education </span></p><p class="c6"><span class="c1"> , AVG(academic_score)AS avg_academic_score </span></p><p class="c6"><span class="c1">FROM reports_student_colleges </span></p><p class="c6"><span class="c1">GROUP BY 2 </span></p><p class="c6"><span class="c1"> </span></p><p class="c6"><span class="c29 c13">TABLE 3</span><span class="c1"> </span></p><p class="c6"><span class="c0">How can we evaluate the Cost of college tuition against household income ?</span></p><p class="c6"><span class="c1">CREATE TABLE tuition_by_income AS </span></p><p class="c6"><span class="c1">SELECT count(*) AS student_count </span></p><p class="c6"><span class="c1"> , AVG(student_tuition) AS avg_student_tuition </span></p><p class="c6"><span class="c1"> , AVG(avg_county_tuition) as avg_county_tuition </span></p><p class="c6"><span class="c1"> , income </span></p><p class="c6"><span class="c1">FROM reports_student_colleges </span></p><p class="c6"><span class="c1">GROUP BY 4 </span></p><p class="c6"><span class="c1">ORDER BY 1 DESC; </span></p><p class="c6"><span class="c1"> </span></p><p class="c6"><span class="c29 c13">TABLE 4</span><span class="c1"> </span></p><p class="c6"><span class="c0">What is the effect of a student's parents' education on the education of the student ?</span></p><p class="c6"><span class="c1">CREATE TABLE education_status AS </span></p><p class="c6"><span class="c1">SELECT COUNT (DISTINCT ID) as student_id_count </span></p><p class="c6"><span class="c1"> , AVG(academic_score) AS avg_score </span></p><p class="c6"><span class="c1"> , AVG(education) AS avg_education </span></p><p class="c6"><span class="c1"> , fcollege </span></p><p class="c6"><span class="c1"> , mcollege </span></p><p class="c6"><span class="c1">FROM reports_student_colleges </span></p><p class="c6"><span class="c1">GROUP BY 4,5 </span></p><p class="c6"><span class="c1">ORDER BY 1,2,3; </span></p><p class="c6"><span class="c1"> </span></p><p class="c6"><span class="c13 c29">TABLE 5</span><span class="c13 c39"> </span></p><p class="c6"><span class="c0">-Is location of school a determinant on tuition ?</span></p><p class="c6"><span class="c0">-What are the differences in a student's performance with respect to where the school is located ?</span></p><p class="c6 c16"><span class="c19 c11"></span></p><p class="c6"><span class="c1">CREATE TABLE school_location_report AS </span></p><p class="c6"><span class="c1">SELECT AVG(academic_score) AS academic_score </span></p><p class="c6"><span class="c1"> , region </span></p><p class="c6"><span class="c1"> , urban </span></p><p class="c6"><span class="c1"> , AVG(student_tuition) AS student_tuition </span></p><p class="c6"><span class="c1"> , AVG(avg_county_tuition) AS avg_county_tuition </span></p><p class="c6"><span class="c1">FROM reports_student_colleges </span></p><p class="c6"><span class="c1">GROUP BY 2,3 </span></p><p class="c6"><span class="c1"> </span></p><p class="c6"><span class="c13 c21">TABLE 6 </span></p><p class="c6"><span class="c0">Which ethnic group has a higher performance rate in schools and which gender performs better on average?</span></p><p class="c6"><span class="c1">CREATE TABLE ethnic_gender_report AS </span></p><p class="c6"><span class="c1">SELECT ethnicity </span></p><p class="c6"><span class="c1"> , gender </span></p><p class="c6"><span class="c1"> , AVG(academic_score) AS academic_score_by_ethnicity </span></p><p class="c6"><span class="c1">FROM reports_student_colleges </span></p><p class="c6"><span class="c1">GROUP BY 1,2; </span></p><p class="c6"><span class="c1"> </span></p><p class="c6"><span class="c21 c13">TABLE 7 </span></p><p class="c6"><span class="c0">Does the age of a student have an effect on their academic performance in school?</span></p><p class="c6"><span class="c1">CREATE TABLE students_status_by_age </span></p><p class="c6"><span class="c1">SELECT id </span></p><p class="c6"><span class="c1"> , dob </span></p><p class="c6"><span class="c1"> , strftime('%Y','now') AS current_year </span></p><p class="c6"><span class="c1"> , academic_score </span></p><p class="c6"><span class="c1"> , CASE WHEN academic_score >= 50 then 'Pass' </span></p><p class="c6"><span class="c1"> ELSE 'Fail' END AS grade </span></p><p class="c6"><span class="c1">FROM reports_student_colleges;</span></p><p class="c6 c16"><span class="c1"></span></p><p class="c6"><span class="c13 c33">b) Key Insights</span><span class="c34"> </span></p><ul class="c10 lst-kix_k60se73x99eg-0 start"><li class="c6 c9 c14 li-bullet-0"><span class="c1">The African American students are the least represented while the 'other' category of students are the most represented in our student's sample. </span></li><li class="c6 c9 c14 li-bullet-0"><span class="c1">Average number of years spent by students in school is 14 years for students of all ethnicities. </span></li></ul><p class="c5"><span class="c1"> </span></p><ul class="c10 lst-kix_k60se73x99eg-0"><li class="c5 c14 li-bullet-0"><span class="c1">There was no considerable effect of a student's age on their academic scores. </span></li><li class="c6 c9 c14 li-bullet-0"><span class="c1">Students from high income homes pay on average slightly higher student tuition (0.72% higher) than those from low income homes.</span></li></ul><p class="c5"><span class="c1"> </span></p><ul class="c10 lst-kix_k60se73x99eg-0"><li class="c6 c9 c14 li-bullet-0"><span class="c1">Students from high incomes homes pay a country tuition of averagely 1.23% higher than those from low-income homes</span></li></ul><p class="c5"><span class="c1"> </span></p><ul class="c10 lst-kix_k60se73x99eg-0"><li class="c5 c14 li-bullet-0"><span class="c1">There is no considerable effect of parents education on the education of the student </span></li><li class="c6 c9 c14 li-bullet-0"><span class="c1">Student who have both parents educated perform better in academic scores and have more years of education than those with both or either parent uneducated </span></li><li class="c6 c9 c14 li-bullet-0"><span class="c1">Students with both parents not educated perform the least in academic scores and have lesser years of education than those with both or either parents educated </span></li><li class="c6 c9 c14 li-bullet-0"><span class="c1">Average country tuition for the western region of the country is very much lower than other regions of the country.</span></li></ul><p class="c5"><span class="c1"> </span></p><ul class="c10 lst-kix_k60se73x99eg-0"><li class="c5 c14 li-bullet-0"><span class="c1">There is no considerable difference in academic scores of students in the different regions/settlement type </span></li></ul><p class="c5"><span class="c1"> </span></p><ul class="c10 lst-kix_k60se73x99eg-0"><li class="c5 c14 li-bullet-0"><span class="c1">Average academic scores per student across all region is 51% </span></li><li class="c6 c9 c14 li-bullet-0"><span class="c1">Male students on average have better academic scores than female students </span></li><li class="c6 c9 c14 li-bullet-0"><span class="c1">In terms of academic performance, Asians rank better than all other ethnic groups in the country.</span></li></ul><p class="c16 c35"><span class="c1"></span></p><ul class="c10 lst-kix_k60se73x99eg-0"><li class="c6 c9 c14 li-bullet-0"><span class="c1">A plot of academic scores for all students shows a symmetrical distribution </span></li><li class="c6 c9 c14 li-bullet-0"><span class="c1">More students have an academic score of 56% than any other score. </span></li><li class="c6 c9 c14 li-bullet-0"><span class="c1">Lowest academic score of any student is 29% and highest of any student is 73%.</span></li></ul><p class="c5 c16"><span class="c1"></span></p><ul class="c10 lst-kix_k60se73x99eg-0"><li class="c6 c9 c14 li-bullet-0"><span class="c1">51.5% of all students passed (scored greater than or equal to 50) whilst 48.5% of all students failed (scored less than 50). </span></li></ul><p class="c6 c9 c16"><span class="c1"></span></p><p class="c6 c9 c16"><span class="c1"></span></p><p class="c6 c9 c16"><span class="c1"></span></p><p class="c6 c9 c16"><span class="c1"></span></p><p class="c6 c9 c16"><span class="c1"></span></p><p class="c6 c9 c16"><span class="c1"></span></p><p class="c6 c9 c16"><span class="c1"></span></p><p class="c6 c9"><span> </span></p><p class="c8"><span class="c13 c26">Visualizations</span><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 615.00px; height: 353.50px;"><img alt="" src="images/image15.png" style="width: 615.00px; height: 353.50px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c3"><span class="c4"></span></p><p class="c6"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 618.00px; height: 313.17px;"><img alt="" src="images/image5.png" style="width: 618.00px; height: 313.17px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c3"><span class="c4"></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 634.00px; height: 367.50px;"><img alt="" src="images/image6.png" style="width: 634.00px; height: 367.50px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c3"><span class="c4"></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 600.00px; height: 371.00px;"><img alt="" src="images/image18.png" style="width: 600.00px; height: 371.00px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 692.50px; height: 361.00px;"><img alt="" src="images/image3.png" style="width: 692.50px; height: 361.00px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 616.00px; height: 347.17px;"><img alt="" src="images/image9.png" style="width: 616.00px; height: 347.17px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c3"><span class="c4"></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 629.50px; height: 316.00px;"><img alt="" src="images/image14.png" style="width: 629.50px; height: 316.00px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 600.00px; height: 371.00px;"><img alt="" src="images/image10.png" style="width: 600.00px; height: 371.00px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 627.00px; height: 352.17px;"><img alt="" src="images/image11.png" style="width: 627.00px; height: 352.17px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c3"><span class="c4"></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 618.50px; height: 371.00px;"><img alt="" src="images/image13.png" style="width: 618.50px; height: 371.00px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c3"><span class="c4"></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 621.50px; height: 371.00px;"><img alt="" src="images/image12.png" style="width: 621.50px; height: 371.00px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 619.00px; height: 329.17px;"><img alt="" src="images/image17.png" style="width: 619.00px; height: 329.17px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 616.50px; height: 371.00px;"><img alt="" src="images/image2.png" style="width: 616.50px; height: 371.00px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c20"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 600.00px; height: 371.00px;"><img alt="" src="images/image4.png" style="width: 600.00px; height: 371.00px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><p class="c16 c20"><span class="c7"></span></p><p class="c20 c16"><span class="c7"></span></p><p class="c20"><span class="c7">Reporting Dashboard</span></p><p class="c8"><span style="overflow: hidden; display: inline-block; margin: 0.00px 0.00px; border: 0.00px solid #000000; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px); width: 672.00px; height: 794.17px;"><img alt="" src="images/image1.png" style="width: 672.00px; height: 794.17px; margin-left: 0.00px; margin-top: 0.00px; transform: rotate(0.00rad) translateZ(0px); -webkit-transform: rotate(0.00rad) translateZ(0px);" title=""></span></p><h1 class="c32" id="h.kf932py2ijf2"><span class="c4">Important findings/Recommendations </span></h1><p class="c8"><span class="c1">From the problem statement which is to evaluate the factors affecting the student’s academic performance in high school/colleges in the USA , the visuals clearly shows that the overall average academic score for students is 51%. This is a rather low average score which begs the question of why we have a low average student academic score.</span></p><p class="c2"><span class="c1">Also from the visuals , it can be ascertained that the average academic score for students with an ethnicity of african american is 47.85% which shows a high failure rate for these categories of students. In terms of gender, male African American students have an average score of 48.7% while females have an average score of 47%, both of which show a high failure rate amongst these categories of students.</span></p><p class="c8"><span class="c1">Also, hispanic female students share in this high failure rate as seen from their average academic score of 48.6%. Thus we can therefore infer that the average academic scores of the students was of a low rate due to the high failure rate of African American students and hispanic female students.</span></p><p class="c8"><span class="c1">If we then proceed to find out why the academic scores of african american students and hispanic female students are poor, we would observe that only the academic scores of female african american students are poor for students with an overall education spanning 12, 13, and 14 years respectively. Male african american students share in this poor standing for students with an education of 12 and 13 years respectively.</span></p><p class="c8"><span class="c1">The same pattern can also be observed for female hispanic students with an education period of 12, 13, 14 and 18 years.</span></p><p class="c8"><span class="c1">We can however infer from the visuals plotted that the more years of education acquired by a student, the greater their academic scores. An exception to this insight would be the hispanic female students with 18 years of education plus a poor academic score. This insight when closely inspected, showcases that the high failure rate is more concentrated on those female hispanic 18 years of education students whose parents own a home. Other than that observation, there is no considerable reason from the data why female hispanic students with 18 years of education would record such a high failure rate.</span></p><p class="c8"><span class="c1">Based on these aforementioned insights as garnered and the corresponding analysis, it is recommended that school authorities and its tutors pay better attention to its foreign student’s academic performance and other non-academic factors such as racism, mental health, emotional health, adaptability, guidance & counseling and other aspects of their foreign student’s lives that may have an adverse effect on their academics when not properly managed. This is even more necessary especially for female students from african american and hispanic ethnicities.</span></p><p class="c3"><span class="c1"></span></p><p class="c3"><span class="c1"></span></p><h1 class="c32" id="h.gr142qz53k7a"><span class="c4">Conclusion</span></h1><p class="c8"><span class="c1">The academic performance of high school/college students in the USA was analyzed and properly assessed from the available student’s record data based on a number of factors such as the academic score attained all through a student’s high school/college, the number of years of education the student has received since birth, the student’s age, student’s tuition, average country tuition, location of school, ethnicity of student, student’s household income, gender, and student parent’s college education status.</span></p><p class="c8"><span class="c1">An analysis on all these aforementioned criteria brought about a couple of key insights which formed the basis of this report.</span></p><p class="c8"><span class="c1">Based on the insights garnered, it was ascertained that from a student record of 37, 997 student data analyzed, only 51.5% of students have a pass score whilst 48.5% of students have a failed score with an average academic score of 51%. Further analysis to ascertain the reason for a relatively high rate of low scores amongst students revealed that most fail scores came from students of hispanic and african american ethnicities while students from an asian ethnicity have a higher pass rate on average. It was observed that the female gender amongst both hispanic/african american students occupied a larger percentage of the failure rate. It was also observed that an increase in the years of education received by a student has a corresponding effect on the student’s academic score with the exception of female hispanic students with 18 years of education.</span></p><p class="c8"><span>However, In the course of analyzing the student data, certain limitations were encountered. One of such limitation was insufficient information from the dataset to properly ascertain which category of student records were made available, and this led to a couple of assumptions including -</span><span class="c11"> the country where the data was gathered</span><span>, </span><span class="c11">the pass mark for the student’s academic score, and the time period indicated by the </span><span class="c13 c11">education</span><span class="c11 c19"> variable in the data.</span></p><p class="c8"><span>Additional information on these parameters would have come in handy to better understand the dataset. Also, some factors which could affect a student’s academic performance were not included in the data. These factors which may be also useful in ascertaining either the success rate or failure rate of a student includes but are not limited to -</span><span class="c11"> health status of student, information on high school/colleges attended, university course of study (where </span><span class="c11">applicable</span><span class="c11">), student status(international/local), country of residence </span><span class="c1">etc.</span></p><p class="c8"><span>More clarity on the cause of success or failure could be better ascertained if these additional information were provided.</span></p></body></html>