+ 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
    Burgh Heath, Surrey
    Posts
    4,120
    Thank Post
    826
    Thanked 358 Times in 282 Posts
    Blog Entries
    60
    Rep Power
    281

    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,044
    Thank Post
    374
    Thanked 373 Times in 304 Posts
    Blog Entries
    8
    Rep Power
    177
    I may regret asking this mate.. why?

  3. #3
    CAM
    CAM is offline

    CAM's Avatar
    Join Date
    Mar 2008
    Location
    Burgh Heath, Surrey
    Posts
    4,120
    Thank Post
    826
    Thanked 358 Times in 282 Posts
    Blog Entries
    60
    Rep Power
    281
    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,044
    Thank Post
    374
    Thanked 373 Times in 304 Posts
    Blog Entries
    8
    Rep Power
    177
    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
    Burgh Heath, Surrey
    Posts
    4,120
    Thank Post
    826
    Thanked 358 Times in 282 Posts
    Blog Entries
    60
    Rep Power
    281
    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 08:01 AM.

  6. #6

    GREED's Avatar
    Join Date
    Mar 2008
    Location
    Portsmouth
    Posts
    3,044
    Thank Post
    374
    Thanked 373 Times in 304 Posts
    Blog Entries
    8
    Rep Power
    177
    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,810
    Thank Post
    272
    Thanked 1,135 Times in 1,031 Posts
    Rep Power
    349
    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
    Burgh Heath, Surrey
    Posts
    4,120
    Thank Post
    826
    Thanked 358 Times in 282 Posts
    Blog Entries
    60
    Rep Power
    281
    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,810
    Thank Post
    272
    Thanked 1,135 Times in 1,031 Posts
    Rep Power
    349
    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,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79
    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,974
    Thank Post
    674
    Thanked 1,384 Times in 1,146 Posts
    Rep Power
    350
    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
    Burgh Heath, Surrey
    Posts
    4,120
    Thank Post
    826
    Thanked 358 Times in 282 Posts
    Blog Entries
    60
    Rep Power
    281
    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,974
    Thank Post
    674
    Thanked 1,384 Times in 1,146 Posts
    Rep Power
    350
    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
    46
    Thank Post
    17
    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, 05:34 PM
  2. Is this an unusual thing to do?
    By Norphy in forum Hardware
    Replies: 21
    Last Post: 17th May 2006, 08:52 AM
  3. Is this DNS poisoning?
    By darkstar in forum Windows
    Replies: 27
    Last Post: 4th April 2006, 09:04 PM
  4. Is This A Network Problem ?
    By Pear in forum Windows
    Replies: 21
    Last Post: 12th December 2005, 03: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
  •