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

Introduction

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.

Middle

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.

Conclusion

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. The aim of my project is to make the task of the allocation of ...

    This will allow Mr Brown to easily see how many people have sat in certain places, and will allow him to respond accordingly to achieve maximum profitability. See test 6 28th November 2003 Epsom Playhouse High street 56 Epsom KT17 9HW Dear Michael Pittas Thank you for sending me your

  2. What is a computer registry?

    This information is associated with the user's profile. This key is sometimes abbreviated as "HKCU." HKEY_USERS Contains all the actively loaded user profiles on the computer. HKEY_CURRENT_USER is a subkey of HKEY_USERS. HKEY_USERS is sometimes abbreviated as "HKU." HKEY_LOCAL_MACHINE Contains configuration information particular to the computer (for any user).

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

    Step 13 I then added another column to calculate the total number of merits. I did this by: 1) I high-lighted the cell I wanted the formula to be in, and typed in an equals sign. This tells Excel that I want to write a formula.

  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. Project 1a. ICT

    I had to search for it using a Boolean search on the internet. First of all, my story booklet is obviously based on one of the most famous children's Television programmes around (Bill and Ben). I used google to find this picture as I knew that millions of different searches will be processed through the search engine.

  2. Powerpoint review project

    These will navigate back and forward between the slides. I will add these by going to Slideshow > Action buttons where I can then reshape it, choose the fill and position it to how I want. These will be placed in the bottom corners of the slides for navigation use.

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

    * As well as this the headings must be easy to read from and be easily understood in order to meet the requirements of the employee interviewed from the store I am creating the spreadsheet for. When I went to the shop to observe their daily 'cycle' I had the opportunity to discover their current system in detail.

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

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