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

    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.

  2. Database Design Guideline

    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. ICT specification

    want to upgrade to a higher class car for a week so that they can give themselves a luxurious experience. The company on average would make 20-35 transactions in a day. Data for the system Mini size 2dr Capacity Price Ford KA 2 �167.00 Daewoo Matiz 2 �167.00 Seat Marbella

  2. Database design for a farmers herd book.

    These databases may have their own thesaurus, which lists the specific subject terms used. The Library of Congress Subject Headings is an example of a controlled vocabulary. It is used to assign the subject headings in TROPICAT. MEDLINE and other health databases use the controlled vocabulary of MSH (Medical Subject Headings).

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

    Staff will use my new system to update the information on the database, and various customers will also use it. Couples, families, students etc will all be able to book appropriate holidays themselves, and view what is on offer. I am going to be creating a database, which is more

  2. Main aims and functions of Buckingham Bingo.

    The prize money for these two games is very big so the office has to take all of the winners personal details and bank details in order to grant the customer with there winnings. Cash Office * This is another section of the main office, but this is where all the money is dealt with.

  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