[sims] SIMS achievement report

[damien1987]

Good afternoon all,

 

We have been using SIMS at our school for quite a while but recently a change was made to the way teachers can allocate achievement points to students. They can now award students between 1 to 5 achievement points by right clicking on their name.

 

This has been great and certainly seen an increase of students achievements being recognised.

 

However, when running a report to view totals everything is being calculated as one value as opposed to 2, 3, 4 and 5.

 

Would greatly appreciate any guidance or advice.

 

Cheers

[panosthegreat]

I have the achievement report exporting into a spreadsheet, then a macro creates a number of pivot tables to get the totals vs different things (houses, year groups etc...), being careful to make sure the Values bit is set to Sum and not Count. It's a real hassle to edit the macro code so all this happens automatically when you run the report but it's working right now. If there are any requests to change that spreadsheet though I'm going to try and just teach the staff how to make a pivot table.

 

I suspect SIMS Discover will do a better job of this and staff will find it easier to use, I just haven't practiced on it much yet