Elmer1 Posted December 2, 2015 Posted December 2, 2015 Hi does anyone know where I can get KS2 English sub-level data from for a school I work with (but not in) - when I worked in school we used to calculate according to test results and level thresholds or download from Key2Success/FFT. Th school advise that this is not available from FFT only the reading sub-level, which I know will be the basis for P8 calcs as of next year - in the meantime I'd still like the English data - any ideas?
garbage46 Posted December 4, 2015 Posted December 4, 2015 The school should have Writing Teacher Assessment levels? These will be whole levels but can be converted to a fine points score (5 = 33.00, 4 = 27.00 etc). (Writing Fine Score + Reading Fine Score) / 2 = English Fine Score English Fine Score / 6 = English Fine Level Convert English Fine Level to sub level. I do not think there is any clear conversion guidance, but you could use something like this: x.0 to x.333 = c sub level x.34 to x.667 = b sub level x.67 to x.999 = a sub level Maybe someone out there has a better method?
Elmer1 Posted December 5, 2015 Posted December 5, 2015 Many thanks @petem46 - but does this apply to current Y11 I thought they would still have "real" KS2 English test results.
bobsmith Posted December 7, 2015 Posted December 7, 2015 Current year 11 have an overall english test score - this can be used with the threshold boundaries to convert to a fine points score - then to a differentiated level - then to a sub level. [TABLE=width: 165] [TR] [TD]year[/TD] [TD]test[/TD] [TD]mark[/TD] [TD]level[/TD] [/TR] [TR] [TD]2010[/TD] [TD]engtot[/TD] [TD]0[/TD] [TD]N[/TD] [/TR] [TR] [TD]2010[/TD] [TD]engtot[/TD] [TD]19[/TD] [TD]N[/TD] [/TR] [TR] [TD]2010[/TD] [TD]engtot[/TD] [TD]20[/TD] [TD]2[/TD] [/TR] [TR] [TD]2010[/TD] [TD]engtot[/TD] [TD]22[/TD] [TD]2[/TD] [/TR] [TR] [TD]2010[/TD] [TD]engtot[/TD] [TD]23[/TD] [TD]3[/TD] [/TR] [TR] [TD]2010[/TD] [TD]engtot[/TD] [TD]42[/TD] [TD]3[/TD] [/TR] [TR] [TD]2010[/TD] [TD]engtot[/TD] [TD]43[/TD] [TD]4[/TD] [/TR] [TR] [TD]2010[/TD] [TD]engtot[/TD] [TD]67[/TD] [TD]4[/TD] [/TR] [TR] [TD]2010[/TD] [TD]engtot[/TD] [TD]68[/TD] [TD]5[/TD] [/TR] [TR] [TD]2010[/TD] [TD]engtot[/TD] [TD]100[/TD] [TD]5[/TD] [/TR] [/TABLE] this is the conversion table i've been using [TABLE=width: 84] [TR] [TD]Fine Points Score[/TD] [TD]Sub level[/TD] [/TR] [TR] [TD]15[/TD] [TD]2b[/TD] [/TR] [TR] [TD]18[/TD] [TD]3c[/TD] [/TR] [TR] [TD]20[/TD] [TD]3b[/TD] [/TR] [TR] [TD]22[/TD] [TD]3a[/TD] [/TR] [TR] [TD]24[/TD] [TD]4c[/TD] [/TR] [TR] [TD]26[/TD] [TD]4b[/TD] [/TR] [TR] [TD]28[/TD] [TD]4a[/TD] [/TR] [TR] [TD]30[/TD] [TD]5c[/TD] [/TR] [TR] [TD]32[/TD] [TD]5b[/TD] [/TR] [TR] [TD]34[/TD] [TD]5a[/TD] [/TR] [/TABLE]
Elmer1 Posted December 7, 2015 Posted December 7, 2015 That's great bobsmith just what I was after. Many thanks.
garbage46 Posted December 8, 2015 Posted December 8, 2015 I noticed that you have used Year 2010 conversions... current Year 11 would be 2011 - not sure if there is a change in boundaries?
bobsmith Posted December 8, 2015 Posted December 8, 2015 sorry, must have copy pasted from the wrong section in my spreadsheet, don't think I moved it on for this year: [TABLE=width: 165] [TR] [TD]2011[/TD] [TD]engtot[/TD] [TD]0[/TD] [TD]N[/TD] [/TR] [TR] [TD]2011[/TD] [TD]engtot[/TD] [TD]19[/TD] [TD]N[/TD] [/TR] [TR] [TD]2011[/TD] [TD]engtot[/TD] [TD]20[/TD] [TD]2[/TD] [/TR] [TR] [TD]2011[/TD] [TD]engtot[/TD] [TD]22[/TD] [TD]2[/TD] [/TR] [TR] [TD]2011[/TD] [TD]engtot[/TD] [TD]23[/TD] [TD]3[/TD] [/TR] [TR] [TD]2011[/TD] [TD]engtot[/TD] [TD]40[/TD] [TD]3[/TD] [/TR] [TR] [TD]2011[/TD] [TD]engtot[/TD] [TD]41[/TD] [TD]4[/TD] [/TR] [TR] [TD]2011[/TD] [TD]engtot[/TD] [TD]69[/TD] [TD]4[/TD] [/TR] [TR] [TD]2011[/TD] [TD]engtot[/TD] [TD]70[/TD] [TD]5[/TD] [/TR] [TR] [TD]2011[/TD] [TD]engtot[/TD] [TD]100[/TD] [TD]5[/TD] [/TR] [/TABLE]
CAM Posted February 4, 2016 Posted February 4, 2016 Quick question. Does anyone import their KS2 data into 4Matrix? Is Test Level the same as the ENGLEV column on the KS2 Key to Success CSV file? I ask as I currently have KS2 sublevels in there and Key to Success shows whole levels! There's a separate one for TA as well but I think that's the ENGLEVTA column. Of course, trying to import the CTF file fails as SIMS doesn't recognise it!
bobsmith Posted February 5, 2016 Posted February 5, 2016 rename the ctf and replace CTF with KS2 and it should import fine. When I used 4Matrix I always imported KS2 - you can't get VA, Levels of Progress or even Progress 8 and other cool stuff without it. I think 4matrix uses fine levels (as does SISRA) - this is probably cos the DfE uses fine levels to produce attainment 8 estimates.
CAM Posted February 5, 2016 Posted February 5, 2016 I was browsing a document which made no mention of fine levels so I converted everything to whole test level using the data from Key to Success alongside whole TA level. Now I've discovered the RAISEOnline library and the technical document which says to use fine levels. I'm going to stick it in the fine score field in 4Matrix to see what it does. I've mapped the following so far from K2S to 4Matrix: ENGLEV - English Test Level ENGLEVTA - English TA MATLEV - Maths Test Level MATLEVTA - Maths TA SCILEVTA - Science TA (no test available)
123sch Posted February 5, 2016 Author Posted February 5, 2016 FFT gives fine points scores for reading, writing and maths in their pupil export. When importing into 4Matrix it takes the readingfps as the English fps and rejects the writing as no field to map against - this might be due how my predecessor set up 4Matrix, only a few weeks in the school. Got round this for current Year 11 (as reading only used for current Y10) by calculating (r+w)/2 and putting under the same heading as reading in the FFT export before importing into 4Matrix.
Recommended Posts