* Syntax to format cross sectional data into format required for ESRC archive
http://www.data-archive.ac.uk/create-manage/document/data-level
http://www.data-archive.ac.uk/create-manage/document/data-level?index=1  .



* NUMBERS ############################################# .
GET  FILE='D:\Documents\Academic\ICCAMS\data\FINAL_DATASETS\1XSection\num right wrong phase 1 cross sectional.sav'.
DATASET NAME num WINDOW=FRONT.


DO REPEAT V=num01aa_r to num20@@_r  .
recode V (sysmis=-9) .
MISSING VALUES V (-9) .
END REPEAT .
EXECUTE .

VALUE LABELS  num01aa_r to num20@@_r  0 'Wrong' 1 'Right' .

variable labels num01aa_r '521: The 2 stands for 2 …' .
variable labels num01bb_r '521 400: The 2 stands for 2 …' .
variable labels num02aa_r '0.2: The 2 stands for 2 ...' .
variable labels num02bb_r '0.260: The 2 stands for 2 …' .
variable labels num02cc_r '0.412: The 2 stands for 2 ...' .
variable labels num03aa_r 'Write in figures: Two hundred and fifty' .
variable labels num03bb_r 'Write in figures: Four hundred thousand and seventy three' .
variable labels num04aa_r 'Write in words: 8030' .
variable labels num04bb_r 'Write in words: 140 000' .
variable labels num04cc_r 'Write in words: 0.29' .
variable labels num05aa_r 'Add ten to 3597' .
variable labels num05bb_r 'Add ten to 0.15' .
variable labels num05cc_r 'Add one hundred to 21 534' .
variable labels num05dd_r 'Add one hundred to 19 930' .
variable labels num05ee_r 'Add one tenth to 4.254' .
variable labels num05ff_r 'Add one tenth to 2.9' .
variable labels num05gg_r 'Take away one hundred from 583' .
variable labels num05hh_r 'Take away one hundred from 30 000' .
variable labels num06aa_r 'Identify the number on a ruler 7 tenths of the way from 20 to 30' .
variable labels num06bb_r 'Identify the number on a ruler 8 tenths of the way from 5 to 6' .
variable labels num06cc_r 'Identify the number on a ruler 4 tenths of the way from 2.7 to 2.8' .
variable labels num06dd_r 'Identify the number on a ruler 6.5 tenths of the way from 14 to 15' .
variable labels num06ee_r 'Identify the number on a ruler 1 fifth of the way from 3 to 4' .
variable labels num06ff_r 'Identify the number on a ruler about a third of the way from 7 to 8' .
variable labels num07@@_r 'Counter at  06399, after one more will be?' .
variable labels num08@@_r '2 less than 17 000?' .
variable labels num09ab_r 'Is there any difference between 4.9 and 4.90? Why?' .
variable labels num10ab_r 'Which is bigger, 0.75 or 0.8? Why?' .
variable labels num10cc_r 'Which is bigger, 20 100 or 20 095?' .
variable labels num10dd_r 'Which is bigger, 7.55 or 7.5?' .
variable labels num10ee_r 'Which is bigger, 4.06 or 4.5?' .
variable labels num11aa_r 'Write as a decimal three hundredths' .
variable labels num11bb_r 'Write as a decimal eleven thousandths' .
variable labels num11cc_r 'Write as a decimal eleven tenths' .
variable labels num11dd_r 'Four tenths is the same as ?? hundredths' .
variable labels num12aa_r 'Write down any number between 4000 and 5000' .
variable labels num12bb_r 'Write down any number between 4100 and 4200' .
variable labels num12cc_r 'Write down any number between 0.4 and 0.5' .
variable labels num12dd_r 'Write down any number between 0.41 and 0.42' .
variable labels num12ee_r 'How many different numbers lie between 0.41 and 0.42?' .
variable labels num13aa_r 'Shaded area of 2 units and 3 tenths' .
variable labels num13bb_r 'Shaded area of 1 unit, 4 tenths and 3 hundredths' .
variable labels num13cc_r 'Shaded area of 1 unit and 7 hundredths' .
variable labels num14aa_r 'Multiply 4 by ten' .
variable labels num14bb_r 'Multiply 5.13 by ten' .
variable labels num14cc_r 'Multiply 317 by one hundred' .
variable labels num14dd_r 'Multiply 2.3 by one hundred' .
variable labels num14ee_r 'Divide 1600 by one hundred' .
variable labels num14ff_r 'Divide 3.7 by one hundred' .
variable labels num14gg_r 'Divide 24 by twenty' .
variable labels num14hh_r 'Divide 16 by twenty' .
variable labels num15ac_r 'Which is bigger, 8x4 or 8/4?  8x0.4 or 8/0.4?  0.8x0.4 or 0.8/0.4?' .
variable labels num16aa_r 'Column addition: 263 + 978' .
variable labels num16bb_r '13.4 + 2.7 =' .
variable labels num16cc_r 'Column subtraction 2312 - 547' .
variable labels num16dd_r '8.44 – 6.37 =' .
variable labels num17aa_r '20 × 500 =' .
variable labels num17bb_r '5 × 0.2 =' .
variable labels num17cc_r '0.2 × 0.4 =' .
variable labels num17dd_r '60 ÷ 3 =' .
variable labels num17ee_r '60 ÷ 0.3 =' .
variable labels num18aa_r 'Which is nearest in size to 182? 100 or 82 or 180 or 150 or 200 or 190' .
variable labels num18bb_r 'Which is nearest in size to 2.9?  3 or 30 or 2 or 20 or 0 or 1' .
variable labels num18cc_r 'Which is nearest in size to 0.18?  0.1 or 10 or 0.2 or 20 or 0 or 1 or 2' .
variable labels num18dd_r 'Which is nearest in size to 2.9x7?  .002 or .02 or .2 or 2 or 20 or 200 or 2000' .
variable labels num18ee_r 'Which is nearest in size to 0.29x7.1?  .002 or .02 or .2 or 2 or 20 or 200 or 2000' .
variable labels num18ff_r 'Which is nearest in size to 59÷190?  .003 or .03 or .3 or 3 or 30 or 300 or 3000' .
variable labels num19aa_r 'What is the calculation: A table is 92.3 centimetres long.  About how many inches is this?  (1 inch is about 2.54 centimetres.)' .
variable labels num19bb_r 'What is the calculation: My car tank was full after I put  in 6.44 gallons of petrol.  The tank holds 8.37 gallons.  How much petrol was in it to start with?' .
variable labels num19cc_r 'What is the calculation: The price of pebbles is shown  as 88.2 pence for each kilogram.  What is the cost of a bag  containing 0.58 kg of pebbles?' .
variable labels num19dd_r 'What is the calculation: The cost of 6.22 litres of petrol  was £4.86. What would the price of one litre be?' .
variable labels num19ee_r 'What is the calculation: My car can go 41.8 miles on each  gallon of petrol on a motorway.  How many miles can I expect to  travel on 8.37 gallons?' .
variable labels num20@@_r 'Write a story which matches this sum:  6.4 + 2.3 = 8.7' .

variable labels num_total 'Total score on Numbers items' .



* GENERAL VARIABLES ############################################## .
*change ICCAMS_ID to PUPIL_ID .
RENAME VARIABLES ( ICCAMS_ID = PUPIL_ID ) .
*remove n_qns (these are part questions on original paper, may not correspond with coded qns) .
DELETE VARIABLES n_qns .
DELETE VARIABLES N_levels .

* convert dob to month & year .
compute dob = DATE.MOYR(XDATE.MONTH(dob) , XDATE.YEAR(dob) ) .
formats dob (MOYR8) .
execute .


variable labels test_ID 'Unique test response identifier' .
variable labels test_type 'Type of test' .
variable labels test_year 'Year in which test taken' .
variable labels test_date 'Date test taken (imputed from set/batch if missing)' .
variable labels sch 'School code' .
variable labels phase 'Phase in ICCAMS project' .
variable labels year 'School year group (grade) when test taken' .
variable labels PUPIL_ID 'ICCAMS unique pupil identifier' .
variable labels sex 'Sex (1=m, 2=f)' .
variable labels dob 'Date of birth (date format)' .
variable labels MidYIS_score 'Overall MidYIS score' .
variable labels weight 'Weight applied to give nationally representative sample' .

variable labels L1 'CSMS Level 1 achieved' .
variable labels L2 'CSMS Level 2 achieved' .
variable labels L3 'CSMS Level 3 achieved' .
variable labels L4 'CSMS Level 4 achieved' .
variable labels L5 'CSMS Level 5 achieved' .
variable labels L6 'CSMS Level 6 achieved' .
variable labels HiLev 'CSMS level' .


RECODE year (sysmis = -9) .
RECODE sex (sysmis = -9) .
RECODE L1 (sysmis = -9) .
RECODE L2 (sysmis = -9) .
RECODE L3 (sysmis = -9) .
RECODE L4 (sysmis = -9) .
RECODE L5 (sysmis = -9) .
RECODE L6 (sysmis = -9) .
RECODE HiLev (sysmis = -9) .


MISSING VALUES year (-9) .
MISSING VALUES sex (-9) .
MISSING VALUES L1 (-9) .
MISSING VALUES L2 (-9) .
MISSING VALUES L3 (-9) .
MISSING VALUES L4 (-9) .
MISSING VALUES L5 (-9) .
MISSING VALUES L6 (-9) .
MISSING VALUES HiLev (-9) .



SAVE OUTFILE='D:\Documents\Academic\ICCAMS\data\FINAL_DATASETS\ESRC archive\numbers.sav'
  /COMPRESSED.

DATASET CLOSE num .