• 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. Financial Model to help organise the year eleven prom

    Then arrange a checklist, so I can see exactly what I need to test. Checklist * To be able to model various scenarios in order to work out break even point * To be able to let pupils know the final price of an individual ticket as soon as possible,

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

    This can often lead to winning something small. Disadvantages (How it does not meet my needs) However, the box is quite expensive to buy and it's even more expensive to maintain a periodical fee to pay for channels. This makes it quite hard to maintain, especially including TV and electricity costs.

  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. ICT Coursework (MarcoS)

    the amount in the cell O8 to the correspondent month incoming cell in Profit & Loss 29 September incoming button in the Audit Transfer the amount in the cell O9 to the correspondent month incoming cell in Profit & Loss 30 October incoming button in the Audit Transfer the amount

  1. gcse ict unit 2a

    They also use this software to save time by mail merging and creating memos. * Microsoft Excel: This is used to create graphs, charts and spreadsheets based on suppliers and the products which the purchasing department has bought. * Microsoft Access: This is used for simple reasons, keeping data of suppliers into databases.

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

    Sarah also can do simple things such as store and download files, music, videos, game etc. She can watch different movies and TV shows and do lots of other stuff. The high hard drive memory allows her to do all this.

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

    After that I will choose the location where I want the file to be saved in and if I want to I will rename the file by clicking on file name. Finally I will click on save. The work was saved successfully.

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

    I am going to ask them all to take part in one-on-one interview, will ask them to participate in a questionnaire. This is because I will be able to figure out any problems as I will be using a range of techniques, and can find out how severe they are.

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