Totaling Sims Behaviour Points
We are using Sims behaviour in school, and up until now we have always produced reports based on a COUNT of the number of behaviour concerns a pupil has, and our behaviour specialist call up lists of selected types of behaviour, for instance ignoring the concerns that are purely about a pupil forgetting equipment.
We have recently decided to use the points system, allocating a greater number of points for harsher behaviour types to collate a better picture of the behaviour or students, however this is causing me some difficulty producing a report of this.
I have a report that shows me the total points, in a date range, but when I run it it produces a different row for every behaviour instance a pupil has, so each pupil appears multiple times, and when i ran the report for a form class I received 2100 entries, when all I wanted was each pupil to appear once, with the total points for that time for both behaviour and achievement.
Anyone got any ideas how I can do this?
I can send/upload the exported report if that helps someone look at it - or i am happy to use a report someone else has created, if someone was so kind. (Couldn't attach as the file extension is not allowed)