+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, SIMS house points report in Technical; Where can I find a SIMS report to show total house points for a house?...
  1. #1

    Join Date
    Oct 2012
    Location
    Accrington
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS house points report

    Where can I find a SIMS report to show total house points for a house?

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,452
    Thank Post
    1,439
    Thanked 1,170 Times in 798 Posts
    Rep Power
    707
    I think you'll have to make one.

    Focus > Student > On Roll

    Fields: admission number, house, total achievement points

    Output: excel

    Then pivot the output in excel, House as column, points as data. Done!

  3. #3
    cromertech's Avatar
    Join Date
    Dec 2007
    Location
    Cromer by the coast
    Posts
    731
    Thank Post
    177
    Thanked 109 Times in 97 Posts
    Rep Power
    54
    We have one as an analysis report if this helps. You may need to edit slightly

    HP total by date and house (all students.zip

  4. #4

    Join Date
    Oct 2012
    Location
    Accrington
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thank you, unfortunately when pivoted the points become a count of occurences i.e.1 rather than adding the actual values.

  5. #5

    Join Date
    Oct 2012
    Location
    Accrington
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thank you managing to get achievement and behaviour totals per pupil and totals.

  6. #6
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,114
    Thank Post
    826
    Thanked 357 Times in 281 Posts
    Blog Entries
    60
    Rep Power
    281
    Use the following formula at the bottom of your list of points values:

    Code:
    =SUBTOTAL(9,range)
    Then filter the sheet by house. This will add up the numbers which are visible to give you a total for each house.

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I'm sure you can alter what the pivot table does with the values, you should be able to make it sum.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Command Reporter to pull sims to mrbs report
    By glennda in forum MIS Systems
    Replies: 5
    Last Post: 24th July 2012, 03:44 PM
  2. [SIMS] Sims Lesson / Attendance Report
    By IrritableTech in forum MIS Systems
    Replies: 10
    Last Post: 4th May 2012, 01:38 PM
  3. Replies: 17
    Last Post: 31st October 2011, 06:56 PM
  4. [SIMS] SIMs and Command Reporter
    By RuAware in forum MIS Systems
    Replies: 43
    Last Post: 25th February 2011, 06:57 PM
  5. [SIMS] Sims Acheivement Points Report
    By Jamie_a in forum MIS Systems
    Replies: 17
    Last Post: 29th December 2010, 10:12 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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