• 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
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  37. 37
  38. 38
  39. 39
  40. 40
  • Level: GCSE
  • Subject: ICT
  • Word count: 7190

drum kit costing system

Extracts from this document...


AQA GCSE ICT Specification B Name: Nick Gibson Candidate Number: Centre Number: 51347 Contents Description of the task to be attempted 3 Analysis 4 Investigation 4 Interview 4 Observation 4 Analysis 4 Interview Analysis 4 Output Requirements 5 Input Requirements 5 Processing Required 6 Possible Solutions 6 Specification 7 Detailed Specification of Solution 7 Evaluation Criteria 7 Design of the ICT System 8 System Flow Chart 8 Implementation 9 Hardware resources required 10 Software resources required 12 Data collection, data capture and input 14 Data verification and/or validation 16 Data and/or program structures 25 Output format 26 Testing 28 Evaluation Criteria 29 Test Plan Error! Bookmark not defined. Testing Against The Test Plan 30 Evaluation 38 Evaluation of the system produced 38 Possible Refinements 40 Description of the task to be attempted Chris Wright owns a drum shop called Drum Gurus. It has been operating for about 5 years and he now wishes to improve the pricing system in order to provide a better service to his customers. He sells drum kits, cymbals, drums, accessories, and parts to customers. As there are more drummers coming onto the scene Chris is selling more and more complete drum kits as opposed to accessories and individual items. The current invoicing system is manual and time consuming. When a customer comes in to buy a drum kit it's a lot of working out because of the various code numbers and prices that are available. In addition the use of calculators to check prices can often result in mistakes due to human error. You have to make sure that you have typed in the right numbers and pressed the right buttons. He used to sell about 1-2 drum kits a week but now that his business has expanded this has increased to about 7-8 a week. It takes quite a long time to work it out on a calculator and then check if it's correct. ...read more.


It is also to save them time, if they keep typing in too much it will waste their time so the validation is to help them and help Chris to easily look up a customer on his database. Drop down menus The following information is entered into the model, using drop down menus: * Bass drum * Snare drum * Cymbal * Tom Toms * Accessories * Sticks, beaters and brushes * Stands and seats and pedals * Stools * Full drum kits * Payment method (credit card choices) All the information is contained and easily laid out in the data sheet. It is also easy to update it when Chris wants to add more items or change prices. Once I had all my data I had to input it using format control to the drop down menus. These following settings create the drop down menus for each category. * The input range tells the drop down the location of the list to be displayed; in this case the cells are D3 to D19 of the data sheet. * Cell link is located in the cell directly underneath the drop down menu, and is where the drop down menu will go on the interface. * The drop down lines tells you the amount of choices you want to be displayed. I want all 17 to be displayed. Justification The reasoning behind this is to help the user not to enter what they want. It is very time consuming to enter what they want and it also eliminated the threat of typing errors that would confuse Chris when he comes to search that item on his database. I chose drop down menus because they are easy to use and eradicates any mistakes. Numerical length Restrictions The numerical length is to help the user enter the correct data. I did some research and found out that the biggest phone number come to a total of 930599 if you add it up. ...read more.


I did this by seeing if the model came to the same price as I had worked out when I made a quote manually. Both of the answers came to the same total which indicates that the Postage and Packing and VAT was included without human intervention. 10. When an option changes the total price and the price next to the option changes as well. As I demonstrated in test 1, when an option changes, the price next to it changes as well indicating the total price for that one item. Simultaneously the total price is changed as well to keep up with the changing of the options. Possible Refinements Even though I fulfilled my evaluation criteria, there are some improvements I could make. I noticed that if a user wanted to buy two cymbals, but two different cymbals that it could not be done. They could choose two cymbals but they had to be the same kind. This was the same for all the other parts, if they wanted two or three different sticks; it was not possible to do this. They only way that this could happen would be for them to fill out two forms. That would be very time consuming. To amend this I would have had it where the user clicks on the item that he wants and it goes into the basket/invoice. Once it is there he can go back to the interface and choose another cymbal. There will be no quantity because to get two of the same cymbal he would just have to click on the desired object, go back to the interface and click on it again. That would not be very time consuming either. If the user made a mistake they could just click on "go to invoice" and just click on the item and press delete. Here is a shot of what the invoice should have looked like: ?? ?? ?? ?? Nick Gibson GCSE ICT Coursework coursework no[1][1].3 15 September 2003 Page 2 of 40 Nick Gibson GCSE ICT Coursework coursework no[1][1].3 15 September 2003 Page 1 of 1 ...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. Different types of technology How I use ICT at home and at school

    Summary of advantages * Gives a much larger variety of channels and shows to pick from * Allows you to record shows * Digital feature allows for a much clearer picture in contrast to analogue * Rewind programs to see something you missed even in a live program * Other

  2. Financial Model to help organise the year eleven prom

    have to be solved * The Task to be done (see Task to be done pg1) that concern the spreadsheet itself need to be completed How I can do this? My first chance would be to view the "problems" and "task to be done".

  1. Creating a computer system for a video rental shop

    In the invoice table example, if a customer record is deleted in the customer table and the deleted customer record has one or more invoices in the invoice table referencing the customer table, there is referential integrity error. Tabular analyses Name of attributes Input Forms Output Reports Member form Borrowing

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

    letters and with this , Sarah can effectively and instantly bring up her predicted word without having to type it all out. The adjustable text size is also very helpful. It can make words easier to press on with the pointer.

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

    The work was saved successfully. I found it a bit problematic since this was the first time I saved a file. It would be easier if there were screenshots or images. Printing I am going to choose what I want to print then I am going to click on file then print.

  2. I am now going to analyse my clients current system in order to get ...

    Disadvantages: * The form I choose might not have any problems. * I might not be able to spot frequent problems, as that document might not contain any. Overall, I have decided that I am going to choose two of the above-mentioned investigation techniques.

  1. IT Project Evaluation. The design part of my wages system, data capture form, letterhead ...

    Verification is checking done by a human being. It usually involves proof-reading and checking the text on the webpage slides in order to ensure that they make sense and contains the correct information. It will ensure that the important information being given to customers is accurate and correct, for example checking that all of the information on the

  2. Ict Powerpoint Coursework

    the users' opinions and what can be improved as well as what is up to standards. The questions were thought by me and some work colleagues as the whole PowerPoint Slideshow is based on everyone's opinions and not just my own personal opinion.

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