[sims] Target Setting using the new KS2 data

[langfordaj]

Hi folks

First post so really nervous.

New to SIMs and Assessment Manager but experienced as far as knowledge about data etc.

 

I want to set something up in AM/SIMs to use the new KS2 data for target setting.

Not sure how to do them, but would lookup tables be a route?

 

Any help is appreciated in advance

thanks in anticipation

AJ

[RootsSchImp]

Hi @langfordaj,

 

Welcome! Despite their useful sounding name, lookup tables are a total red herring in my opinion.

 

If you're doing a straightforward mapping of ks2 to GCSE (say for e.g. 100-105=5, 106-110=6, 110+=7.

 

Create a template (focus, assessment template). Add a column for data review and select the ks2 scaled score your using.

 

If you've got the Reading and Maths and want the avg add R and M then add a column for data review using formula, f-type MEAN and choose columns you want mean of.

 

Then for a target choose data entry using formula, choose resultset and aspect. F-type Marks to Grade, then adjust the values that act as the threshold for each grade. (This does not affect the entered grade value, once in a 5 will be worth 5 not 100)

 

Good luck! Sims is alright when you get used to it. Pro tip: there's lots of keyboard shorts in AM, N for next, enter to open dialogues etc-learn them, the keys are your friend, mouse your enemy.