• 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.

    The reason people feel how they do can be explored rather than just collecting specific information. A tape recorder can because, which means that the information can be referred back to when analysing the data. The results depend on how skilful the interviewer is.

  2. a level ict project

    inputting the data into one of the criteria boxes, click the run button which is shown in the above screenshot behind a translucent blue box. Searching for a vehicle and its driver One scenario may be that a car has been found with limited available information; subsequently this information can be inputted into the system to gain the corresponding data14.

  1. System requirements analysis

    * Patient and insurance company balances displayed in every patient-related view * Budget billing plan specific to the individual patient * Custom fields available for user-defined information * Automatic computation of all managed care data * Easy viewing of managed care issues such as capitation, referral tracking, copayments, number of

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

    Features like this make Sarah able to use the iPhone, albeit in a limited fashion. Using the iPhone, she can simply call people, receive calls, listen to music and other such things although there are barriers and cases preventing her from using the iPhone efficiently.

  1. Ict Powerpoint Coursework

    For Office 2010 there are several advantages like you can insert clip art , videos , sound clips , movies etc ... Also you can make a slide show automatic so there will be less hassle and most things would be at ease with PowerPoint.

  2. Database coursework

    Spreadsheet This alternative is similar to the database but it can be done by a spreadsheet editing program. This alternative requires that the company has a working computer system. And in addition to that a Spreadsheet making program. It will also include that the company purchases a spreadsheet editing program.

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