House Event Points recording in SIMS
Hi, apologies if this has been discussed before but I couldn’t find anything on the forums.
From the beginning of this academic year we have reintroduced a house system into school. The students are receiving lots of points which is great, but the problem for us comes to reporting on the points totals, specifically concerning House events. For example, PE run a sports afternoon with various competitions happening. At the end of the afternoon points are awarded to the individual winners, but we also look at the bigger picture when it comes to overall House performance and reward points accordingly to each house.
The problem occurs at this point since there is no House entity within SIMS (that I’m aware of) that we can assign the points to. As a work around for this we have decided to award these performance points to the House Captains so we can run reports on overall House points totals monthly/termly etc, but the issue arises when we come to run individual student/form points totals. I know that we can remove the overall points totals from the House Captains individual points totals by filtering out the House Event Achievement Types to give more accurate results. Though this is a simple solution that requires little effort, this solution isn’t liked by the staff in charge of the House system since its open to human errors. ie when entering the awards, choosing the wrong Achievement Type would mean that the filters wouldn’t remove the points from the reports when being run so would therefore give false points totals for the House Captains.
We can't be the only school that has come across this problem, so I was hoping if anyone knew of a more elegant solution to this, or can anyone suggest any alternative methods of storing points? Ideally we would like to remove the link of Event House points to individual students and somehow award them directly to the House, but we’ve been searching unsuccessfully for a way to do this for a while. (One crazy idea was to create a fake student entry per House to award the points to, but I put a stop to that because it would affect the census etc.) Any and all ideas are welcome :D