+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Exporting Exam Results (SIMS)... in Technical; Hi guys, For August, I am trying to get onto a spreadsheet the all current upper 6th pupils' KS5 module ...
  1. #1

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

    Exporting Exam Results (SIMS)...

    Hi guys,

    For August, I am trying to get onto a spreadsheet the all current upper 6th pupils' KS5 module results (from AS and A2), with the following columns;

    Name of student
    Reg
    Module name
    Subject
    Level
    Board
    Result set
    Result
    Grade equiv

    Obviously there'll be about a dozen or so rows per pupil.

    Seems straightforward - and I can run a report which returns this - however it also returns everything else the pupil has in Assessment manager, so as you can expect it returns an awful lot of data!

    Does anyone have any ideas on how best to do this - or better still has a report I can import directly?!

    On EO we can get a candidate results sheet but it only shows the modules from EITHER AS or A2 - and not both which is what we want - and we also want it on a nice editable excel sheet, rather than the very poorly presented version which is exported from the candidate result sheer on EO!

    Cheers guys any help greatly appreciated,

    We are in the process of getting a new MIS so are currently running (for a number of reasons):
    SIMS
    Build 31
    Version 7.176
    Database 3.62.147

  2. #2
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,286
    Thank Post
    868
    Thanked 395 Times in 305 Posts
    Blog Entries
    60
    Rep Power
    288
    Can you post what filters you are using?

  3. #3

    Join Date
    May 2011
    Location
    London
    Posts
    92
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I think this is the problem I'm having

    I can't seem to find a way to filter by the result sets I want, or ideally the level (A2/AS) with just results, and no entries/forecast etc etc...that's why EVERYTHING is coming out!

    T

  4. #4
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,286
    Thank Post
    868
    Thanked 395 Times in 305 Posts
    Blog Entries
    60
    Rep Power
    288
    I'm assuming you are using Student Focus and with an Assessment Results subreport (has a blue square next to it). Click on the subreport after adding it to your fields list and on the right is a small button with a red book. Click that and a window appears at the bottom where you can apply filters to subreports. This will allow you to filter by any of the columns found under the Assessment Results category.

    You can also add multiple subreports, one for each subject, with a different set of filters to stop all the data being pushed into one column. Beware of the column limits though.

  5. #5

    Join Date
    May 2011
    Location
    London
    Posts
    92
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by CAM View Post
    I'm assuming you are using Student Focus and with an Assessment Results subreport (has a blue square next to it). Click on the subreport after adding it to your fields list and on the right is a small button with a red book. Click that and a window appears at the bottom where you can apply filters to subreports. This will allow you to filter by any of the columns found under the Assessment Results category.

    You can also add multiple subreports, one for each subject, with a different set of filters to stop all the data being pushed into one column. Beware of the column limits though.
    Oooh I like the sound of that - will give it a go and report back! Cheers CAM!

    T

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS : I cannot Add an Exam Results Aspect to a Marksheet/Template
    By bwfc_nottingham in forum MIS Systems
    Replies: 2
    Last Post: 24th June 2013, 04:31 PM
  2. [SIMS] Extract Exam Results from SIMS
    By CAM in forum MIS Systems
    Replies: 2
    Last Post: 9th March 2013, 09:34 AM
  3. [SIMS] Sims.Net Exam results patch
    By RichB in forum MIS Systems
    Replies: 1
    Last Post: 16th August 2011, 10:22 AM
  4. [SIMS] Exam Results Seasons
    By TechMonkey in forum MIS Systems
    Replies: 11
    Last Post: 17th August 2010, 09:50 PM
  5. Replies: 4
    Last Post: 31st August 2007, 11:31 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
  •