Blog Entry: 13

we are missing out task 4 and moving on straight ahead to task 5. we have been discussing databases and we are going to create one this lesson and develop it over the next few weeks xx

Task three was to find activites to do during the Paris trip and create a spreadsheet with the single prices and then the overall prices. I used the formula of 'VLOOKUP', 'SUM' and '(*)'.

What I went well...

We have now finished our Task 3 spreadsheet. For this task we had to find the final costs for the trip to paris.

For this task I was working across 2 spreadsheets, one was for raw costs and another was for final costs.

We've been doing Task 3 in our Paris Project-Planning the Trip. I think that my spreadsheet is quite well laid out and very clear, and so I'm quite pleased with that. I think that my information is well researched and well presented. I useed a lot of diffeent sources to get my cost information, sometimes the internet and sometimes material found on the M Drive.

For this task I had to create a spread sheet that included all the costs for the trip to Paris. I had to gather the information and then enter it into a spread sheet, which I have now completed.

To calculate the Paris trip costs I used excel as it has the tools needed to create a spread sheet with the relevant information in it. I separated the information into 3 sections, Travel, Attractions and Other, other includes accommodation and food.

I used vlookup, addition, subtraction, mulitplication and division formulas to work out the total costs.

www: I have used good lay out and design structure to show the numbers, I have used colours so that Titles stand out from the rest of the rows. Using colour and a second spreadsheet for Raw Costs has made organising the costs easier. I have used numbers sourced from the M-Drive for accomodation and coach costs. I found finding costs for day time activities rather easy once I found a web address that I could use.

Task 3

The ParisTrip

What went well......

i have completed all tasks for this task and it is all right. In this task we had to get prices of all the places we wanted to go and wanted to do and i have done that. we then put in vlookup and found the total price that  students would have to pay. eventually i did this all right.