+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
MIS Systems Thread, SIMS report issue Showing each house point. Need help urgently please! in Technical; Hi We record house points (Behaviour Points) through SIMS and i need to run a report to give me a ...
  1. #1

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    440
    Thank Post
    112
    Thanked 13 Times in 13 Posts
    Rep Power
    8

    SIMS report issue Showing each house point. Need help urgently please!

    Hi

    We record house points (Behaviour Points) through SIMS and i need to run a report to give me a total number of house points for students awarded between 5th September 2011 and 31st July 2012. Each time i run a report i get an output like this below. Is there anyway to remove the duplicate names so i have one row per name with the total house points this year?

    Screen Shot 2011-10-28 at 19.55.15.png

    The 2 is the correct number of house points for this academic year.

    Need this one urgently as we need to update staff and students on Monday.

    Thanks guys.

  2. #2

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    440
    Thank Post
    112
    Thanked 13 Times in 13 Posts
    Rep Power
    8
    Think the names are repeated the same number of times as the total number of house points they have received since we started awarding them 2 years ago if that helps. cheers

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    There is something not quite right with your report, there are a number of reports that have been uploaded to SupportNet that help with this sort of thing and also i think quite a few are now built in as well.
    For a quick fix, untick the Suppress Duplicates, so you get Joe Bloggs repeated down the list. Then you can use the Auto-Filter, Sub-totals, or even a Pivot Table in Excel. All of which should summarise the data for that student. Hope is sort of what you're after.

  4. Thanks to vikpaw from:

    tj2419 (29th October 2011)

  5. #4

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    440
    Thank Post
    112
    Thanked 13 Times in 13 Posts
    Rep Power
    8
    Quote Originally Posted by vikpaw View Post
    There is something not quite right with your report, there are a number of reports that have been uploaded to SupportNet that help with this sort of thing and also i think quite a few are now built in as well.
    For a quick fix, untick the Suppress Duplicates, so you get Joe Bloggs repeated down the list. Then you can use the Auto-Filter, Sub-totals, or even a Pivot Table in Excel. All of which should summarise the data for that student. Hope is sort of what you're after.
    Thanks for the response. How would i get it so it displays each students name and the total house points next to them so
    Joe Bloggs 2
    Jane Doe 6 (This name on a new row etc)

    THanks

  6. #5

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    440
    Thank Post
    112
    Thanked 13 Times in 13 Posts
    Rep Power
    8
    Hi i have solved it. I used your method of not suppressing duplicates. Then using the advanced filter feature hid some columns and removed duplicates based on the fields left. Thanks for your help VikPaw!

  7. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Well, because the report is chucking out data you dont want, to fix it it's just a case of pick your weapon, from manually removing the duplicates to using some built-in functions.
    Assuming that you now have joe bloggs, repeated down the list and jane doe etc. you can in Excel 2007 (might be different terms in 2010, and probably easier):

    Remove Duplicates which is on the Data menu, select the name and year as values to compare on.

    Click on SubTotal on Data menu, and parameters such that At each change in Name, use function Average, and select the add subtotal to Count. This will keep your data but gives you the option to hide it. The sheet will be grouped, with little pluses and minuses on the left. Allowing you to close the groups and only show the subtotal lines. This requires that the list is sorted by name.

    Similar option is to Insert a Pivot Table from the Insert menu. Drag the Names to Row labels box, or left hand side of table. Drag the Count to the values box, or middle of the table. You'll then need to edit the field for values, or right click on the field, and change the formula to Average, not the default SUM.

    Which report are you using to produce this data, i would suggest you try another, or download one of the ones from SupportNet as this should eliminate the need to manually edit the data.

  8. #7

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    440
    Thank Post
    112
    Thanked 13 Times in 13 Posts
    Rep Power
    8
    No sorry i got it wrong. It was counting up the instances instead of the values in the cells e.g. there were 5 rows for a student but one of the rows had 2 house points so the value should be 6 and not 5 :S

  9. #8

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    440
    Thank Post
    112
    Thanked 13 Times in 13 Posts
    Rep Power
    8
    How can i get it to total the house points awarded this academic year. I have got the year filter but can't see how i get it to total house points instead of showing individual points awarded? Cheers

  10. #9

    Join Date
    Jan 2009
    Location
    Gravesend
    Posts
    99
    Thank Post
    3
    Thanked 18 Times in 8 Posts
    Rep Power
    14
    Can you not do this in Sims Discover?

    I have only played in discover for a very short period of time just to check that data was coming through correctly but seem to remember behaviour and achievements were part of this software.

  11. #10

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    440
    Thank Post
    112
    Thanked 13 Times in 13 Posts
    Rep Power
    8
    I'm fairly new to sims so sims discover is a whole new world. I'll have a look though. Thanks

    Also managed to get the output i needed. Was using the wrong points option when creating the report. Still need to use some functions in excel to delete duplicates but getting there.

    Cheers

  12. #11

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,247
    Thank Post
    33
    Thanked 335 Times in 225 Posts
    Rep Power
    75
    The other thing that you should look at are the home page panels - one of these shows achievements/behaviour year to date today etc. It can be customised for a tutor, year or house head depending on the group of children you are interested in.

  13. #12

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Have a look on SupportNet there are loads of reports on there. You can try and create your own from the Conduct Area, but it will be easier to use one that has been tried and tested already. There are two that seem to be popular uploaded under file sharing as file #s 859 and 871.
    SupportNet

  14. #13

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    440
    Thank Post
    112
    Thanked 13 Times in 13 Posts
    Rep Power
    8
    I have registered for support net but it takes 24-48 hours to become active so will try those reports Monday hopefully! Cheers

  15. #14
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,116
    Thank Post
    414
    Thanked 149 Times in 147 Posts
    Blog Entries
    3
    Rep Power
    59
    Attached image of how I've a report set up which seems to do what your after.

    Bascially, from the student details under Conduct, there's an option which is Total Achievement Points which seems to be automatically filtered on the current academic year.

    sims-achieve-points.jpg
    Attached Images Attached Images

  16. #15

    Join Date
    May 2011
    Location
    United Kingdom
    Posts
    440
    Thank Post
    112
    Thanked 13 Times in 13 Posts
    Rep Power
    8
    When i use a report like the one you have posted the total points column is blank :S ANy ideas? Cheers

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. [SIMS] Sims report ignoring my filters? [SOLVED]
    By localzuk in forum MIS Systems
    Replies: 4
    Last Post: 15th November 2010, 01:00 PM
  2. Replies: 1
    Last Post: 21st April 2010, 06:49 PM
  3. SIMS report issue
    By localzuk in forum MIS Systems
    Replies: 2
    Last Post: 8th May 2009, 11:49 AM
  4. Replies: 14
    Last Post: 19th November 2008, 05:52 PM
  5. SIMS report display/export issues
    By ndavies in forum MIS Systems
    Replies: 15
    Last Post: 17th March 2008, 04:28 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •