gazskeltz Posted November 28, 2013 Posted November 28, 2013 Hi, I've just downloaded our latest CAT Test results from Testwise. In the csv they send they have estimates for KS3 results for each student, which I import to SIMS as (yet more) pieces of data. Historically, all these were sent as 5a,5b,5c etc. This time, they have come down as Decimals - 5.0-5.9. Does anyone have a definitive conversion from Decimal to Sublevel that I can use? I had a look at FFT (where you can display either) and they have, if you look at the underying data, about 7 decimal places! Any help gratefully received. Regards Gaz
tben2505 Posted November 28, 2013 Posted November 28, 2013 Hi Gaz This is what I use: Level Point score Decimal Level 1c 7 0.66 1c 1b 9 1.00 1b 1a 11 1.33 1a 2c 13 1.67 2c 2b 15 2.00 2b 2a 17 2.33 2a 3c 19 2.67 3c 3b 21 3.00 3b 3a 23 3.33 3a 4c 25 3.67 4c 4b 27 4.00 4b 4a 29 4.33 4a 5c 31 4.67 5c 5b 33 5.00 5b 5a 35 5.33 5a 6c 37 5.67 6c 6b 39 6.00 6b 6a 41 6.33 6a 7c 43 6.67 7c 7b 45 7.00 7b 7a 47 7.33 7a 8c 49 7.67 8c 8b 51 8.00 8b 8a 53 8.33 8a Though I have come across a few people using different conversions! This is pretty standard, though; a third of a level above or below the "b" - which is the centre of the level. Cheers Tom
gazskeltz Posted November 28, 2013 Posted November 28, 2013 Tom, You are a star! Thanks so much for the quick reply. Now for some nifty vlookups Thanks again Regards Gary
NormalDistribution Posted November 29, 2013 Posted November 29, 2013 Now then... I would say I do this differently Tom I would say for example 5.00 to 5.33 = 5C 5.33 to 5.67 = 5B 5.67 to 6.00 = 5A and so on.
pingleby Posted November 29, 2013 Posted November 29, 2013 I would have to agree with NormalDistribution as a 4.x is always a level 4. I don't think you can interpret 4.8 as low level 5 (ie 5c), it has to be high level 4 (4a).
gazskeltz Posted November 29, 2013 Posted November 29, 2013 Hi, Just did a double FFT Export to compare decimals with sublevels and here's a subset of what I got: 4.900000 4A 5.026648 5C 5.032409 5C 5.040800 5C 5.086133 5C 5.116626 5C 5.155821 5C 5.295497 5C 5.373163 5B 5.393472 5B 5.410501 5B 5.413723 5B 5.431545 5B 5.454931 5B 5.455528 5B 5.458039 5B 5.476052 5B 5.490747 5B 5.515315 5B 5.526725 5B 5.528958 5B 5.546412 5B 5.574502 5B 5.575861 5B 5.577826 5B 5.578057 5B 5.580157 5B 5.586797 5B 5.595819 5B 5.613748 5B 5.616669 5B 5.626608 5B 5.627388 5B 5.628719 5B 5.637668 5B 5.654581 5B 5.659652 5B 5.672220 5A 5.696870 5A 5.712668 5A 5.746923 5A 5.748803 5A 5.758731 5A 5.762102 5A 5.785806 5A 5.789006 5A 5.820881 5A 5.827591 5A 5.838399 5A 5.884612 5A 5.885142 5A 5.897323 5A 5.900000 5A 5.900000 5A 5.918780 5A 5.922822 5A 5.939367 5A 5.940944 5A 5.941189 5A 6.005053 6C So I think the second idea is correct (at least according to FFT Thanks for your help... Regards Gary
Ecclesbury Posted November 29, 2013 Author Posted November 29, 2013 This can get confusing, but I find the best way to convert decimal levels to sub levels is to convert the levels to points. So simply multiply your decimal level by 6 to get a decimalised points score and then use the following look up to convert to a sub level: 6C - 36 5A - 34 5B - 32 5C - 30 4A - 28 4B - 26 4C - 24 3A - 22 3B - 20 3C - 18
Ecclesbury Posted November 29, 2013 Author Posted November 29, 2013 p.s. this might seem convoluted, but the reason for converting to points is so that you don't have recurring decimal values as your lookup boundaries.
Recommended Posts