• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  • Level: GCSE
  • Subject: ICT
  • Word count: 3299

Data handling - ICT.

Extracts from this document...

Introduction

Data Handling Coursework Report Choice of Problem When asked to think of ideas to base my ICT course work on I came up with the following; * Make over salon * Modelling agency * School health centre * Job centre * A tracing family trees agency I decided on the job centre for a number of reasons; * This idea was original; no one else in my year was basing her coursework on a job centre. * A job centre would require a number of specific pieces of information. As I needed to think of at least fifteen different fields for my course work I decided it would be easier for me to think of the field titles I would need. * There would be a lot of information concerning job agencies available, making it easier if I needed to research something for my course work. * A variety of different people would apply to my job agency I would not have to be typing the same information in repeatedly making it more interesting to create a database on. Job centre data base I was struggling to keep track of all the clients' records so I decided to use a database to sort these. I had less need for a database, which held my clients looking for employees than I did for those clients looking for employers as I would not be looking to find information quickly and easily as urgently. If the database I was going to set up for my clients looking for jobs was successful I would also set one up for those searching for employees. Setting up a database meant I would be able to find information for prospective clients instantly so I could tell those looking for employees whether I had someone suitable for them quickly. I could find records quickly to update them; for example if someone had a change of address I could easily find the old one and bring it up to date. ...read more.

Middle

Data Verification and Validation It is always possible that the data entered into my database is incorrect. In this case it must be corrected, if data is incorrect it can cause problems. If something such as a phone number is incorrect, I may be unable to contact my client. Or even worse; if for instance I typed a job other than the one my client was looking for allot of time would be wasted finding them a job that they had not asked for. Clients may also be disappointed that we had not lived up to the standards, which are expected of a company and leave, asking for their money back and giving my company a bad reputation. There are several different ways of checking whether the data entered is correct, they are stated below; The data can be checked manually, this insures the data is accurate. It is called Data Verification; this can be done in two ways; * Proof reading: This is when a second person goes over the data and compares it with the original; any incorrect information then found will then be corrected. * Double entry: This is when two different people enter the data twice separately. The computer then compares the data and any errors found are corrected. It is extremely un-lightly that both people will type the data in wrong so the data is bound to be correct. There are of course problems with using Data Verification; Double entry is time consuming meaning it will be expensive to employ people to do it. Proof reading is also time consuming, it is also not always accurate; it is quite possible for a mistake to be overlooked. The Data can also be checked with the use of a computer. It is called Data Validation; this type of check ensures the Data is of the correct type. There are four ways this can be done; * Range check: This check ensures that the data entered is within a specific range. ...read more.

Conclusion

This also applied to my database; I was delighted to find that there was also a spell check available on Microsoft Access. The spell checker however is not faultless and I found when going over the printed out version of my database some spelling errors (such as spelling 'forename', 'forname'), which more lightly then not had been brought to my attention by the spell check but I had disregard it as I was probably checking the spelling very quickly. However in the interest of saving precious time and paper I corrected what I could of the spelling mistakes I found at the time but left minor ones discovered at a later date. If my database were real they would of course all be recognised and corrected promptly through Data Verification. Another thing, which was brought to my attention, was the way the ages of my clients are stored on my database. As it stands I have got two fields to store data about the age of my clients. One for the date of birth and another for just the age so that a person seeking the age of someone on my database does not need to spend time working out the age. This alone has many drawbacks; someone would frequently have to check that the ages were still up to date. This would be time consuming, probably more so than working out the age from the date of birth. I did however with the help of Microsoft excel create a sort of 'age check' which meant I could check the date of birth to the age quickly. Even this was not ideal; I endeavoured to find an easier way of keeping the ages of the clients in my database correct. I then discovered 'Macro' software designed to help with this sort of problem. Macro would alert me using a dialog box to the fact that the age of my client had changed. 1 26/04/2007 ...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. Different types of technology How I use ICT at home and at school

    digital uses a satellite to connect to the corresponding company that supplies your digital box (needed to receive transmissions for digital TV). How it affects my needs Advantages (How it meets my needs) Television can keep someone like me in touch with what's happening in reality.

  2. The use of ict has changed the way in which people work. Explain the ...

    bank.The cheque is sent from the clearing house back to the customers bank identified from the sorting code number, the amount will be deducted from the customers account.The companies bank receives notification that the cheque has been cleared from the companies account.

  1. Explain the difference between primary and secondary sources of data, with examples.

    In interviews you are able to understand how they really feel and can speak for themselves. Also interviews are able to get closer to their experiences. The information is not already known by the questions set, this means the interviewer can focus on specific information.

  2. a level ict project

    working area that will be used in the day to day usage of the program. System requirements Minimum requirements: * Operating system: Windows(r) 98 * CPU Type and speed: Pentium(r) II 450 or equivalent * Hard Drive space: 40MB * Memory: 16MB * CD-ROM Speed: 4x or faster * Audio:

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

    What it does is scrolls across the keyboard in an efficient manner that allows it to not take too long but also leave it easy enough for Sarah to be able to handle. When it passes the row of the letter Sarah wants to use, she taps anywhere on the screen.

  2. System requirements analysis

    Patient and Practice Management Software for Windows(tm) This is more suitable software that is perfect for the health centre. It has many qualities that are necessary for the health centre. The appointments page allows you to navigate from page to page by the click of a button.

  1. GCSE ICT Coursework Booklet

    * You could introduce online shopping. * Online information - customer e-mail Q&A. * Finance system/accounts. * Staff payroll system. * System will make it easier to find out what sells and what doesn't. DISADVANTAGES: * The system may be costly. * Training may be required to use the system.

  2. GCSE ICT Coursework Write-up

    I used Excel for creating the spreadsheets of the employees' wages. This is because it is a program that is specifically designed for creating spreadsheets, and also useful for doing calculations (e.g. for tax). I could also mail merge the spreadsheet from Excel with the Word payslip, so that and

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