• 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. The use of ict has changed the way in which people work. Explain the ...

    Keeps a diary of all payments to be made. These payments are made and transferred between the banks on magnetic tape. Not many people have heard of BACS, shows reliability and success. Money into accounts ,Pensions, Wages and salaries, Prepares data of wages to be paid. BACS processes data.

  2. a level ict project

    Depending on how many garage jobs you want the commission query to calculate different parameters are required. The following steps process all garage jobs. 3. As illustrated in the below screenshot, leave the criteria row blank and immediately press the run button 4.

  1. System requirements analysis

    The screenshot above shows the doctors' scheduler. It has been split into three different screens with each of the doctors' appointments. It is very easy to print out an appointment or any required information by clicking on the icon near the top of the screen that has a small image indicating a printer.

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

    As mentioned before, word prediction works with a lot of these things to help Sarah out a lot. Word prediction helps save Sarah time and worry over hitting all the exact keys. It helps save a LOT of time with the scrolling app and also helps save Sarah the worry

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

    more Ranking: The respondent can rank things or order of what they like the best or least. E.g. Indicate your preference for what you look for in as good home. (1very important and 4 least important) Good neighbours Big garden Close to the shops Four or more bedrooms Attitude scales:

  2. Ict Powerpoint Coursework

    Akram can use this with his graphics card at full compatibility. The only bad things about Firefox is that it sometimes crashes which can be disappointing but once it crashes it resumes where you ended off from which is reasonable.

  1. Database coursework

    This alternative includes that the company has a working computer system with database making software. The data would be entered into designed fields and tables by using a computer system. The data entered can be converted into many different things such as rapports and forms as well as searching for specific data.

  2. ict applied coursework

    I believe that the printer helps me a lot in my daily life. Once I had printed out my coursework but I lost it by mistake so I just printed it out again which saved me time and was very helpful as I didn't had to do all the hard work again.

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