• 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. The aim of my project is to make the task of the allocation of ...

    I have recommended Mr. Brown to backup his work on a floppy disk every week or so, he could also do this with a CD RW, which store a lot more data, but cost a lot more and would probably be a lot more complex for Mr. Brown to understand.

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

  1. Database Hajj&Umrah travel agency

    Employing more staff is also another option, but then this would prove too expensive, and it is more efficient with an actual program to run the hotel bookings from. HARDWARE I will use many parts of hardware to access information and enter information.

  2. Database Review of Document

    left lying around where just anybody could get their hands on it. If this was to happen on the day of the competition, Joe Bailey's brother could get his hands on the database, and change Joe's scores to allow him to win.

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

    I decided this worksheet was going to record students' progress in English, each table had its own purpose they were split up into; term test results for reading, term test results for writing and overall English grade. First of all, I started to create the table for term test results

  2. AQA GCSE ICT Specification B

    They are extremely flexible and in the long run, the most cost effective of the three solutions. This is why I have chosen option three as the most viable system. Specification of Solution System Overview Number of total users of the system One Maximum number of concurrent users One ICT

  1. Project 1a. ICT

    Third Step: Now, my third step is even simpler, as I have just filled in the text boxes with my full name and form and the title of my full project 1a. My project is in the font of Arial as this gives the child an easy font to read.

  2. designing a website - report

    This allowed me to easily put the navigation buttons on my page. Then I pressed Next >. Then the following window has appeared: Then I clicked Next > again to go to the next step. The last window which has appeared was one where I could choose the properties of the link bars.

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