+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, FFT Data into SIMS in Technical; Hi All, Does anyone know of an easy/quick way to get the data from FFT Live website into SIMS? As ...
  1. #1

    Join Date
    Jan 2012
    Location
    Faversham
    Posts
    44
    Thank Post
    3
    Thanked 7 Times in 7 Posts
    Rep Power
    7

    FFT Data into SIMS

    Hi All,

    Does anyone know of an easy/quick way to get the data from FFT Live website into SIMS? As the spreadsheet that is exported is not condusive to easy importing.

    Regards,

    jrma

  2. #2

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,618
    Thank Post
    845
    Thanked 881 Times in 731 Posts
    Blog Entries
    9
    Rep Power
    326
    SIMS FFT Estimates | capita-sims.co.uk

    We've just bought in to this which is about 6-700/yr on a 3yr contract (from memory). I used to create my own Aspect and import them one at a time by hand - very long winded!

  3. #3

    Join Date
    Jun 2010
    Location
    Leicestershire
    Posts
    152
    Thank Post
    17
    Thanked 18 Times in 16 Posts
    Rep Power
    12
    Id' be interested in this, my current method is to export as a CSV and then change the data, add admission number etc, and import from there

  4. #4

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    22
    The procedure I use is as follows:
    Set up a marksheet template in SIMS containing the FFT aspects, eg EstD Maths GCSE etc.
    Add a mark sheet for the year group, eg year 10
    Export the formatted mark sheet
    Export the data from FFT as an Excel sheet and tidy it up so that it contains the data I want.
    Match the data in the FFT sheet with the data in the formatted mark sheet and copy into the correct columns
    Import the formatted mark sheet using the Import from Spreadsheet. As I am using a formatted sheet the columns will match

    It seems a long winded process but I use macros to tidy the exported FFt data and it does not take too long once this has been done, perhaps 5 to 10 minutes per subject.
    The more complex part is making sure that the pupils have only got the FFT grades for subjects they study. What I do keep the FFT data in a different aspect to the GCSE target. Eg every pupil will have a grade for the Est D FFT Spanish aspect but this is only copied into the Spanish GCSE target aspect for those studying Spanish.

  5. #5

    Join Date
    Jan 2012
    Location
    Faversham
    Posts
    44
    Thank Post
    3
    Thanked 7 Times in 7 Posts
    Rep Power
    7
    I have the aspects all set up in SIMS, as I have entered the data before from a spreadsheet. But the person who retrieved the data and put it into a spreadhseet has left since last year without telling me how he got the data from thr FFT Live format, to a more managable one to import into SIMS.

    I have now used VLookup -> Pivot Table-> VLookup to get the format that I want!

    number 34, I do not know enough about Macros to be able to do it that way! But thank you for the help!

    regards,

    jrma

  6. #6

    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 did it exactly as @number34 described, and still use the same method for other imports, e.g. our iGCSE grades which get sent in on Excel.

  7. #7

    Join Date
    Sep 2006
    Location
    Reading
    Posts
    177
    Thank Post
    14
    Thanked 41 Times in 39 Posts
    Rep Power
    22
    Quote Originally Posted by jrma91 View Post
    number 34, I do not know enough about Macros to be able to do it that way! But thank you for the help!
    jrma
    This is not as difficult as it sounds. As all of the Excel sheets I export from FFT are exactly the same size and format I just used the record macro when doing all the initial tidying before copying and pasting into the formatted mark sheet. Once I have completed the first, 'Art' say, I export the Biology data from FFt, copy it into the Art sheet and let the macro do its work. Nothing fancy or clever. Just remember to save the 'Art' one as macro ennabled and you can then use it again and again. It is just a transient sheet that is used to get the data in the correct format to be copied into the formatted mark sheet. It is worth trying as once it is sorted it saves a tremendous amount of time.

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, 02:07 PM
  2. [SIMS] Import into sims.net diary
    By philjones2000 in forum MIS Systems
    Replies: 9
    Last Post: 9th March 2011, 10:57 AM
  3. [ACS] Importing data from FFT live into CMIS Facility
    By WOW_freak in forum MIS Systems
    Replies: 7
    Last Post: 8th November 2010, 08:16 AM
  4. Replies: 24
    Last Post: 14th January 2010, 04:20 PM
  5. Importing new aspect data into SIMS
    By MattMitchell in forum MIS Systems
    Replies: 1
    Last Post: 21st May 2009, 08:30 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
  •