SIMS Lookup Tables

[rsides]

Hi,

 

I'm having trouble with a look up table and wondered if anyone could advise.

 

The idea is to forecast what a student is going to achieve in Year 11 from their KS3 data (Years 7-9) which is currently being inputted by staff members. I have created the attached lookup table however, I don't think I have done it correctly as nothing is being calculated when KS3 data is inputted.

 

I know chance tables are available but SLT want teachers to see a forecast on their marksheet. Any advice or ideas gratefully received.

 

ThanksDoc1.pdf

[davidpott]

The lookup table looks okay to me. Maybe your formula needs checking? Make sure you choose the right aspect when using the lookup formula. You'll need to choose the GCSE aspect. If you choose an aspect that doesn't contain the grades returned by the formula you'll not get any error messages, just no results.