• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 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...

Introduction

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.

Middle

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.

Conclusion

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.

    filling in body parts in the right place so you are having to be involved in the Multimedia Presentation. ELEMENT: YOUR COMMENTS: Use of images in the product In this Multimedia Presentation there is a lot of image used as the whole Multimedia Presentation works around the fact of putting

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

    Furthermore, I decided I wanted to add a merit system, which adds up all the merits the child has received depending on whether they have exceeded, met and not met their target, in each specific area, and totals them up on the annual report and says what gift voucher they will receive.

  2. AQA GCSE ICT Specification B

    The user must be able to print every output from the output viewing page. This simplifies the process of creating and shipping an order. 7. Each page must display the company's logo This adds to the professional look, and helps customers recognise information.

  1. ICT BTEC UNIT 2 - REPORT

    of RAM although this isn't as big as the Dell Precision T7400 but it does meet all the software system requirements. The Graphics card on the Dell Precision T7400 has 1.5GB PCI which is basically the expansion on the graphics card the higher the PCI the better graphics so this

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

    There should be no errors in the recipe of dishes 8 Address and timings. Their must be no mistakes in the address and timing of the restaurant 9 Text sizes are appropriate and fitting to environment. The text sizes should suit the menu 10 New Logo design is checked.

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