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

    From here I will click the NEW button shown below. Then the following screen will appear, I will then click design view which is highlighted below. After clicking on new the window below will appear. I went to design view and then typed in the name I want the table to be saved as.

  2. ICT specification

    need of a trip therefore renting a car or is arriving at a new city or country and needs a pickup from the airport or wants a car to roam around the city with. Also there could be customers that are tired of driving the same car every day and

  1. Database Design Guideline

    Validation controls are given to create some rules for your assignment E.g. Validity check you can put minimum or maximum range. Validation rule gives you some rules witch you have to follow. The big advantage of using a validation rule is that there will be fewer changes of errors and

  2. Analysis of Whipps Cross Hospital

    I will also give each field its suitable form to access the information required. I will create a separate form for each doctor and patient in Whipps Cross Hospital so the information don't get mixed and makes it less complicated to store.

  1. Database design for a farmers herd book.

    If training is needed then User friendly Less mistakes Less space taken up Easy to navigate around the system Efficient Task 2 Explanation of the entities and attributes Entities An entity is a thing or object of importance about which data must be captured.

  2. A Design Specification for an ICT System Introduction Going places is one ...

    This is because travel agents' time is used up searching for holidays, which could theoretically be done by the customers themselves. This would cut out the middle man and allow Going Places to serve more customers. Better customer service could potentially be given if a method such as the new self-service kiosk could be employed.

  1. Main aims and functions of Buckingham Bingo.

    The complaints may come from customers or employees, but no matter what they have to deal with them. * In the bingo a big LINK game is played and a big NATIONAL is played. If one of the customers are luckily to win it they have to come to the office to claim there money.

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

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