* 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 "ucas.ac.uk" label variable WebsiteB "unistats.direct.gov.uk" label variable WebsiteC "whystudyeconomics.ac.uk" 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