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

  2. The use of IT in producing a news letter.

    Click the placeholder text "Lead Story Headline" and type School will be closed on 7th may or the title of your lead story. 5. Click the placeholder text below the Lead Story Headline. Type your story into this frame or paste a story into the frame from Microsoft Word (or other word-processor).

  1. What is a computer registry?

    Collapse this tableExpand this table Registry hive Supporting files HKEY_LOCAL_MACHINE\SAM Sam, Sam.log, Sam.sav HKEY_LOCAL_MACHINE\Security Security, Security.log, Security.sav HKEY_LOCAL_MACHINE\Software Software, Software.log, Software.sav HKEY_LOCAL_MACHINE\System System, System.alt, System.log, System.sav HKEY_CURRENT_CONFIG System, System.alt, System.log, System.sav, Ntuser.dat, Ntuser.dat.log HKEY_USERS\DEFAULT Default, Default.log, Default.sav In Windows 98, the registry files are named User.dat and System.dat.

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

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

    were the "Overall English Grade" table was positioned; therefore it was easier for the teacher to have the student names next to the table. I then changed the formula for the overall percentage, as this time I had to add up the term scores for both reading and writing and divide it by 600 not 300.

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

  1. Analyse appropriate hardware and software needed.

    Backup of the system Backup Backup can be used in case any information is misplaced or lost. Losing data can be a serious consequence if you don't have any back up, and can take a very long time to get all information back.

  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.

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