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. This was so the class could pay the least price for the flights to and from BelfastChoice of ICT ApplicationI 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.Information Sources UsedI found information, including the prices that I used in the second spread sheet, on the airline’s websites: Flybe.com, Flybmi.com and Easyjet.com. Below are the screenshots of the websites I used.Results of the InvestigationThe cheapest airline surveyed, according to my spread sheet, is Easyjet who offer the flights for �2638.9.
This is because, as advertised, they offered no cost to the passenger, only the taxes had to be paid. We did not include any group discounts to any airlines as it was not advertised on the website. The spread sheet can be viewed here.How ICT was used to find a solutionWithout 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.To format the required cells, I selected the cells I wanted then right clicked and clicked the ‘format cells’ button. From here, I chose Currency for most cells and had 2 decimal places and a � sign to start.To do a times of 2 cells, simply type = (Cell one * Cell two) into the formula bar. The same format can be used for other types of mathematics but instead, replace the * with the appropriate sign.
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 & ChangesI 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.
