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

    The HKEY_CLASSES_ROOT key provides a view of the registry that merges the information from these two sources. HKEY_CLASSES_ROOT also provides this merged view for programs that are designed for earlier versions of Windows. To change the settings for the interactive user, changes must be made under HKEY_CURRENT_USER\Software\Classes instead of under HKEY_CLASSES_ROOT.

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

    different colours; I only wanted to high-light important aspects of it e.g. cells which said "inform parents." However, I decided to conditional format the percentage column, to show colours ranging from green to red, this was to show if the majority of the class were doing well e.g.

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

  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. Powerpoint review project

    This is what my main slide will look like. It will have the following features added: Background: Blue and white from 'Slide Design' section Font: Bright Wordart for title and Gold 'Arial'

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

    TASK C: Spreadsheet coursework page 1 C: Specification of Solution From the information I gathered I could now finally begin to design my system. I am hoping to produce a spreadsheet that will help, with the organisation of the computer shop.

  1. GNVQ intermediate ict unit 4

    reads the team names in the Results grid and calculates which position each team achieved in that event. You will be doing this by using the function =MATCH("Team Name", Row of Result Grid, 0) On the input sheet I have a grid called the Total grid which reads the position

  2. implementation report

    Appendix 24 Appendix 24 shows the wizard for creating a command button which allows you to preview reports, as Mr Patel wanted to know the overdue videos and this would pick out for him which members have overdue videos. Appendix 25 Appendix 25 shows that I chose the overdue videos report, because I am creating a command button for this.

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