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

Flight Spreadsheet Report. The task we had to complete was to find prices of flights to Belfast from London (with return flight) and compare the prices in a spreadsheet document.

Extracts from this document...

Introduction

Flight Spreadsheet Report Introduction The task we had to complete was to find prices of flights to Belfast from London (with return flight) and compare the prices in a spreadsheet document. This was so the class could pay the least price for the flights to and from Belfast Choice of ICT Application I chose Microsoft Office's Excel to complete the task with because it is comparably user friendly to competitors and it is an easily accessible piece of software that the school has already bought for me to use. I also used Internet Explorer in order to research the airlines and find prices. ...read more.

Middle

The spread sheet can be viewed here. How ICT was used to find a solution Without the internet, we would have to ring up the airline or even go to an airport or travel agent in order to book a flight. In Microsoft Excel, we set up the spread sheet by preparing a plan. Our teacher also gave suggestions on how to prepare it to a suitable standard. The task sheet also gave us some pointers for what was required in the spread sheet, such as the columns and headers. I have printed out an attachment which shows all formulae on the documents. ...read more.

Conclusion

The formula bar is pictured to the right. To make the bar chart, select the cells you want to be in the axes and click on insert and column, then click on a diagram that is appropriate. I chose the first one. Here is a formula view of the appropriate columns: I dragged the bottom right corner of the cell to replicate formulae. This is pictured below. Problems & Changes I had to make sure all currency cells were right aligned, and that they had the 2 required decimal places. I also added a header and footer to explain what the documents were made for and by whom. In addition, I added the column, named 'Total Per Pupil', since the pupils pay for the adults. ?? ?? ?? ?? Assignment B3 Bryn Roberts 33149 Saddleworth School ...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. Design a spreadsheet that can be used by a school tuck shop.

    =F3*E3 =J3/K3 =F4*E4 =J4/K4 =F5*E5 =J5/K5 =F6*E6 =J6/K6 =F7*E7 =J7/K7 =F8*E8 =J8/K8 =F9*E9 =J9/K9 =F10*E10 =J10/K10 =F11*E11 =J11/K11 =F12*E12 =J12/K12 =F13*E13 =J13/K13 =F14*E14 =J14/K14 =F15*E15 =J15/K15 =F16*E16 =J16/K16 =F17*E17 =J17/K17 =F18*E18 =J18/K18 selling price profit per item 0.35 =M3-L3 0.35 =M4-L4 0.35 =M5-L5 0.39 =M6-L6 0.38 =M7-L7 0.35 =M8-L8 0.35

  2. AQA GCSE ICT Specification B

    Numbers Only - - - No Required If PaymentType= Credit Card 1234123412341234 . Query Design Query1 Query type: Select Tables included Table 1 Purpose of query: The basis for every other form, it contains all information. Field Table Sort Show Criteria Or Or Order ID Table 1 - Yes -

  1. Database Review of Document

    * To encrypt data * No unnecessary connections to the internet. * If connected to the internet, make sure all the proper precautions are in place, e.g. antispyware, firewalls, encrypted connections * Make sure the internet connection is wired * Make sure only judges who need access to relevant scores are able to get that access.

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

    Once I had clicked on "Rename", the tab turned black and allowed you to type in your preferred name. The tab then turned back to white, once I had finished typing the name "menu" and had pressed enter. Step 5 Next, I decided I wanted three tables which included the headings I required, in worksheet 2.

  1. Project 1a. ICT

    Second Step First of all I would like to show you a normal plain document made from Power Point in the Microsoft office tool. This is a simple and easy slide to develop as you have the two tex boxes which are easily accessible and can be moved all over the slide.

  2. ICT BTEC UNIT 2 - REPORT

    drive The advantages for vista ultimate are that the GUI (graphics user interface) is totally new for this operating system which means that its an all new layout and has many more effects and settings. Vista ultimate also has a higher degree of security when surfing the internet.

  1. Spreadsheet Report

    changed I think it is a good idea to draw out a rough plan of the spreadsheet by hand before, this is because once I have profitably planed what I am going to do the it will be easier to maintain with my proper spreadsheet.

  2. Payments Spreadsheet task. - formulas and fomatting

    The outbalance per pupil uses a formula which tells you how much each pupil have to pay after every payment also the formula finds the outbalance by taking away 500 because it is the cost for the trip from the running total.

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