+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Individual Reports in SIMS in Technical; Hi guys, I know there's an option to remove rows of a table that contain no results; but is it ...
  1. #1

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Individual Reports in SIMS

    Hi guys,

    I know there's an option to remove rows of a table that contain no results; but is it possible to remove rows of a table that contain no specific result?

    For example, I'm creating a table with every subject, after which target data is displayed (imported from spreadsheets). On every row is an Alis prediction, and (for efficiency reasons) every student has a Alis prediction (result) for every subject - even if they don't take it.

    This means every row will feature an Alis prediction, even though I only want those with the target data to appear.

    Is there a way to do this?

    Cheers,

    Tom

  2. #2

    Join Date
    Nov 2011
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Possibly too late for you.....
    We also have targets for all subjects, regardless of who follows a course.

    In the marksheet template we have another target aspect that uses a formula to copy the original. As a result, only students who are on the marksheet get the second target, this is the one we use in the individual report.

  3. #3

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    @Ashton_Man
    You've hit the nail on the head, it's usually easier to open up subject based marksheets (or repeatedly apply filters) with that second column and copy paste over predictions so they only get it for subjects they do.

    SIMS doesn't let you programatically remove rows. The hide rows option will work with the system of the students not having a prediction and it removes that line.
    @tben2505 When you say import from spreadsheets, do you mean marksheets, or are you doing some kind of scripting to pull in grades externally? If you're doing that, then you could do some more coding and perhaps achieve what you want.

    It's probably not too late to make a new aspect for 'school' prediction, the benefit of this is, we would let teachers alter that prediction based on their experience. Usually only upwards - but in rare instances down. This means you retain the original prediction from the system you're using and can have a set of 'school' ones based on your own targets for a teacher, subject, school as a whole.

  4. #4

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I get what you mean guys - but allowing staff to alter predicted grades wouldn't sit so well at the moment - it's quite new that we're integrating them more so I think that would be too much too soon for them here!!

    Thanks for you

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    You don't have to let them do it, i'm just saying that's an additional benefit of cloning the calculated prediction. Cloning helps you out of your issue with filtering out subjects they don't study.

  6. #6

    Join Date
    May 2011
    Location
    London
    Posts
    89
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I see, so clone the prediction in the subject-only marksheets into another column, and use THAT column as the prediction for reports?!

    Yes... clever!

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Absolutely. So for example. Create a master template with all alis prediction columns and next to them the school prediction columns or whatever you want to call them. apply it to a year group. then filter for students of maths. copy alis maths prediction to school maths prediction. refilter recopy. it is a slow one, and could be done in a number of other ways, i.e. permanently put alis / school columns in all course / class marksheets then just flick through and copy paste. depends on if you want the final column to be read only or not.

  8. #8

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    244
    Thank Post
    23
    Thanked 36 Times in 27 Posts
    Rep Power
    20
    You can use the formula method and a separate aspect (or resultset, depending on how you've set things up), and make the formula read-only, so that staff CANNOT change the target, if that's what you want to do.

    I use the same technique with an EQUALS formula to copy a KS4 FFT target into a subject-specific one; one of the great things about doing this, is that you can allow staff to enter a target for students who have no Alis data, but to have whatever they enter overwritted if there's Alis data available.

    Best of both!

    Or, you can just hide the formula column, and then it will copy the data to where you want it, but not allow any entry by staff.

  9. Thanks to MattMitchell from:

    vikpaw (6th March 2012)

  10. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I like that idea of using a resultset.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Reporting in SIMS Help
    By 01hanstu in forum MIS Systems
    Replies: 30
    Last Post: 12th October 2011, 09:42 PM
  2. Example Assessment Reports in SIMS
    By garethedmondson in forum MIS Systems
    Replies: 5
    Last Post: 7th November 2009, 11:47 AM
  3. Reporting in SIMS FMS
    By cjohnsonuk in forum MIS Systems
    Replies: 1
    Last Post: 21st April 2009, 02:49 PM
  4. Deleting Reports in SIMS
    By enjay in forum MIS Systems
    Replies: 15
    Last Post: 23rd March 2009, 08:52 AM
  5. Auto-reporting in SIMS and permissions
    By Oops_my_bad in forum MIS Systems
    Replies: 2
    Last Post: 20th March 2008, 07:28 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
  •