Sims house points total for academic year for individual student and house

[Mysamjer]

I am trying to configure a report which we can use to identify the highest house points student achiever for the academic year and summer term, and the highest house which achieved the highest points for the summer term and academic year,

I found one which was imported, however it gives the total points for the student since they have been on roll, and when I try to filter this by academic dates, it still gives the same total. And there is a points count, which I belief is for the filtered dates, however this identifies the number of times a house point has been rewarded, and not the total of these, eg a house point can house point 1, house point 2 or house points 3.

 

I hope I am making sense here, any suggestions will be appreciated!

[a_masters]

What are house points? Are you after the number of Achievement Points per house?

 

Something like the below, exported to Excel would give you a list of all APs awarded since the date. Use a pivot table to quickly tell you how many points each house or student have this year. Change the date to get just for the term. Could take a while to run, depending on number of APs!

 

Edited June 30, 2021 by a_masters

[Mysamjer]

Thank you, I will give this a try tomorrow when I am in school.

In our school we have houses, and students are assigned to one of the houses, and throughout the year, students enters competitions and will earn house points.

At the end of each term, academic year these are totalled and award would be given to the highest achieving house, and the highest achieving student.

 

The problem I came across was when I imported a report it gave the totals of points for an student since they have been on roll, and not the total for a particular academic year, and would also give you the ‘count’ of each time a house point was recorded, and not the total of points combined. eg, a student can have 2 entries of house point, one is for 1 house point, and the other could be 2 house point, which would equals 3 house points, however the count would state 2.

 

I hope I am making sense here!

[a_masters]

You are - that's the bit I understand. The bit I'm not sure about is where you're storing your house points in SIMS, I assume as achievement points.

[Mysamjer]

Yes we are storing these under achievements.

But I wonder how a report can be run for house points to represent the house? Or would I need to run 4 different reports with students in each house, and then combine their total of points to get the total for the house?

[a_masters]

If you want it for a particular time frame, that's how I'd do it as SIMS isn't great for getting data from between two points in time.

 

It'll give you a list of each AP awarded and to whom (and more importantly their house). You can then use a pivot table to quickly add up how many points awarded to each house.

 

Be warned, depending on the number of incidents it's pulling out, it could take a while.

 

I have a similar report that I run at reports time, allowing me to break down APs/BPs awarded to each student by type to go on their report. I ran it the other day and it took a few mins to get all the APs for a year group.

 

I can send you a report and excel template for what you're after tomorrow if you want.

[Mysamjer]

Yes please this would be really helpful!

And I don’t use Pivot tables, are they easy to create/ understand?

[a_masters]

Reports attached. There's two - one for total points this year, one for total points in a time period. When you run them, save the data somewhere as a .csv file. You can then copy and paste the data into the Excel template.

 

You may then need to refresh the pivot tables, select one to bring up the PivotTable Tools. Under Analyze, click Refresh and then Refresh All. Should give you the totals for each house in the table on the left and the top student per house on the right.

 

 

Reports.zip

[Mysamjer]

Thank you.

I will give it a go as soon as I get in!

[Mysamjer]

Thank you for your help.

I have finally figured out and set up a report for the information I require!

[robins]

Recommend you let SIMS visualise house/achievement point totals on a continual basis by configuring a conduct/achievement widget on your SIMS homepage. You can change bar graph colours to suit house colours and click to drill down to see highest scoring students, etc. Best of all SIMS then refreshes graph continually so it's effortless to monitor daily, weekly, annual leading house. PM me if you need set up tips.

[Mysamjer]

This would be great!

However I am off for the summer holidays now until August.

So therefore unable to configure this until I return.

Can you send me the basics set this up