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

design an IT system for UTourEuro is a UK coach company who have bus depots in several towns in the UK.

Extracts from this document...


Timed Practical Task Assessment SCENARIO: UTourEuro is a UK coach company who have bus depots in several towns in the UK. Their head office, through which all bookings are done, is in the Midlands. They offer transport to: o Major attractions within the UK and in Europe e.g. The London Eye, Disneyland Paris o Music festivals and concerts in the UK and in Europe o Major cities in Europe e.g. Paris, Madrid, Rome, Munich, etc. As well as providing the coach for the journey the company can provide optional extras such as: * Arrange hotels for guests * Supply tickets and, where appropriate, local tour guides * Organise trips around local places of interest. (All of these items are charged for in addition to the coach fare) One of their most popular trips is to Europe normally through the Channel Tunnel. This consists of: * Picking people up at their local town and transporting them to a coach park where they will join the coach that will take them on their tour. * Arranging the pickups so that those people who live furthest away from the coach park will be charged extra for this journey. As with most tours there is a break even point that the company meet. In addition UTourEuro has to ensure that it makes a 20% profit on each tour. ...read more.


* I will then use mail merge to send letters out to their customers advertising major attractions and extra services they provide including arranging hotels for guest and supplying tickets and tour guides. * I will create a Microsoft PowerPoint presentation which UTourEuro can use to assist them with advertising at events like holiday exhibitions. I will design it in such a way that it will be able to run on its on which will save the staff time and mean that they can instead spend time on customer inquiries etc. * An ICT solution is appropriate for this task because it will provide easy means of communication, advertising and an automated, re-usable system that will save the company sectary a lot of time when wanting to send letters and brochures. Software Selection To complete the first task of creating a contacts database for UTourEuro, I am going to need to use software that will be capable of doing: simple searches, complex searches such as a duplicates query, data entry, validation of data entry and creation of reports in order to create a contacts database. Possible software for this task would be either a database, Microsoft Access or a spreadsheet, Microsoft Excel. As Microsoft Access and Excel are both part of the Office group of applications they share many common features. ...read more.


This is because word is specifically designed for the lay out of letters and some of the tasks that I need to complete do not require the sophisticated text and graphic functions that publisher has. Plan during TPT Time to be spent on task Task 1hr 1 hour will be spent on creating a logo and letter head for letters which I will save as a template using the logo. I will then design a brochure to advertise UTourEuro 1hr I will design a PowerPoint presentation on Microsoft Office PowerPoint which will include information about the company for prospective customers to view. 2hr I will design a database system to store UTourEuro contacts. During this time I will create data validation rules to prevent mistakes for occurring, a data entry form for the secretary to enter information, I will et up a query and also a report using the information from the query which can be used to send out to the tour drivers to show how many people he need to pick up from each town. I will also link the data from the database to a letter using mail merge. I will write a letter on Microsoft word advertising popular tours that UTourEuro does. 1hr I shall spend this time writing up the tasks and using screen shots as evidence of my practical work (especially for the database etc) ?? ?? ?? ?? Danielle Clark Bryan 11C ...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 Software 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 Software essays

  1. Aids and Barriers to Communication

    the attention of the audience and bright pictures that also do this. For example in a business a meeting maybe held and to help get a message across using a presentation can help this be made successful. This can become an aid to communication by making the speed of delivery

  2. Database design for a games shop.

    * Popular game: this report will contain, the popular games and genre, once Mr. Walcott has concluded which games will increase the effectiveness of his business, Ben will purchase these games. There will be an advanced query used to search the database: * Overdue games: this search will be done

  1. Selecting the best software for a theatre business.

    Another good thing about Excel is that it will always be on your computer as long as it is running okay because you do not need the internet to access it. There is only one minor problem and that is that you have to pay to have Excel, either when

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    whole is doing well, and which subjects the class is best in, and what areas need to be improved. To create a chart, I did the following: 1) I high-lighted the data I wanted my chart to display, however, my data was not situated next to one another, so I

  1. AQA GCSE ICT Specification B

    form, allowing all details to be condensed into a simple, clear, user-friendly display. Command Button: Performs a single function. Very simple, as it provides no room for error. Each button is clearly labelled and defined. Useful for opening and printing forms and receipts.

  2. How to construct a brochure

    Then, I selected a background for my front page, and inserted it on all of the pages. Then, I inserted the title and finished off the front page. Multiple Criteria search First, I searched for just 'phat farm' and came up with these results.

  1. Research, collect and describe graphics

    Impact Well-picked, clearly fits purpose as the icons connate the title of what they represent Attractive, yet to purpose - duplicate women to emphasise 'sameness' in Gemini. Shows the most common weather (cloud sunny). Plain, no colour -> Professional looks.


    525W 1TB SATA 3.0Gb/s,7200 RPM Hard Drive with 16MB DataBurst Cache 2GB, 800MHz, DDR2 SDRAM Memory, ECC (2 DIMMS) Dual PCIe x16 nVidia Quadro FX1700, Dual Monitor DVI Cable 16XDVD AND 16XDVD+/-RW, w/ Cyberlink PowerDVD and Roxio Creator CONCLUSION In conclusion I have found there are many things I like

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