+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 25
MIS Systems Thread, Seating Plans - Is This Smart? in Technical; 1) Export department tracking sheet in the form of a SIMS marksheet with student details and seat number into MySQL ...
  1. #1
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,425
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328

    Seating Plans - Is This Smart?

    1) Export department tracking sheet in the form of a SIMS marksheet with student details and seat number into MySQL
    2) Connect to MySQL with a spreadsheet or custom application to automatically generate seating plans?

    Is this secure and a good idea or a terrible road to go down? And how simple would it be to run? I'd love to do something like this so SIMS automatically puts the data into an external database that runs parallel to SIMS each night so I can connect to it with more advanced systems then manually exporting and altering spreadsheets.

  2. #2

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,281
    Thank Post
    405
    Thanked 417 Times in 337 Posts
    Blog Entries
    8
    Rep Power
    191
    I may regret asking this mate.. why?

  3. #3
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,425
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328
    Because I keep getting asked if there is a way to automatically update seating plans which won't work in SIMS because I can't tap directly into the database.

  4. #4

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,281
    Thank Post
    405
    Thanked 417 Times in 337 Posts
    Blog Entries
    8
    Rep Power
    191
    So is this class seating plans? How do you display them? I know i can't give you an answer I'm very interested in the solution and the reasoning for the requirement!

  5. #5
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,425
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328
    Teachers do it in Excel at the moment. They make their markbook in order of what seat the kids occupy as each row has a number according to the seat. Then using borders, they make a mock seating plan on a second sheet using VLOOKUP that was set up by a member of SLT. The seating grid isn't bad but teachers are storing data in a most horrible way! (Colours everywhere, not flush against A1, bad titles, etc).

    If I can store the data in a database that automatically updates each night and plug a seating system into it I can make something much more reliable and functional.

    I also have a really large spreadsheet that shows student data to staff. If I can improve that by storing it properly in a database that will help too!
    Last edited by CAM; 4th September 2013 at 09:01 AM.

  6. #6

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,281
    Thank Post
    405
    Thanked 417 Times in 337 Posts
    Blog Entries
    8
    Rep Power
    191
    Got it. But the you would want the data coming back from excel into the db yes? So teachers can make changes?

    What you need is an MIS that has this ready made and built in ;-) haha!

  7. #7

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    351
    The way you are most likely going to have to do it is using Commandreporter.exe to export a CSV. You then have to import the CSV into mysql and work your magic.

    The biggest head ache would be having to have plans for each layout that a teacher decides to have there room.

  8. Thanks to glennda from:

    CAM (4th September 2013)

  9. #8
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,425
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328
    So it would be safe to do from a DPA point of view?

  10. #9

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,821
    Thank Post
    272
    Thanked 1,140 Times in 1,036 Posts
    Rep Power
    351
    Quote Originally Posted by CAM View Post
    So it would be safe to do from a DPA point of view?
    In theory but you would need to check - obviously it would need to be secure.

  11. #10

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,404
    Thank Post
    38
    Thanked 387 Times in 262 Posts
    Rep Power
    85
    Names aren't generally a problem with DPA its when you start to include personal data such as SEN, ethnicity, pupil premium that it becomes a major issue.

  12. Thanks to PhilNeal from:

    CAM (4th September 2013)

  13. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    You don't have a VLE that plugs in to SIMS and does this sort of fancy stuff for you?

  14. #12
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Reigate Area, Surrey
    Posts
    4,425
    Thank Post
    884
    Thanked 416 Times in 316 Posts
    Blog Entries
    61
    Rep Power
    328
    Sadly not. Our VLE is Fronter which isn't the best tool in the box for anything.

  15. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,956
    Thank Post
    775
    Thanked 1,487 Times in 1,234 Posts
    Rep Power
    367
    Quote Originally Posted by CAM View Post
    Sadly not. Our VLE is Fronter which isn't the best tool in the box for anything.
    I thought Fronter had the most modules ever, maybe you just don't pay for them all
    There's an interesting thread on SupportNet - Room Seating Plan with Photo and Data (39372)

  16. #14

    Join Date
    Mar 2010
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We export from SIMS and use MAP Learners which is secure. It will do seating plans as well as various other reports for teachers and HODs.

  17. #15

    Join Date
    Mar 2012
    Posts
    68
    Thank Post
    24
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Why don't you use Exams? Or is that a daft question?



SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. Deploying MSI - Is this accurate?
    By _Bat_ in forum Windows
    Replies: 3
    Last Post: 18th December 2006, 06:34 PM
  2. Is this an unusual thing to do?
    By Norphy in forum Hardware
    Replies: 21
    Last Post: 17th May 2006, 09:52 AM
  3. Is this DNS poisoning?
    By darkstar in forum Windows
    Replies: 27
    Last Post: 4th April 2006, 10:04 PM
  4. Is This A Network Problem ?
    By Pear in forum Windows
    Replies: 21
    Last Post: 12th December 2005, 04:01 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
  •