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

ICT GCSE Coursework - Documentation.

Extracts from this document...


Parminder Saroe ICT GCSE Coursework - Documentation For our ICT GCSE Data handling coursework, we were asked to compile a database of second hand vehicles using current information from local garage advertisement, newspapers and leaflet. This database will act as a vehicle location service for someone wishing to obtain details on the availability of certain models. The database software that I will use for this coursework is Microsoft Excel. I decided to use this program because it is very simple and easy to use and can carry out all the necessary tasks that I need to do. The first thing that I needed to do for this project was to gather information for about 50 cars. I can do this in many ways by looking on the Internet, reading magazines (auto-trader), or by asking people about there cars. But before I could carry out this task, I needed to know what fields I will be using. The fields are the information that will be collected about the cars. I decided to use the fields: > Make > Model > Reg/year > Engine size > Price > Colour > Petrol I chose these fields because they are the most common characteristics of a car and can be collected easily. ...read more.


To format my fields, I had to click on format on my toolbar, then field, and then change the desired fields. I needed to do this so that the correct information could be inputted into the database. For example, my first field was make and the make would be written in text form, so the format for the field make would be text. The computer will only allow me to put in text into that field. Another example would be the field price. The price would be given in number form so the format for the field price would be number. The computer will only allow me to put a numeric form into that field. Once all the fields had been formatted correctly, I could input my data. Once the data of my information had been inputted into the database, I tested it to see that it worked. I could test to see if my database works by doing searches and sorts. A search is when you ask the computer to search for information on a specific field (simple search) ...read more.


During the experiment, there were not many problems that I occurred. The only problem was the that computer that I used had a problem and wouldn't let me open the program Microsoft Excel. But after some patient waiting, the program was finally opened and in perfect working order. If I could have done this experiment again, o would have collected more information on more cars because at first I thought that 50 cars would be enough, but I realised that it wasn't enough for me to gather a wide range of cars and for a costumer to choose from. More fields like mileage could have been used so that the costumer would have a wider range of information to look at for the car he is to buy. I would have also carried out more tests to make sure that my database was in working order and used a more updated program because the program I used was Microsoft Excel 97, and I could've gotten access to the newer Microsoft Excel because there might have been improvements to the program and more detail could've been added. But overall, the experiment went well and I completed the task that was set out successfully. ...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 Software 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 Software essays

  1. What is a computer registry?

    To change the default settings, changes must be made under HKEY_LOCAL_MACHINE\Software\Classes. If you write keys to a key under HKEY_CLASSES_ROOT, the system stores the information under HKEY_LOCAL_MACHINE\Software\Classes. If you write values to a key under HKEY_CLASSES_ROOT, and the key already exists under HKEY_CURRENT_USER\Software\Classes, the system will store the information there instead of under HKEY_LOCAL_MACHINE\Software\Classes.

  2. AQA GCSE ICT Specification B

    Company name and location Ducks! 26 Warfield RD Bracknell, Berks, RG38 45D Business Contact James Stephenson, Managing Director, Ducks! Nature of business Retail; Selling personalized rubber duck toys Intended market Young children and people who like ducks Staffing Structure One member of staff operates a computer to deal with orders, another operates telephones for order taking.

  1. The aim of my project is to make the task of the allocation of ...

    =AI16*AF4, the projected profits, the income from seating and the calculation of fixed costs.. We will first change all costs and income to zero which should cause all totals to become zero. Then will then change them to 1 which should then allow us to easily check whether all formulas work correctly.

  2. Project 1a. ICT

    COLLECTING INFORMATION: As a part of my coursework I need to find different ICT and Non ICT sources off the internet and out of magazines, newspapers etc at home. First of all I will start with my ICT source: My second ICT source has a different background to it as

  1. Technical Documentation.

    - This formula will add the cost of postage and packaging to an order of 7%. However there is an 'IF' statement in place because postage and packaging is not added if an order costs more that �500. =IF(ISBLANK(I30),(I29*0.175),((I29+I30)*0.175))

  2. GNVQ intermediate ict unit 4

    chart was because it's an easy way to compare the results also it's easy to read and understand them. Why I chose this line graph, was because it's a good way to show the progress of each of the teams/ area.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    I decided to have my data sorted by the surname in ascending order, as student names are often organised in this way in most schools. Step 7 I then added the headings I wanted in my table, by typing them into the specific cell.

  2. Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

    it to various companies, asking questions like 'How would you rate your filing system', or 'How would you like your filing system, computerised or manual', this is to see the efficiency of their filing system. Later then, I can update the present filing system of my organisation (CNE)

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