[sims] Help with Assessment Manager

[emmab2503]

I am trying to create what would be an Excel If Then If Then Else Formula in Sims.

 

I am trying to create the Levels of Progress made by individual students from their KS2 APS to their Target. For example, if a student had an APS of 26 and a Target grade C this would be 3 Levels Progress. How can I get Assessment Manager to calculate this?

 

I have been advised that I would need to give each KS2 APS and Target a value and add them together, then ask for an If Then Else formula however, because there are some many possibilities I don't see how this is possible.

 

Can someone please help or am I going to have to calculate these manually?

[vikpaw]

I think there are a couple of threads on here that go over the process, so it's worth a search.

In principle, the Target Grade needs to be a grade type column, and this would be linked to a gradeset. In the gradeset, you can give each grade a points value. This is used to do the calculation.

So then in your template you can do a subtraction Target - APS to get the difference. Then add a Nested If Then Else Formula to look at this difference and colour the cell depending on whether the difference is what you want, above, below etc.

The difference will measure the progress. You only need the If Then Else to process it and colour it.

This should work generically for any values in your marksheet.

Hope that makes sense.

[LosOjos]

You may also want to look at Assessment Lookup Tables (Focus > Assessment > Lookup Tables). These provide a convenient way to map two different values for comparison.

 

For instance, I have a lookup table which takes a KS2 level as input and returns the GCSE grade equal to 3 LOP. I can then compare this grade to the target/estimated grade.

 

To make this easier to set up, put in your default values then hit 'Apply' in the 'Age Standardised Score' panel, which will give you an empty table to start with. If you then press 'Copy', you can past this table in to Excel where it's easier to manipulate (you can also remove row if needs be). Then copy the finished table in Excel and select 'Paste' in SIMS to transfer the data across.

[SouthCoastSaint]

I do it another way too. I have a column to calculate the difference between the current predicted grade (which could just as easily be the target grade) and the KS2 combined E&M level. This is then used in a marks to grade formula to return a LOP. I have LOP aspects set up for all subjects, so my LOPs are saved in result sets once calculated.