+ 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,487
    Thank Post
    1,445
    Thanked 1,182 Times in 809 Posts
    Rep Power
    709
    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,173
    Thank Post
    839
    Thanked 364 Times in 285 Posts
    Blog Entries
    60
    Rep Power
    282
    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
    6,008
    Thank Post
    680
    Thanked 1,397 Times in 1,157 Posts
    Rep Power
    353
    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
  •