+ Post New Thread
Results 1 to 9 of 9
Windows Thread, medical room database in Technical; Our medical room has for many years recorded all pupil incidents on paper. Last year i used my basic Access ...
  1. #1

    Join Date
    Feb 2007
    Location
    Hereford
    Posts
    213
    Thank Post
    5
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    medical room database

    Our medical room has for many years recorded all pupil incidents on paper.
    Last year i used my basic Access knowledge to create a database for recording these incidents and then being able to print reports off about individual pupils etc.
    How ever its not realy powerful enough.

    Has any one else got some sort of software for recording cuts and falls etc or when pupils are sent home etc.

    We run serco facilty. I'm suprised they don't do a plugin for such data.

  2. #2

    DaveP's Avatar
    Join Date
    Oct 2006
    Location
    Can't talk now: The mother-ship is calling!
    Posts
    8,781
    Thank Post
    351
    Thanked 1,274 Times in 870 Posts
    Blog Entries
    4
    Rep Power
    1126
    I have just checked with our Matron. Here is what she does:

    Login to the facility as normal. Select 'Students', Then 'Main Window' Once in there select the 'Medical' tab. See attached pictures.
    Attached Images Attached Images
    Last edited by DaveP; 10th January 2008 at 12:39 PM. Reason: Amend [update] content of post.

  3. #3

    Join Date
    Mar 2007
    Posts
    323
    Thank Post
    6
    Thanked 7 Times in 6 Posts
    Rep Power
    16
    This is odd because 5mins ago I was talking to the new school nurse who asked if we had a medical database where she can basically keep track of students.. how many times they have visited etc and the problems.

    So I initally thought... ooh Im going to have to create one. But then I thought sims may already have such feature. It does but its not confidential and anybody with sims access can see the students records.

    I'm still looking for a solution.

  4. #4


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,629
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223
    @techyphil

    Yeah, the medical part in SIMS is for emergencies and/or allergies and the basic "Class Teacher" access is read-only. So if a kid has a medical condition (diabetes / allergies / exploding heads) staff know "ah, Jimmy is having an exploding head problem" and take the appropriate action.

    There is a function to attach notes, and I think that's used for incident reporting here.

    The impression I get is (non-emergency) appointments with our school nurse are often about things the kids don't want to discuss with their family doctor / parents / school*. Storing such data on school systems tends to undermine that.

    *We have a nurse come in from outside every week/couple of weeks.

  5. #5
    MattGibson's Avatar
    Join Date
    May 2008
    Location
    Epsom
    Posts
    169
    Thank Post
    20
    Thanked 11 Times in 8 Posts
    Rep Power
    15
    Did anybody ever find any software for this its a real shame that SIMS doesn't have a section such as a 'LINK' to a medical module just to keep everything under one umbrella.

    I'm also looking into this now but it seem nothing exists?

    Cheers
    Matt

  6. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    You can add medical notes to a students detail page in Sims and set it as either confidential or public info, or am I missing the point?

  7. #7
    MattGibson's Avatar
    Join Date
    May 2008
    Location
    Epsom
    Posts
    169
    Thank Post
    20
    Thanked 11 Times in 8 Posts
    Rep Power
    15
    Hi JoshJohnson,

    No your not missing the point. I see where you are coming from but we've been asked to log every student that goes to the medical room and to keep a log of all the medicines we hold for the students in the school.

    Basically it was our Business Manager that said we will soon be required to have all this information. I was hoping somebody may have created something or know of any software ?

  8. #8

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    So is it that you don't like the way you have to enter this info in to Sims, or you want a better way of looking at this info once it's entered? (i.e. view a list of students who you're holding medicine for as opposed to going in to individual student detail pages)

    If it's the latter, have you considered using Access along with a couple of Sims XML reports to give you some more freedom over how you can get the info you need?

    I've made something along those lines recently because Sims reports can be a bit counter intuitive at times...

  9. #9
    MattGibson's Avatar
    Join Date
    May 2008
    Location
    Epsom
    Posts
    169
    Thank Post
    20
    Thanked 11 Times in 8 Posts
    Rep Power
    15
    Hi John,

    Basically Sims student profile is very limited on what information it can hold. It don't give you the flexibility to hold student medicines shuch as Type of Medicene, Expiary Date, Amount Administered and Side Effects. The we have the same problem for when a student comes into the medical room we have an excel spreadsheet where all the data in being input by the office staff.

    Cheers,

    Matt

SHARE:
+ Post New Thread

Similar Threads

  1. Room Booking Database/Web based (.asp)
    By danIT in forum Downloads
    Replies: 131
    Last Post: 7th November 2007, 10:20 AM
  2. Room 101...
    By Gatt in forum General Chat
    Replies: 105
    Last Post: 30th October 2007, 11:41 AM
  3. IT Room Furniture
    By Vegas in forum General Chat
    Replies: 4
    Last Post: 12th June 2007, 03:35 PM
  4. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  5. Music Room PC's
    By plexer in forum Hardware
    Replies: 7
    Last Post: 22nd May 2006, 12:53 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
  •