• 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. ICT PROJECT

    ' ' mcrexit Macro ' Macro recorded 12/29/2006 by OFFICE 'Loads a userform asking the user if they are sure they want to exit Load UserForm1 UserForm1.Show End Sub I did not come across any problem when creating and designing this sheet.

  2. GCSE Calculator Project

    Processing These are the four basic operations, these are plus, minus, divide and multiply. Data Processing The diagram below diagram shows how I will process the data for the calculator. Plus function = Minus function = Divide function = Multiply function = Memory saves = Outputs The main outputs of

  1. The use of ict has changed the way in which people work. Explain the ...

    Orders and invoices are now sent and received electronically. EDI works by connecting personal computers to modems. Now they can deal electronically with all its main suppliers .Process control by computers, Computers control fermentation, Microfiltration, and the movement of the cider.

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

    This satisfies Sarah's need of wanting to be normal which comes from her lack of experience with other people. She gets to experience how people behave and the likes on the TV; something helpful for someone like Sarah who barely leaves the house.

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

    The BlackBerry messenger works much like an instant messaging program such as MSN, Yahoo messenger, AIM and any other innumerable IM programs there are out there. It simply allows you to connect to other BlackBerry phones as long as you have added their 'BlackBerry pin' to your own BlackBerry.

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

    And in addition to that a Spreadsheet making program. It will include that the company purchases a spreadsheet editing program. The information would be entered by using a computer system in to a spreadsheet window. This alternative covers all the user requirements. This application is more sophisticated than all the other applications.

  1. Computer Systems Assignment 2

    To have a 3D representation of a building project, or of a City or product, either to be designed or to use as an aid to selling. Joystick Used for computer games and simulators and for all-terrain sexapod vehicles, and also used in planes and helicopters.

  2. Ict and an Adult in Education

    Mr Williams can view student's progress on GCSE grades by using created databases in DataPower which stores coursework marks, comments and examination marks. Formulae is used to estimate the final grade the student may be given to the student, he can do this by using board supplied information.

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