+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Alis predictions into SIMS in Technical; Ok so I am wondering if I am missing a trick. Every year we get our ALIS data in a ...
  1. #1

    Join Date
    Mar 2012
    Posts
    68
    Thank Post
    24
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Alis predictions into SIMS

    Ok so I am wondering if I am missing a trick. Every year we get our ALIS data in a ridiculous format that I have to fiddle with before it goes into SIMS. Last year I converted all the grades to numbers and hoiked it into a pivot table then converted it all back again, which gave me a nice CSV file.

    It isn't working this year and I need the data in there. What does everyone else do?!

    Ever hopeful.

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,771
    Thank Post
    1,511
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    It's been a while since I used ALIS, but I don't remember it being any more problematic than any other result set - don't they provide an Excel/CSV list of students and targets?

  3. #3

    Join Date
    Mar 2012
    Posts
    68
    Thank Post
    24
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Yes but it is one line per child and subject so needs to be pivoted to get subjects in columns and pupils in rows

  4. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,771
    Thank Post
    1,511
    Thanked 1,294 Times in 884 Posts
    Rep Power
    813
    Quote Originally Posted by CarpeDiem View Post
    Yes but it is one line per child and subject so needs to be pivoted to get subjects in columns and pupils in rows
    Ahhh OK I'm with you now; I'm afriad the only way I know is a pivot, however I'm not sure how you do yours but my method is quite quick:

    - create a unique ID for the row, usually a combination of student ID, and subject name concatenated. Make that column A
    - create your pivot with student ID as row and subject name as column
    - copy the whole sheet and paste as values
    - do a vlookup on the concatenated student ID and subject name in the first empty cell, locking the column on student ID and the row for subject name
    - copy and paste to fill your table
    - copy and paste all your lookups as values
    - do a "Find & Replace" to change all #N/As to empty fields

    I do that quite regularly with such data, it sounds long winded but once you have the knack, it'll take 5 minutes no matter how large a data set you're working with. I'll send you an example if you like with each stage on a separate sheet (if my explanation isn't clear)

  5. Thanks to LosOjos from:

    CarpeDiem (16th October 2013)

  6. #5

    Seb1780's Avatar
    Join Date
    May 2013
    Location
    Suffolk
    Posts
    323
    Thank Post
    136
    Thanked 126 Times in 98 Posts
    Rep Power
    106
    Sort original by subject / pupil
    Copy each pupil / subject / prediction to another area of the sheet
    Resort original list to Pupil
    Use VLOOKUP in each column to create table type spreadsheet looking up from the copied subject tables

    Simples

  7. Thanks to Seb1780 from:

    CarpeDiem (16th October 2013)

  8. #6

    Join Date
    Oct 2013
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    I export the marksheet(s) from the subjects and copy the relevant data from ALIS across. If the subject is only taken by a few students it is easier to manually enter the data into SIMs



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Importing Email Addresses into Sims.NET
    By Geoff in forum MIS Systems
    Replies: 49
    Last Post: 27th September 2012, 03:07 PM
  2. [SIMS] Importing pictures into sims?
    By Intelatech in forum MIS Systems
    Replies: 4
    Last Post: 23rd November 2011, 02:35 PM
  3. [SIMS] Batch Import Formatted Excel Marksheets into SIMS?
    By tben2505 in forum MIS Systems
    Replies: 10
    Last Post: 15th November 2011, 03:31 PM
  4. [SIMS] License file needed for Photo inport into SIMS
    By timbo343 in forum MIS Systems
    Replies: 5
    Last Post: 23rd September 2011, 07:24 PM
  5. [SIMS] Import into sims.net diary
    By philjones2000 in forum MIS Systems
    Replies: 9
    Last Post: 9th March 2011, 11:57 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
  •