Working out standard deviation with SIMS Marksheets

[Jahir]

Hi All,

 

Does anyone know if it is possible at all to work out standard deviation using SIMS marksheets?

 

Thanks,

Jahir

[FishCustard]

I imagine you could do it using a calculated column, the issue would be getting the "N" (i.e. the number of values) for the formula... interested in this one myself!

[RootsSchImp]

It's been a while since I used Assessment Manager but I think as well as the count problem @FishCustard raises there's also no square root formula.

 

My advice would be to build a spreadsheet or power bi dashboard using the exported marksheet as a data source. It's a bit clunky but that's what you get for using Sims.

[DeeleyNet]

Closest I've got is a replication of SISRA's Residual, this is achieved by creating a marksheet for the whole year group with each subject's results and having a Formula for Data review column taking the mean grade. Then coulmns follow that calculate the difference from the mean and this is held in a 'Residule' aspect for each subject.

 

This way I open the markshet at the end of data collection, calculate and the residule can then be used on each individual subject marksheet.

[Jahir]

Thanks all for your help. I was hoping to do it in SIMS as I need it for student reports. Guess I'll have to export data, work out what I need and then import the calculated data.