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

Selecting the best software for a theatre business.

Extracts from this document...


Introduction Bob Dixon owns a small Theatre in Woodford Green, it is called "Woodford Green Theatre". His theatre is not the best in London but it is highly rated. He has 1 theatre and hosts 1 show every month. His theatre may be quite small but it is old and worth a lot of money, a lot of the theatre has been refurbished and made more modern, but the only thing still not up to date is his way of working.. Since he opened the theatre he has used a paper based system for everything. He has used it for financial records and writing out the tickets and everything in between. He needs a computer to, have an automated system of seating, and to keep record of booked tickets and seats. Problem Identified The problem with Bob's way of keeping record is that he uses a paper based system and he has to file this all the time, if he loses one piece of paper he can be really be in trouble. On a paper based system he has to calculate on his own, if he changes a number he will have to re-do the whole sheet again. And if he loses something he will not be able to get an accurate result in any area and this could mean that he thinks he has a profit when he actually has a loss. If he keeps his paper based system he will have a lot of trouble in the future and will find it hard to show his records. If he keeps the paper based system then he possibly may need to employ a new person just for his paperwork. This would mean he has to spend more than necessary. I think this could become a bigger problem as time goes on. Bob has heard of mail merge, mail merge has many advantages so I can see why he would want it, it means he does not need to write all of the ...read more.


In Calc the same formula is written "=if(A1=10;1;0)" 2. One thing I did find disconcerting was Calc's propensity zip across the spread sheet too quickly. It flew up, down, left or right, if I happened to need to extend the graph target to a point that was off the screen. Once it hits the edge of the visible cells, it takes off like a rocket. 3. In Excel, if you highlight a cell and hit the delete key, the data in the cell is deleted. In Calc, the same operation will generate a pop up menu that give you multiple options for deleting. I initially found this to be an irritant, though I can see that it could be handy. Excel uses different delete options to provide the same functionality. Microsoft Excel The advantages of Microsoft Excel: 1. Once you have entered the formula that is needed, you can keep changing the data and it will keep calculating for you without you having to do anything. 2. Bob can use functions for example, IF, Average, Min and Max. 3. He can use Mail merge, create graphs, use formatting, validations and Macros 4. Excel files can be password protected for extra security. A user can create a password through Visual Basic programming or directly within the Excel file. The disadvantages of Microsoft Excel: 1. Users must create subset directories for data management. Excel data can be lost when the application is broken down into many files. 2. Viruses can be attached to an Excel file through macros. Macros are mini programs that are written into an Excel spread sheet. Solution Description The solution to his problem is just simply Excel. Excel provides so many helpful ways of keeping your data safe, laid out clearly and hard to completely lose. This program is specialised in spreadsheets. This will help Bob make sure he has all his data clearly set out and Excel also provides him with being able to send any important information to his business ...read more.


Yours sincerely, Mr Bob Dixon Managing director and owner of Woodford Green Theatre Hardware The hardware in Bob's office will need to include a keyboard for the user to type in any necessary information, a mouse so the user can navigate around the spreadsheet. A printer so that Bob can print of any price lists or customers names, Bob will need to have a scanner so he can scan his logo into the computer any other pictures he would like. Bob will need a camera to take pictures of his shows he will also need a fax machine so that he can send his business partner Steven all of the paper work, finally he will need the desktop package. Symantec Norton 360 Version 3.0 All-in-one Security. Bob would also have to buy a printer he will need one with a scanner and a fax machine in it. Having a printer with the other machines included saves money. Bob is going to need to back up his spreadsheet and he will need to buy a external DVD writer, this is because his spreadsheet is small so he will not need to have a massive backup. Software The software that Bob is going to need includes, Norton anti virus, this will allow Bob to block any viruses that may try to enter his computer, a virus can enter his computer from any ware, most likely from emails or the internet. He will also need to have the main program which is excel he will have to have the newest update (windows 7) and he will need the full professional version because he has not got any software on his computer yet. My personal tick list to make sure I have fulfilled all of the quantive objectives. * Clearly to understand * if statements * colours on spreadsheet * mail merge * goal seeks * v lookup user guide is attached. Abygail Hobday ...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. Evaluation of Microsoft Excel

    before getting to it, whereas in 2007's version, "Conditional Formatting" is the "Home" page. More or less, nearly everything is alright with using Excel, except the "##"s.

  2. What is a computer registry?

    This information is associated with the user's profile. This key is sometimes abbreviated as "HKCU." HKEY_USERS Contains all the actively loaded user profiles on the computer. HKEY_CURRENT_USER is a subkey of HKEY_USERS. HKEY_USERS is sometimes abbreviated as "HKU." HKEY_LOCAL_MACHINE Contains configuration information particular to the computer (for any user).

  1. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    From the dialogue box I set the condition that the 'Text Length' must only be 'Between' a 'Minimum' of 1 and a 'Maximum' of 8 characters. I then clicked on the 'Error Alert' tab, ticked the box so that an error message would be shown if an error message was

  2. The aim of my project is to make the task of the allocation of ...

    Reasons for selecting the chosen approach B The reason for using this approach is that it is fast and easy to use. The Excel environment is easy for the end user to understand as it can be labelled according to where the user must enter data, which is what Mr Brown wanted.

  1. Payments Spreadsheet task. - formulas and fomatting

    The reason why I added the total cost for 5 staff to the total cost of 50 children is because that the adult's price is paid by the 50 children and therefore needs to be taken into account in order to calculate the proper average cost per child.

  2. Analyse appropriate hardware and software needed.

    Text Forms filled ad handed to the employees Inputted into the system by employees No validation Data Manipulation In the system Customer, Car and Sales tables are required.

  1. Research, collect and describe graphics

    /neg. Pos.: Links user to other, subtle parts of the website. Neg.: Some users may not understand what is meant by them i.e. the germ. Pos.: Clear. Links user to original website. Neg.: Some people may prefer the original symbol.

  2. Fix the problem of the car company's storage problem, using either excel or access.

    Well, I no how important our data is and I want my system to improve. Ok, ill accept. 5) I have 2 different types of software for you, a spreadsheet and a database. Which would you prefer? After looking at this, I think that access looks better.

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