• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

When I visited my local dental surgery I noticed that they use a manual filing system and I felt that they could benefit from having computerised version, as it would save both time and effort for the receptionists.

Extracts from this document...


Problem identification. When I visited my local dental surgery I noticed that they use a manual filing system and I felt that they could benefit from having computerised version, as it would save both time and effort for the receptionists. The organisation The Dent Care Ltd is a medium size dental surgery based in Burnt Oak. The clinic deals with all aspects of primary dental care that includes regular inspection checks (every 6 months), teeth extraction, fillings, capping and bridging to denture fitting. All work is carried out under local anaesthetic. Where major prolonged work is required they are referred to specialist dental clinic where work can be carried out under sudation. The clinic is owned in partnership by the three dental surgeons and each has a dental nurse and two receptionists all of whom are computer literate and can operate the PC without much difficulty. At the moment, the clinic has an 80386 Compaq PC and a HP desk Jet Printer that the receptionist use for typing letters, invoices using Microsoft Word. The patient's appointments are hand written in a yearly planner that they use. The planner simply has a day and times of 15 mins intervals and 5 columns. The columns are headed with the names of the three Dental surgeons. Data collection To understand the current system, three methods of data collections were considered. 1. Questionnaire to all staff Advantages Disadvantages Quick way of collecting information from large number of people. Difficult to plan questions to collect complex data Useful if people are not available for interviews Cannot probe responses. Useful if people work in different parts of the office. Some find it easier to give honest accurate answers. 2. Interview the staff Advantages Disadvantages If well planned and questions are structured in advance lot of detailed information can be captured. People may not be fully truthful. Allows probing of responses to seek clarification or ask additional questions. People may not feel comfortable being interviewed. Takes up lot of time. ...read more.


i.e. if it has 11 spaces for a telephone or mobile number and you enter twelve it won't let you move on. It also changes mistakes if it thinks they are wrong. What are the differences? * In Access you have to chose a field * In access you have to make the first field the key field which is a unique number so that you can not mistake it for anything else * In Access you have wizards to help you create tables, forms, and reports * Access is a relational database which means you can link together tables * In Access it's easier to do Mail Merge and produce reports. * Excel specializes in number processing and modeling where as access special in data management. Proposed hardware A suitable specification I think they need is: * 512mb RAM, 80 Gb Hard Drive * 2.8 GHz processor * 56K modem, Keyboard, Mouse * 128Mb 3D Video graphics adaptor, 17" flat screen monitor * Ink jet printer * CD RW drive, 1.44Mb floppy * 100Mbit Ethernet network card. Reasons for choosing this specification: Computer is fast and can run all modern software. Large amount of RAM to allow multiple tasks to be run. CD RW drive allows reliable backing ups of data. Network card will be required for multi user system. A large flat screen monitor is selected to save space in a small reception room. A small ink jet printer is selected because the demand for printing is quite small. Proposed Software Specifications * MS Office 2000 professional software suite - MsWord, Excel, PowerPoint, Access, Outlook, * Operating System - Windows XP I have chosen Windows XP, as it is the latest of the Windows. It is easy to use, allows multi-access accounts to be setup for different users. Application Suite, as it is cheaper than buying each program separately. It also allows strong data portability between various applications for example, create process models on spreadsheets, Use Access for patient's records storage and queries and do Mail Merge with Word for generating payment receipts and printing follow-up appointment card. ...read more.


A10. There are the three surgeons, three medical nurse and two of us at reception. A11. We have a list of treatments and prices against them. The surgeon writes down what treatment he has carried out and calculates the total. A12/13. Yes, quite often, all we do is put a diagonal line across it and make a new appointment. If they cancel before 48 hours, we do not charge them, otherwise we charge them �20. Appendix C Notes taken during observation Observing the surgeon: Receptionist takes the notes from the filing cabinet and passes it to the nurse. The surgeon checks his last notes. The nurse calls the patient in. The treatment is carried out and the surgeon writes, the treatment he carried out and indicates if follow-up appointment is needed, he makes a brief notes about what he needs to do next time. The patient leaves the treatment room and the nurse returns the patient file to the receptionist desk. The next patient is the called in. Observing the Dental Nurse: Dental nurses are only involved in fetching and returning the patients records to and from the surgeon and assisting the surgeon. They do not write anything on the patient's notes. Observing the Receptionist: Confirmed what the receptionist said she did with customer handling process. All information given during the interview was correct. Also observed the time wasted when the clinic becomes busy and how frustrated they become having to share a single appointment planner. The times they take to write out the receipt and appointment card is quite effective, but it takes a lower priority to ensuring surgeons receives the patients records and are not waiting. This means keeping the customer waiting longer then is necessary. Customer are frequently kept waiting as they try to pay for treatment or make follow-up appointments. New people arriving are given higher priority. Appendix D: customer Documents collected. Pic of form Dental pics, teeth record Medical history form Appointment list Practice record form Return card for next appointment ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    In fact, it was hoped that a healthy market for third-party software components would develop, allowing even small companies to thrive by authoring niche software components designed to be used by others. Although reality never quite fulfilled the aspirations of some of the visionaries, the ActiveX control and JavaBeans software

  2. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    You can also control the financial system of third-party providers. The System calculates the gross and net pay, which comprises the individual payments and deductions that are calculated during a payroll period, and are received by an employee. These payments and deductions are included in the calculation of the remuneration using different wage types.

  1. Computing Project

    I will also test whether a message pops if the DVD wanted is already on loan or not. Also I will test whether the system detects if that member has borrowed more than 3 DVD's. I will also test whether only DVD's that are not on loan are displayed.

  2. Tod's Tyres is a small business that supplies new car tyres to company car ...

    password Check security Screen will change to allow access to system 6 Type incorrect password Check security Message box "invalid password" 7 Leave password blank Check security Message box 8 Test formula Check discount is subtracted correctly Total adjusts accordingly 9 Test formula Check VAT is added correctly Total adjusts

  1. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    With the right type of fibre you can have a device that does both. The first WDM systems combined the two signals and appeared around 1985. Modern systems can handle up to 128 signals and then can expand into a basic of 9.6 Gbps fibre system to a capacity of over 1000 Gbps.

  2. I have been given the task to design a database for a company called ...

    To make entering data easier I have decided to use the auto form function, which is quick and effective at designing simplistic and easy to use forms. All you have to do is follow the various self-explanatory steps, which the wizard takes you through.

  1. Spare Parts Database Project

    Software The customer has requested that the system be developed using MS Access, so unless a good reason transpired for using an alternative program or package MS Access will be the first choice of software. Hardware In order to run MS Access, a Pentium with a minimum of 64 MB, and preferably 128 MB, will be required.

  2. Computing Project

    It also allows the instructor to print a report on the student progress Availability Details This allows the instructor to see what dates and times are available in the next two weeks and make a booking. USER INTERFACE DESIGN MAIN MENU STUDENT DETAILS MENU AVAILABILITY DETAILS DATABASE DESIGN INCLUDING ER MODEL STUDENT (StudentName, StudentNumber, StudentAddress, LessonCode, PricePerLesson, DateAndTimeOfNextLesson)

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work