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

ICT - I have been asked to create a spreadsheet to show theatre ticket sales, by logging information into seating plan. Formulae then calculate the profitability on a 2nd spreadsheet, to work out a Total Profit for the desired show.

Extracts from this document...

Introduction

Chapter 1: Identification The Aim of the Project I have been asked to create a spreadsheet to show theatre ticket sales, by logging information into seating plan. Formulae then calculate the profitability on a 2nd spreadsheet, to work out a Total Profit for the desired show. This total takes on board the confectionery sales, fixed costs, bar profit and programme sales plus the price of the show. Background I was contacted by Ben Chapman from the King's street picture house in East Grinstead, he wanted to have a quick way to work out if he was/n't going to make profit on a show. All the seats previously had to count by hand, Mr Chapman thought this was a long drawn out process of doing quite a simple process but was also easy to make mistakes. Mr Chapman also wasn't happy that he was employing someone to do it, so every show was costing him higher labour costs than needed. ...read more.

Middle

no specified cells and all data would be entered manually this would take a long time and all the formula's would have to re-entered for each show. There would be no seating plan or buttons for ease of use and the show prices would have to entered manually instead of from drop down menu's Reasons for selecting the chosen approach The spreadsheet I used (Excel) overcomes all of the problems that Mr Chapman was having, I could also use buttons to enter data into a seating plan to make the interface very user-friendly for the person operating the system. This solution also used formulas that I could fix so that they could only changed with a password. Excel allowed me to use colours and a very easy on the eye design. I also selected the approach because I am an experienced Excel user; this allowed me to complete the job promptly and without major problems. ...read more.

Conclusion

5) The spreadsheet may be altered by anyone Mr Chapman trusts with his desired password that locks any important formulas 6) To show seating plan that can be easily read and understood for future projects and marketing schemes to promote the theatre 7) To be able to be updated in the future and not have to be totally re-written. Chapter 2: Analysis Hardware & Software Hardware Reasons for choice of hardware Software Reasons for choice of software Input Data requirements Data collection Data entry Error checking Data manipulation/processing (only include the ones you have used!) Formulas The SUM function The IF function VLookup Copy & Paste Displaying to 2 decimal places Cell formatting Cell protection Data Validation Macros Output System Flowcharts Backup & security Chapter 3: Design Initial design Customer feedback Final design Test plan Chapter 4: Implementation Solution being developed Finished solution Spreadsheet showing data Spreadsheet showing formulas Macro code Testing Chapter 5: Evaluation Comparison of solution with original objectives Customer feedback Response to customer feedback Suggestions for further enhancements ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Test Plan for Software

    place and trigger a message to remind the user that the format of value should only be in date form 32 Validation : Opposition, Required value Deliberately miss out that field and go on to the next record it should prevent the action from taking place and trigger a message

  2. ICT PROJECT

    copy student details Range("A22:I22").Select Selection.Copy Sheets("Marking Archive").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False 'Select mark number sheet Sheets("Marks No").Select Range("A1").Select Application.CutCopyMode = False End Sub User Form 1(Exit System) I used the toolbox to design the user form, and then double clicked on the buttons to create the macro code.

  1. GCSE Excel Project ICT

    Service Pack 2 (2600.xpsp_sp2_qfe.070227-2300) Print technology Printing method 4-colour inkjet printer with Dual Black Ink System, Epson Micro Piezo(tm) print head Nozzle configuration 360 nozzles Black / 59 x 3 nozzles Colour (cyan, magenta, yellow) Droplet size 3 Pl (minimum)

  2. Impact of ICT on the community

    the cashier has to do is to scan it and the customer will receive the receipt which say the price. Evaluate on the use of ICT - good/bad features (advantages/disadvantage of the technology Bar Code scanner is used in various places in my community it is mostly used in Supermarkets,

  1. The impact of ICT on a person with special/particular needs

    It is used to view television broadcasts around the world. It processes and produces sounds and visuals from these broadcasts. It provides entertainment in various forms, e.g. educational, cultural, comical etc. Nearly every household has at least one of these and a television has very much been, since its creation

  2. The impact of ICT on an adult in employment. The work of an Atif ...

    Ajaib can pass on relatively important information using Facebook as a medium, saving the time to locate and meet the person in real life. The simple access to internet is all that is needed which can be found almost everywhere-Wi-Fi connections, libraries, phones, schools and other such places!

  1. Producing documents for a company. Spreadsheet, Invoice and Website.

    This way the company would have necessary data recorded and updated although it's hard and time consuming. In addition to all that the company would need a cabinet/store room to store the papers. Although this application doesn't cover all (few)

  2. Computer Systems Assignment 2

    PSP with sat nav, or to use the route planning software, you would need access to the internet either through your 3G network or through broadband on your PC. You would need the US Army to keep the satellite at the correct earth time.

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