• 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 key is sometimes abbreviated as "HKLM." HKEY_CLASSES_ROOT Is a subkey of HKEY_LOCAL_MACHINE\Software. The information that is stored here makes sure that the correct program opens when you open a file by using Windows Explorer. This key is sometimes abbreviated as "HKCR."

  1. Appropriate Software To do this project I am going to use excel because ...

    The end user: Mr. Robert who sets the target Employees The staff that Mr. Robert employs The end user: Mr Robert who employs the staff Cost of the Employees The wages of the employees The end user: Mr Robert who employs the staff Units Sold The number of units sold for each product.

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

    green if students got greater than or equal to 70%, amber if they got between 50% and 70%, and red if they got less than or equal to 50%. I did not want to conditional format the whole worksheet, as it would have made the worksheet untidy and unprofessional; therefore I only added it to certain parts of my tables.

  1. Analyse appropriate hardware and software needed.

    CD- Disadvantages * Once CD rom is created information cannot be changed. * Slow upgrade * Limited access Disk- Disadvantages * too much disk space usage can slow down your computer * Can only store a certain amount Floppy disk-Disadvantages * Time consuming * Out of fashion * Limited capacity

  2. Analyse appropriate hardware and software needed.

    What is Science all about. Text From what the user knows of Science Keyboard Topics that will be taught in the Science club. Text This information will be collected form the user on what topics she will be teaching. Keyboard Times that the Science club will take place.

  1. 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.

  2. Powerpoint review project

    This is what my main slide will look like. It will have the following features added: Background: Blue and white from 'Slide Design' section Font: Bright Wordart for title and Gold 'Arial'

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