• 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

Spreadsheet cwk sandwich shop prices

Extracts from this document...

Introduction

I.T COURSEWORK (Spreadsheet) Analysis The problem the Lancre Lunch box, want me to solve is to create a system calculating the price she would charge for any number of different fillings in a sandwich and the bread and butter or low fat spread and rolls. This will help Karen calculate the price of each sandwich and roll easily and will keep her calculations organised. 1. The form of output that will take place is a disk given to her by me, which will contain the system I have created for her. Her form of output will be her monitor that will display the system I have created for her. 2. The information to be output is: A system, which calculates the price, she should charge for sandwiches and rolls Item Cost of a pack Portions Cheese (gated) �4.50 25 Tomato �1.60 20 Chicken �4.95 20 Ham �4.90 20 Salad (mixed) �4.50 40 Salmon �3.95 15 Sweetcorn salad �3.75 35 Mayonnaise �2.75 40 Pickle �2.75 50 Butter �1.05 35 Low fat spread �1.40 70 Tuna �3.50 20 Bread �0.36 24 Roll (all types) �0.40 12 Add 5p to the cost of each pack because this is the cost of the container. Add �1 profit to the total I must also show the ingredients 3. The data needed to produce the output is: Item Cost of a pack Portions Cheese (gated) �4.50 25 Tomato �1.60 20 Chicken �4.95 20 Ham �4.90 20 Salad (mixed) �4.50 40 Salmon �3.95 15 Sweetcorn salad �3.75 35 Mayonnaise �2.75 40 Pickle �2.75 50 Butter �1.05 35 Low fat spread �1.40 70 Tuna �3.50 20 Bread �0.36 24 Roll (all types) �0.40 12 * (This information is all given to be by Karen on disk) * Add 5p to the cost of each pack because this is the cost of the container (conversation on page 8) * Add �1 profit to the total (conversation on page 9) ...read more.

Middle

the centre as shown in Fig 2 I have aligned the cells in the middle so that it looks professional Make the top row italic and bold. (Item, Cost of a pack, Portions, Cost of portion, Portions wanted and Price) * Highlight the top row and click on the icon 'Italic' which is located in the toolbar * When finished click on the icon 'Bold' which is located in the toolbar * Now the top row should be italic and in bold as shown in Fig 2 I have made the top row italic and bold so that it looks nicer and so that Karen will find it easier to notice the difference between the fields and there titles. Give the heading a red border * To make a red border for the heading click on the 'borders' which is located in the toolbar * Then click on the icon 'Draw borders' * A pop-up screen called borders should appear * If so, click on the 'line colour' icon and choose the colour red * Then draw a line around the heading * Now there should be a red border around the heading as shown in Fig 2 * To make the heading not bold highlight the heading and click on the 'bold' icon which is located in the toolbar * Now the heading should not be bold as shown in Fig 2 I have made added a border so that it looks nicer and more professional. I have chosen the colour red because it doesn't clash with the colour blue. I took of the bold in the heading because it did not look nice. Add a comment on cell E3 saying that if Karen wants to refresh the cells she has to select a different cell * Click on the cell E3 * Then right click it and go on 'insert comment' * A comment box should come out * Change the name of the box to message * Then below it enter ...read more.

Conclusion

It must be able to change the cost of separate fillings: I have overcome this problem by adding a comment on the cell B3 explaining to Karen that if she wants to change the price of a pack she must delete the cell and type in the new price, but she must type the price in eg: 0.67. I have also made a test to make sure that this aspect of the system work. Must be possible to add new fillings: I have overcome this problem by adding a comment on the cell A18 explaining to Karen that if she wants to add a new row she must click on 'Insert' then on 'Rows'. I have also made a test to make sure that this aspect of the system works. The system must be easy to understand: I have made the system easy to understand by adding colours and comments. The colours will make the system easy to understand because I have made a different colour then the font colour (blue) to show what relates to each other. The comments will make the system easy to understand because it will help the user to get around obstacles which the end user might find complicated. Place to enter choices must be clear: I have overcome this problem by changing the colour of the 'Portions Wanted' column to red so that it will be clear for the end user (Karen) where to type the choices in. I have chosen the colour red because it doesn't clash with the colour blue. I would have liked to experiment with different colours but unfortunately I had not time. Answer must stand out: I have overcome this problem by changing the answers font colour to red to show that it relates to the 'Portions wanted' Column. I have also made it stand out by making it bold and by putting it in an obvious place. Must allow for bread or rolls: I have overcome this problem by allowing the end user (Karen) to choose bread or rolls. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Molecules & Cells 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 AS and A Level Molecules & Cells essays

  1. Marked by a teacher

    Beetroot Practical Write up

    3 star(s)

    bottom, which is the intrinsic, or they may span the entire membrane. Some proteins on the outer edge of the membrane have carbohydrates molecules attached, usually short sugar chains called glycoproteins or lipids with carbohydrates attached to them called glycolipids.

  2. Daphnia write up

    In this experiment, the caffeine concentration was the independent variable, with the heart rate of the Daphnia being the dependent variable. To ensure the experiment was fair, the size and age of the water fleas, time left in the caffeine solution, and the amount of caffeine solution used were controls, meaning they were kept the same at all times.

  1. Features of Excel

    Whenever the user enters into the cell, a note is produced for that cell that will inform the user what information is to be put into the cell. I can use this to show where to put important information e.g.

  2. Biology GCSE Definitions

    phospholipids Phosphate end is hydrophilic, fatty acids hydrophobic and so phosphate end will dissolve. Amino acids Have a central carbon bonded to H, an amine and carboxylic group. Last group is the R-group differs in each amino acid. 20 possibilities Join to other amino acids by condensation reactions between -OH

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