• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Design Specification for Dream Tours.

Extracts from this document...

Introduction

Design Specification for Dream Tours I am in employment with Cambridge systems limited I have been given the prospect to utilize a system enabling dream cruises to boost their overall performance. Dream Cruises have come within reach of my organisation, they specialise in cruises ships that sail in the winter periods. Numerous cruise ships will be drifting from Dover to Madeira and the Canary Islands, calling at Spain, Portugal, Lanzarote, and Gran Canaria, at each port of call, tours are arranged for passengers. Dream cruises legislative body give booking information to tour Officers, which are accountable for organizing the tours. I'm expected to utilize a system to correspond with the dream cruises arrangements, allowing the tour officers to produce various outputs which will support them in their obligation of controlling the excursions booked. The main objective of the organisation is to process specific data in an automatic way which will speed up and simplify the method of booking a reservation. This will create many benefits to the tour operators, as the system will be easy and fast to use with hyperlinks and assigned macros, which will generate graphs and charts which in turn makes movement around the sheets easier. This can influence the worker as they are given more authority and responsibility to carry out their task. Every sheet would contain hyperlinks to all pages of the countries and to the front page. ...read more.

Middle

To insert subtotals, you first sort your list so that the rows you want to subtotal are grouped together. You can then calculate subtotals for any column that contains numbers. I also have to enter dates for every tour. The 'IF' Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. In my case the 'IF' statement is used for the status this tells the user if the transport is full, overbooked or if are still spaces remaining, the system will automatically be updated when changes are made. The spreadsheet will have to be carefully validated as the tour operators will need to enter all the variable data. Due to this I must add validation checks so that the tour operators will know when they are entering invalid data into the cells. If invalid data is entered a message will appear on the screen. The message box will hold a large red circle with a cross. This is expressed so that they what type of data should be entered instead. I am going to process my data in formats such as text, geometric and graphical. I will also disperse Macros to buttons which will link charts and graphs with precise data such as total profits. Including 'IF' statement to renovate data to equations. I will be using numerous varieties of charts and graphs which can be outputted to show the data in diverse formats. ...read more.

Conclusion

This is important as it high-lights the values that are below a certain range, so that then the operator can act upon on it. Macros - If you carry out a task continually in Microsoft Excel, you can computerize the task with a macro. A macro is a succession of instructions and functions that are stored in a Visual Basic module and can be run whenever you need to act upon the task. When you record a macro, Excel provisions information in relation to each step you take as you complete a series of commands. You then operate the macro to reiterate, or "play back," the commands. I have used this in a way that it can produce graphs and charts at a click of a button, so that the user can simply click the Macro operated button to complete the specific task. Nested 'IF'- I have used the 'IF' as it returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. In my case the 'IF' statement is used for the status this tells the user if the transport is full, overbooked or if are still spaces remaining, the system will automatically be updated when changes are made. Validation - Data validation is premeditated to display messages and avert invalid entries only when users type data directly in a cell. When data is imitation, filled, or calculated by a formula, the messages don't appear. Karthik Manthena 1 ...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. Database design.

    can see the first field is the customer ID and it is a number it is also the key field for this table.

  2. ICT specification

    2 �167.00 Daihatsu Cuore 2 �167.00 Fiat Siecento 2 �167.00 This is the data on the smaller class of cars that are designed to hold only two passengers. The price on all five of these cars is set at �167.00 which is very adequate because it can allow the customer

  1. Main aims and functions of Buckingham Bingo.

    * This office deals with problems too, but only problems that concern money. For example if money was reported lost, found or stolen the customer would come to this office and report it. The member of staff that is the office has to then deal with that problem and make sure that the customer is happy.

  2. Develop a spreadsheet application for the Ibis Hotel.

    This caused Ibis Hotel many problems such as when typing and an error would occur the whole document has to be re-written. * There is also a main problem with using typewriters at Ibis Hotel, as many standard letters have to be sent to many visitors or mainly the staff at Ibis.

  1. ICT - Specification.

    As well as accuracy there might be a problem with storing all of the data, as time goes by the amount of paper will double and there might be a problem with looking back at months if it's all in one pile.

  2. Designing a new system - ICT - Direct traveller is an atoll bounded tour ...

    What are the aims of your current system? The aim of the system is to store customer's details and to organise holidays for these customers. General procedures 4. Do you have any time lines or deadlines for example daily, weekly, monthly, annual, per job?

  1. Design specification for an IT system for Harry's Dog Kennel business.

    on cells where names are to be typed in , as some first and surnames are not recognized by spell check 5 Be user friendly and suitable for the target audience Harry should be able to use and understand the solution with little to no confusion.

  2. ICT Specification for a spreadsheet for the Hairdressing business.

    presence check or a formula checks in the system. Validation rules have been entered to reduce the amount of errors occurring in the database system In order to keep the records correct and up to date. 1. The system must be able to have a print button and save the work quickly and easily I will have a print or save button.

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