+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Reporting on Exclusions in Technical; Quick question for those who use Reporting. Is there a way in SIMS that allows you to directly report on ...
  1. #1
    CAM is offline

    Join Date
    Mar 2008
    Thank Post
    Thanked 411 Times in 311 Posts
    Blog Entries
    Rep Power

    Reporting on Exclusions

    Quick question for those who use Reporting.

    Is there a way in SIMS that allows you to directly report on exclusions? SLT want fixed term exclusions over the past three years and what year groups the kids were in when they were excluded. I tried to report by student and include the Exclusions sub-report but this only returned current on-roll students and the year group doesn't change by academic year (so someone excluded in Year 9 two years ago would show as Year 11 over all three years which isn't what we are after).

    Any ideas? Thanks in advance.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Saudi Arabia
    Thank Post
    Thanked 1,467 Times in 1,219 Posts
    Rep Power
    When you start creating the report based on Student focus, the first screen sets the group you want, and it defaults to On Roll, if you change this to all, you can capture any students even leavers.

    The problem with this is that they then confuse your data, so there is going to be some manual configuration. You can either run two reports, one for current students, and one for Leavers, or whack them all together.

    I would pull out Year Group at DOL and Year of Leaving and Leaving Date from the student section as well as On Roll in case you want a simple switch for any conditions.
    On the Exclusions sub-query, pull out Academic year and Term, so regardless of the current year / year on leaving, you can look back to the academic year, plus whatever else you need.

    You'll have to drag in the current academic year and do some maths or just hard code it to 2013 and only take the first 4 chars from the exclusion academic year, so you can work out how many years ago the event was. If you only want to look at the last three years hard coding shouldn't be a big deal and hopefully you can re-jig the info quite easily.

    It's not as nice as a straight forward report that just works, but you could whack it into a macro enabled report template once you've sussed out what calculations you need.

    Hopefully you don't have so many that it becomes a nightmare.

  3. Thanks to vikpaw from:

    CAM (11th April 2014)

+ Post New Thread

Similar Threads

  1. Usage reports on for OS X?
    By Gilleen in forum Mac
    Replies: 5
    Last Post: 4th March 2009, 10:52 AM
  2. Replies: 2
    Last Post: 4th December 2007, 02:16 PM
  3. Office Error Report on Clipart Search
    By jcook117 in forum Windows
    Replies: 0
    Last Post: 19th January 2007, 11:03 PM
  4. Becta's Report on MS software being value of money
    By spc-rocket in forum Educational Software
    Replies: 12
    Last Post: 6th December 2006, 07:49 PM
  5. Replies: 3
    Last Post: 16th November 2006, 07:35 PM

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