+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, Extract Exam Results from SIMS in Technical; I think I'm having an absent minded moment here. Sure I've done it before but neither me nor my Exams ...
  1. #1
    CAM is online now

    CAM's Avatar
    Join Date
    Mar 2008
    Burgh Heath, Surrey
    Thank Post
    Thanked 372 Times in 288 Posts
    Blog Entries
    Rep Power

    Extract Exam Results from SIMS

    I think I'm having an absent minded moment here. Sure I've done it before but neither me nor my Exams Officer can find a way to get exams results from SIMS into a nice table format. Any idea how we do this?

    I can get the candidate statement of results but exporting them as CSV devolves into a horrifying mess of cells scattered across the entire worksheet.

    I want to analyse them either in Excel or Assessment Manager (latter ideal!).

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    West Midlands
    Thank Post
    Thanked 1,197 Times in 812 Posts
    Rep Power
    You have a couple of options, try them out and see which you prefer.

    In Exams Module, go to Reports > Results then choose:

    • Certification Broadsheet
    • Export Results

    The former gives you more useful names for qualifications, but I'm not convinced it gives you everything. The latter gives you everything for the chosen season, but relies heavily on you knowing exam codes to identify them.

    Personally, I like to use "Reports > Results > Performance Tables", then set type as "Full". That way, you get absolutely everything, leaving you free to filter and format to your hearts content in Excel (it's all in a big list as opposed to a table, though you can pivot it in to a table and use a vlookup to pick up the results)
    Last edited by LosOjos; 7th March 2013 at 12:56 PM. Reason: Grammar

  3. Thanks to LosOjos from:

    CAM (7th March 2013)

  4. #3

    Join Date
    Sep 2010
    Thank Post
    Thanked 0 Times in 0 Posts
    Rep Power

    You can access exam results in Assessment Manager directly. All exam modules and final results are allocated their own separate aspect. Module/partial unit results are usually in lower case and final results in upper case. You obviously need to know the name of the aspect but that information is in Exam Organiser. This process will be even more useful and straightforward when the modular exams come to an end in the near future.

    We build the AM templates after the exam entry deadline and let it do its thing when the results come out. This then allows analysis by the usual student filters.



+ Post New Thread

Similar Threads

  1. Extracting Timetable From Sims
    By sammy42 in forum CLEO
    Replies: 0
    Last Post: 22nd November 2012, 09:44 AM
  2. [SIMS] Sims.Net Exam results patch
    By RichB in forum MIS Systems
    Replies: 1
    Last Post: 16th August 2011, 10:22 AM
  3. Programatic data extraction from SIMS.net Data Base
    By NetworkGeezer in forum MIS Systems
    Replies: 108
    Last Post: 16th February 2010, 09:22 PM
  4. [SIMS] Timetables from SIMS
    By TimH in forum MIS Systems
    Replies: 27
    Last Post: 25th August 2009, 10:38 AM
  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