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

    the information about a patient whose surname is Anita and D.O.B is 07/04/88. Expected Result I should find only one result, as the information for each patient is different. Fields Used Patient ID, Doctor ID, forename, surname, gender, D.O.B, address, NSH number, date admitted, date discharged, ward, phone number, post code and illness.

  2. Database design.

    Deleting a record To delete a record I placed a button on the forms as shown below When I click delete a record a message comes up and asks if you are sure you want to delete the record like so: To Delete a record click the delete record button.

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

    suitable than an alternative such as a spreadsheet, because it allows users to create reports and queries, which is really useful and not as easy to do with spreadsheets. Any information on a spreadsheet can be edited by anyone who accesses it, whereas with a database it depends on the user.

  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.

    The same team of seven staff work here but the only thing that is dealt with in this office is money. * The main function of this office is to collect all the money that the bingo has made in that day.

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

  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.

    The system I have created will have a print button on it. 1. I should be able to edit for example to delete old clients and store details and keep record of the data and keep record up to data and recent.

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