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

    Video (Video_ID, Video_name, Video_category, Video_cert, Video_rental_price, date_out, date_returned video_copies) 2 NF Functional dependency Customer (Customer_ID, Customer_surname, Customer_firstname, customer_street, customer_town, customer_postocde, customer_phone ) Rent (Customer_ID, Video_ID, date_out, date_returned) Video (Video_ID, Video_name, Video_category, Video_cert, Video_rental_price, video_copies) 3 NF Customer (Customer_ID, Customer_surname, Customer_firstname, customer_street, customer_town, customer_postocde, customer_phone ) Rent (Customer_ID, Video_ID, date_out, date_returned)

  1. System specification

    The way the data is entered should be consistent across all the tables i.e. the same font, colour etc. - Queries can be made to find the data that is needed for the mail merge, e.g. the queries are used to find out what members are interested in punk music and ska-punk music and their names, addresses, titles etc.

  2. Database Design Guideline

    making mistakes in my database this is why I think a validation rule is important in my database. ==> Relationship- A relationships works when you extract information from both of the tables. It is a common link between the two tables.

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

  2. Database design for a farmers herd book.

    currently in use is very outdated as they are using filing cabinets that are not only hard to navigate, but aren't very space efficient. I feel that the advantage and disadvantages of a new system would be best described in a table; Advantages Disadvantages Tidier Expensive to implement Space sufficient

  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