• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  • Level: GCSE
  • Subject: ICT
  • Word count: 3741

Create a system for a car show room's business.

Extracts from this document...


GCSE ICT Full Course Coursework - Project 2 INTRODUCTION I plan to create a system for a car show room's business. I will be doing this for my father's car sales show room. I plan to make him a new system on the computer and to enter all his information of the different information on the cars he is selling on to this new system. This system is only to be used by my dad or his partner and not by the customers. They need a new system because he does not have a good system at the moment he doesn't have folders for all the cars he is selling or that he has sold and most are kept in one box which is quite hard to find. By creating this system he will be much more organised for when customers come in as he can do searches of cars if they are interested in a certain type or even search by price etc. This means it does not take him ages to find information of one car and it will be more professional and a lot easier to read off. IDENTIFICATION OF THE PROBLEM These are the following problems that my user has come across: 1. As the users current documentation is all kept in files in a filing cabinet, in date order, it is extremely hard for a user to find a car that a customer wants, which has a certain feature e.g. car type, colour, price etc. as they have no order you need to sort through all the files to find the car to suit the customer's wanted feature. A database would allow the user to sort the information how they wish so they can easily do searches for certain features. 2. As files can be taken out easily by anyone who works with the files it is easy for anyone to forget they have not put the file back or to take it away by mistake leading the file to get lost or misplaced. ...read more.


It is cheaper and preloaded onto many new computers and it is easy to learn how to use. Its disadvantages are that they only have limited features compared to single application and not many advanced features. When you open up works you open up all of them. It is a larger application with more memory so it can move information from one application to another application. Although if a part of this isn't working it could affect other parts. * Suite software e.g. office professional- A suite gives you a database, spreadsheet and a word processor but they are individual so you can load up one at a time. Its advantages are that you can easily move information from one application to another and if one part goes wrong you can still use the other parts. I have chosen to use a single application because they are simple to use as I use these frequently and they are already loaded at school, it is also easy to transfer documents to my home system and if one application is not working it does not affect the others. HARDWARE NEEDED Hardware 1 Hardware 2 Chosen Reason Laser Jet Ink jet Laser jet A laser jet is a lot faster to print out documents and reports. A large number of printouts can be done using a single toner cartridge, so it is not necessary to frequently buy cartridges. Mouse - It is easier to select items and start tasks by clicking icons or menus rather than typing in commands, it is a faster method to help you move around a document. Keyboard - Most computers have this device attached to it and a skilled typist can input data very quickly. Processor: 1Ghz Celeron - It carries out the instructions of a computer program. Monitor: SVGA 15 inch - To display the data that I have entered. Hard disk drive: 20 Gb - This stores all the data allowing you to read and add to it at any time. ...read more.


Your justification needs to relate the advantages of the chosen type of form to the query/table it is based upon and what it is to be used for. For example if you are producing a report of a query that sorts the data as a list of customers for example then you would choose a tabular report as you can see a number of different customers at a time. Whereas if you were producing a report to show all the fields of each customer then a columnar report would be chosen as it may not be possible to fit all the fields at the top of a tabular report. Your reasons for choosing one type of report over another must be directly related to your database and your requirements. Justification of Chosen Design As with your form designs you must justify the chosen design discussing advantages and disadvantages of each design. REJECTED DESIGN ADVANTAGES/ DISADVANTAGES CHOSEN DESIGN ADVANTAGES/ DISADVANTAGES Field layout Adv. Forename field is first as it this is the order a name is read in Disadv. Does not allow it to be sorted properly Field layout Adv. Surname field is first as it is sorted on this field Disadv. None Font Adv. Plain font Disadv. Font is too small for some people to read Font Adv. Font is plain and big enough to be read by most people Fields Adv. All fields are included Disadv. Gender field is not needed for this purpose Fields Adv. Only those fields that are needed are included making report easier to read. You will then write a short paragraph stating the chosen design and why it was chosen. OUTPUT DESIGNS - MAIL MERGE LETTER You will do exactly the same for your mail merge letter as you did for your chosen report designs. i.e. a table showing the advantages and disadvantages of each design and a written justification of the chosen one. Mrs. Hogsden WESTCLIFF HIGH SCHOOL FOR GIRLS 16637 Jenny James 9058 A1 ...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. Financial Model to help organise the year eleven prom

    Nevertheless I listed these problems and then tried to figure out how I could solve it to make the spreadsheet work better. Problems The problems that I found are listed below- * There was a certain problem with the cafeteria cells, as circled there were certain halls that had a choice of "in-house" catering.

  2. Different types of technology How I use ICT at home and at school

    This is extremely useful for someone who watches a lot of TV or keeps up with a certain programme but can't be there at its running time. For someone like me who keeps up with weekly dramas which make the plot hard to understand if missed, it helps out a lot.


    Test and data used Purpose for test Expected result Results after testing 19. Select summary chart by gender button To check if macro works properly Should go to an updated chart showing by gender 20. Select summary chart by form button To check if macro works correctly Should go to an updated chart showing by form 21.

  2. Creating a computer system for a video rental shop

    Name of the publisher Borrowing Transaction number NU 5 - Unique Transaction number P Date of borrowing DA 8 - Date of borrowing Member ID NU 4 - Unique member identity F Transaction line Transaction number NU 5 - Unique transaction identity Compound Key Video ID NU 6 - Unique

  1. ICT Coursework (MarcoS)

    Projects This is how the Projects sheet should looks like. * Point 1: To change the size of the column, click with the left mouse button on the line between the letters, and drag the mouse to change the size as you wish.

  2. Database design.

    You choose which fields you want to be in the form. Click next and the next window will appear. This window will ask what set up you want your form to be in I selected justified Basically this window asks you to select a background.

  1. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    We also have problem with storage. Currently there are cards all over the place and they take up a lot of space. It is also a messy process and there is not a lot of organisation. Also all the members details are on printed papers and take up a lot space.

  2. Benefits of using my IT system in the Travel Agents.

    If I were to use screenshots/images it would make it much better. Improving User guide The reason to why I have improved my user guide is that when other people use it they would find it a lot easier compared to the previous one.

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