• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 2151

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

Extracts from this document...


Analysis My task is to design a spreadsheet that can be used by a school tuck shop, which can be used to find the following: * Income * Expenditures * Stock amounts * Popularity of products * The selling price of stock * Profit made * Wages of employees * Whether to order more stock The spreadsheet can be used as a model to predict all of these things throughout the three school terms. The product popularity can be used to see what products are most popular and unpopular in the different seasons. This can then be used to order in more or less of a certain product to get maximum profit. The spreadsheet has been designed to calculate the how much profit you make on each item and how much overall after expenses such as electricity and wages have been paid. IF formulas have been used to tell the owner when he/she needs to buy in more of a certain product. By using the relevant information from the spreadsheet, chart can be made. The popularity of items could be shown on the charts. The spreadsheet is set up so that if you change a certain variable, all of the calculations are updated and you are able to predict what will happen. For example: * If VAT rose to 20% on one week * If Electricity costs went up by �3 * If ...read more.


489 =(D14+K14)-Q14 132 =(D15+K15)-Q15 102 =(D16+K16)-Q16 116 =(D17+K17)-Q17 102 =(D18+K18)-Q18 You need to change the column widths and row heights to the following so that your heading and product information fit neatly into your spreadsheet without overlapping the cells COLUMN WIDTH ROW HEIGHT A 15 1 20.25 B 20 2 51 C 10 3 12.75 D 10 4 12.75 E 7 5 12.75 F 8 6 12.75 G 6 7 12.75 H 6 8 12.75 I 14 9 12.75 J 8 10 12.75 K 6 11 12.75 L 8 12 12.75 M 6 13 12.75 N 7 14 12.75 O 8 15 12.75 P 9 16 12.75 Q 8 17 12.75 R 6 18 12.75 S 10 19 12 T 8 20 24.75 U 12 21 12.75 V 5 22 12.75 23 12.75 Now you can label the tabs at the bottom of you spreadsheet. To do this right click on the tab and select rename. Type in the new name for each. For the first section of your spreadsheet you need to create and rename 9 spreadsheets. They must be named Autumn week 1 Autumn week 2 Autumn week 3 Spring Week 1 Spring Week 2 Spring Week 3 Summer Week 1 Summer Week 2 Summer Week 3 Once you have renamed each of them. ...read more.


The second problem I encountered was when I came to plot the popularity of the items. My initial idea was the plot a graph that would show each products popularity as you went through the three terms but when it came to making the graph it was too hard to read and it looked a mess. I then decided to make the popularity spreadsheet and find the average rank and to plot that. This resulted in a good clear graph. Overall my spreadsheets layout is a bit hard to read but I found that if I were to improve my spreadsheet by using combo boxes and other improvements then it would be much more user friendly. These are some of the improvements I could make to my spreadsheet: These are some other improvements I could make: * Add extra columns in my wages page to sort out employee's absences from work. * I haven't put columns in to cater for stock wastage whether it is stolen or out of date. * I could add columns in for extra expenditure for items such as cleaning products and for insurance. Here is my backup copy of all of my IT coursework. I have a copy of the spreadsheet and the report on my desktop and in a separate file. I also update both versions regularly so that if one gets lost of damaged then the work is up to date. Fiona Allen 06/05/2007 2 ...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.

    or 64-bit (x64) processor,1 GB of system memory, 40 GB hard drive with at least 15 GB of available space with internet, other hardware's like colour printer, mouse, keyboard and a monitor. This should be cheap and should have Microsoft office excel.

  2. Unit 4 Multimedia -Review for Product 1 KS3 Strategy Presentation

    However there a few things that could have been changed to make the whole presentation more effective, a few of those improvements are: adding a few pictures, have the slides in the right order, have no speeling mistakes and make sure that no hard words are used so that it

  1. Database design for a games shop.

    When the folder is missing they just leave the paper lying around. This makes them look unprofessional and it not a good impression on the customers, furthermore when the shop is very busy the service gets very slow and the customers get agitated and leave.

  2. Reviewing different multimedia presentations.

    towards the body and put them in the place where they are meant to go. How easy was it to understand what you had to do? It was quite self explanatory what you had to do to get into the Multimedia Presentation but when you were actually in the Multimedia

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

    To do this, I first had to create a nested If function to tell me what grade the child had actually achieved, depending on their percentage. To do this, I did the following: 1) I clicked on the cell I wanted to create the formula in, and then clicked the "Fx" icon next to the formula bar.

  2. AQA GCSE ICT Specification B

    It is also carried onto three pages. The note was formatted to create the one on the right; this carries the company logo and is very clear, It is also fitted on one page. Testing Evaluation Criteria Criterion Number Criterion Justification 1. On opening, the main menu should appear, and the navigation panel should not.


    you pay for the quality and quantity of this computer whereas the other computer system is a mere �3,672 but you do get enough for the money you pay. If I had the money I would definitely go with the Dell Precision T7400 as I think it will be quick

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    But I think you can improve it. I want you to add information that provides the customers with a map and some information about free delivery, vacancies, etc. After doing this I think that your designed application will be fine. I have also seen your designed logo for my shop I think you can improve that as well.

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