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

ICT Coursework

Extracts from this document...

Introduction

Introduction Mellor Village is an area that only has three doctors who all work individually in the same community. I am their ICT system analyst to help them through the process of creating a better organised health centre. This medical centre will be named ''Mellor Village Health Centre'' and will have new logo and slogan and I will create a database too. The new medical centre will have a sufficient amount of staff which will include the following: * 3 doctors * 2 medical centre nurses * 2 district nurses * 1 health centre manager * 1 secretary * 3 receptionists * 1 counsellor * 1 health visitor * 1 midwife PROBLEMS * The first problem is that all the patient records are on a paper-based system, there are no computers .This is risky because papers and files can get misplaced. So loads of files in cabinets takes up a lot of space. Also tea could be spilt on it by accident and important patient information would be destroyed. ...read more.

Middle

Further I will put the patient's information in and save this as table 1 and close it down. I will then create a second table in design view which will be called table 2. It will have fields such as: * Surname, * Medical number, * Doctor's name, * Date of appointment * Time of appointment * Ailment. The medical number is the primary key because it is the unique key field for each record. I will put each individual person's information in detail in this table. I will then save this as table 2 and close it down. There will be two tables because one will just include identity and address of the patients. The second table has to be made because it is more in-depth information into each persons medical services and problems. I will go on tools -relationships and '' add '' table 1 and 2 and close it down. Thirdly I'll go on relationships - edit relationships and go on ''create new'' and press ''ok''. ...read more.

Conclusion

* It is also easier to make a back-up copy after typing something up. * There is ultimate accuracy because the spell checker identifies the mistakes. These are then verified and validated.Fewer mistakes are made and this is how the computerised solution will improve and increase accuracy. * The Data Protection Act will keep the patient details and data safe by password protection. This reduces the risks of hackers gaining access to confidential files. The costs are: * that the computer could be hacked in or files could be lost. * The computers take up a lot of space too. * Viruses could delete all the information. * There are more staff so more wages has to be given out. * The staff have to be trained on how to use the computer if they don't know. This will cost money and time. * There are health and safety risks because eyes will be strained and eyesight could get worse. * Also they could have back ache and hand ache with sitting in one position too long and holding the mouse for long periods. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Impact of ICT on the community

    The host computer may be owned by a bank or financial institution, or it may be owned by an independent service provider. Bank-owned processors normally support only bank-owned machines, whereas the independent processors support merchant-owned machines. Use of ICT in the banks > CCTV > Database > Security Alarm Evaluate

  2. The impact of ICT on a person with special/particular needs

    Summary of advantages * Run lots of different software on her computer * Access the internet which enables Sarah to access things such as Facebook * Microsoft Word allows her to do her job as a writer with as much help as she can get from a program * Allows

  1. Tennis Tournament UNIT 1 GCSE ICT coursework

    What needs calculating Formula in words Cell formula will be in Formula Price product will be sold at Price brought + mark up percentage F3 = E3+((E3/100)*K6) Profit made from sale of 1 item Price sold - price brought G3 =F3-E3 Total profit made from item Amount of times sold

  2. GCSE ICT Coursework Booklet

    The lists would then be saved or printed for later use. The staff would need to be trained how to use the system. All staff would either have to go on a training course, or use a training manual. A help guide would also be accessible on the computer.

  1. Ict coursework full

    Output method justification The decided output will be via a monitor, because only the staff needs to enter and view the product information directly from the computer. Backup and security The data from the computer will be backed up onto several other machines, which will be locked, so nobody can view them without the master password.

  2. Testing for ICT A Coursework 2a

    This is the actual datasheet for the game details table and it shows all the data being structured neatly so it can be shown easily on the user interface. Test 2 This is the screenshot that shows my user interface for my member details.

  1. a level ict project

    This will allow data to be more consistent throughout the database, the structure of the tables are able to be easily manipulated to allow me to enter as many entries as I can. Plus the structure enables complex queries to asked relating to data from various tables.

  2. ICT car insurance quotation System Coursework

    �The font of the text wills all be New Times Roman; but size may vary between worksheets. �The system will be able to add VAT onto the final price to give a Total Cost. � VAT is 17.5 % multiplied by the total cost to give a final cost.

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