• 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
  41. 41
  42. 42
  43. 43
  44. 44
  45. 45
  • Level: GCSE
  • Subject: ICT
  • Word count: 8318

Spreadsheet. This coursework is based on the work of a spreadsheet, which is designed for a computer shop, called CNE computers.

Extracts from this document...


TASK A: Spreadsheet coursework page 1 This coursework is to design a spreadsheet that will help a Company in their organisation of their files and information. I, a student in year 10 will have to produce a spreadsheet that is complex enough to meet the requirements of a specific organisation and as simple to use that any member of staff will be able to use it. A: Description of Problem This coursework is based on the work of a spreadsheet, which is designed for a computer shop, called CNE computers. I have chosen a family business, whereby my father owns the shop. It is located on a busy street in the heart of Harrow. It concentrates mainly on selling and repairing computers and general electronics. The manager seems to have a problem with dealing with all the paperwork of his customers. The system that he is using is very complicated; it causes him a lot of trouble, as it is very problematic. He currently uses a manual system, whereby all his invoices, accounts and finance calculations are taken out. This method is slow, hard and tiresome. When working out his finances, such as his profits, VAT calculations, he must write down and calculate them using a pen, paper and a calculator. This is an unreliable method, for human errors are inevitable. For example, if he was to make a mistake in the working out, the chances are that he would not notice until the end, making all of his working out incorrect, hence he would have to start all over again; plus finding the error would be time consuming. And so starting all over again means that you have to erase (rub out or tip-ex) the entire thing, making it look terribly unprofessional and untidy. TASK A: Spreadsheet coursework page 2 Furthermore, there is the problem of invoices and writing up each one manually takes up too much time. ...read more.


TASK E (iii): Spreadsheet coursework page 1 (iii) Data Collection, data capture and Input: There are many ways to insert information into ones computer, though it all resolves to one point hardware. What kind of devices does the user have, to insert information into his system; this could vary from the most commonly used input devices, to the most specialised and up class in technology. Here are a few input devices one can use in his system. Key to disk: This is just the simple typing using the keyboard on the computer. It's a very simple tool and indeed very cheap and is nevertheless efficient. It is used in any ordinary computer, and has disadvantages like time consuming and many easily made mistakes are made. Microphone easy speaking This is a two way piece which is when someone speaks through the Hardware, the microphone it appears using the software as text on the screen. Magnetic Ink Character Recognition This mechanism is ideally used in banks and building societies, as it is used to print the peculiar characters on cheques. These characters could be numbers or letters, and is printed by using an ink which consists of iron and may be magnetised. The magnetic pattern of the numbers can be read by a Magnetic Ink Character Recognition. Optical Character Recognition: This is a scanner with a difference. Not only does it scan images it can also recognise each letter individually. I.e. as it is often hard to read printed letters and numbers (like distinguishing TASK E (iii): Spreadsheet coursework page 2 between the number 5 and letter S) the Optical Character recognition scans and recognises each character not only as a picture but also as an individual character. Therefore due to its technology it can be edited on a database such as Microsoft word, so you can just imagine how expensive this contraption is. Optical Mark Recognition This is a gadget that can convert marks(lines) ...read more.


I.e. It is possible to sell more than 10 computer cables, but is unlikely to sell more than 10 computers to the same person, this is why I would have liked to justify the overflow validation constricting it to each kind of item. E.g. For a cable the quantity sold will rise to a maximum of about 25, where as a Pentium 3 processor only a maximum of about 4. Further improvements are contained go under the headings of quantity, Price, VAT and Total where another validation method can be used to investigate for minus figures (i.e. below the number 0). Additional work can be made to find how to persuade the computer to write, "Profit" if the sale made a profit and vice-versa for "Loss". In relation to my initial set criteria my uses of VLookup and the If statements used are undoubtedly useful and causes less hassle to the user. The initial target was to develop a spreadsheet to calculate the VAT, my final spreadsheet is able to do this and much more, I have now created a spreadsheet that can calculate everything in great detail I have produced an entire package to satisfy a company's entire needs. Not only have I produced a package that can calculate the VAT, I have also made it easier for the user to function the filing system. This is due to the reason that I have produced "IF and Vlookup statements" so that once the member of staff types in the description of item, the price of the item, how much VAT is due, and the total amount is shown. As well as this it automatically shows our profits and losses after the presently sold item. These listings will be confidently confirmed by using the validation and verification formulas. My final judgement on the final spreadsheet produced is that it is an asset to any company who functions it and hopefully in the future it can progress to be even more efficient. ?? ?? ?? ?? 6 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 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. Planning a spreadsheet database for a gun shop.

    Alternative solution No 2: My second solution which I can use is Microsoft Excel spreadsheet as it is the easiest way to calculate and input tables. It is also made for calculations. Alternative Solution No.3: My last solution is a Manual solution which is used in case the computer crashes.

  2. The aim of my project is to make the task of the allocation of ...

    The projected profit from programmes formula will use the cell which contains the total of the amount of people who are watching the show and work out the percentage, it will also be configurable so that the user can easily change the % of people Mr.

  1. Design a spreadsheet that can be used by a school tuck shop.

    in packet number of packets bought cost per packet �48.00 �5.00 �9.96 �48.00 �6.00 �9.87 �42.00 �5.00 �9.35 �42.00 �5.00 �9.24 �42.00 �3.00 �9.12 �42.00 �4.00 �8.24 �42.00 �4.00 �8.99 �42.00 �5.00 �7.87 �42.00 �6.00 �8.99 �42.00 �5.00 �7.99 �42.00 �4.00 �5.55 �100.00 �5.00 �5.00 �42.00 �4.00 �7.99 �24.00 �7.00

  2. Selecting the best software for a theatre business.

    Microsoft Excel offers many features which Bob Dixon will find it very helpful. For example, all shares can be put into ranking according to their performances; functions such as average can be used to calculate the overall performance to the shares.

  1. Software used in my created system. To begin with, the one software I must ...

    in thumbnail format, the pictures are vector pictures meaning they can be enlarged and made smaller without blurring the image.

  2. Designing a leaflet to advertise an electronics shop.

    * Leaflet should have shop location. Analysis Hardware: * I will need the following hardware: * A 3.06 processor because a slower processor is slower. * A 4GB memory ram to enhance the computer * A storage hard-drive with 2 GB capacity for transfer of files.

  1. Database design for a games shop.

    Walcott and Ben often find it difficult to get this data fast and end up spending a very long time to find this information but the customers get impatient and hang up or in case of a email they look somewhere else for their needs.

  2. Flight Spreadsheet Report. The task we had to complete was to find prices of ...

    To format the required cells, I selected the cells I wanted then right clicked and clicked the 'format cells' button. From here, I chose Currency for most cells and had 2 decimal places and a � sign to start. To do a times of 2 cells, simply type = (Cell one * Cell two)

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