• 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. My final report - Spreadsheets.

    Another problem that occurred, was the fact that if you wanted to change a single data value, and then wanted

  2. 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.

  1. AQA GCSE ICT Specification B

    These were often font size 8. This was alright though, as it was still clearly visible. Refinements Not required Criteria 5 Criteria Details Data validation should be in place wherever possible Evaluation This was not met fully, although data validation was in place on many fields, some were difficult to monitor (like making sure an email contains a @)

  2. a spreadsheet for a school trip

    This is the Payments page. This is the worksheet you will most probably be using. It is a record of all payments made to the school from every pupil attending the trip. The payments are made in seven weekly payments.

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

    Another mistake is that slide 5, has a title "News from the LEA" but that's about it. There's no body text and no pictures or anything. It is effective and in my opinion the number of types of elements used is appropriate.

  2. Payments Spreadsheet task. - formulas and fomatting

    I have created a key to help understand the meaning of the colours used. e) Description of how to use Advanced features:- > The Microsoft Excel has a wide range of advanced features such validation and protecting sheet etc. Here is a description on how to use validation: Validation- 2)

  1. GNVQ intermediate ict unit 4

    6- The date will be entered automatically. 7- When you are ready to enter the results click on the Input button and this will take you to the Input page. 8- On the Input page use the drop down boxes to record the positions of the teams in each race.

  2. Database design for a games shop.

    because only one person works at the shop at a time hence the reason they can't leave the shop unattended . Resultantly they are losing out on potential profit. At the moment MR. Walcott and Ben records all the data on a scrap piece of paper so when a customer

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