# That Blue Square Thing

## School Trip Activities

I haven't taught Functional ICT for a few years now and was still quite surprised to find out that it was still going. A lot of the help sheets here are aimed at older versions of Office software, but the key ideas should still be vaguely helpful.

These activities are an introduction to Functional IT Skills tasks.

They're a good way to judge your skills. If you can do them quickly and easily then you're probably working at Level 2. If you find them a bit trickier then you'll need to work at your skill level before you can pass at Level 2.

There are three activities in this set:

Activity B - a poster to advertise the trip

### Introduction:

A school trip to Pleasurewood Hills is being planned. You have been asked to help the student office staff to plan the trip.

There will be 45 Year 10 students going on the trip, with 6 members of staff. The trip will take place on the last Wednesday of the summer term.

### Activity A - Trip Costs:

The student office have started to produce a spreadsheet to work out the costs for the trip. They have sent you some information using e-mail.

Open the e-mail from the student office and read it carefully (right click and open in a new tab might be helpful)

tripcost.xls spreadsheet file (right click and Save As might be useful)

You will need to:

a) Find out the entry cost per person for a pre-paid school trip

b) Complete the spreadsheet using this information and the information in the e-mail from the student office

c) Enter formulae to calculate the cost per item

d) Use a function to calculate the total cost of the trip

e) Use a formula to work out the cost per student for the trip (remember: teachers always go free on school trips!)

a) Improve the appearance of the spreadsheet to make it suitable for printing

c) Save and print your spreadsheet making sure that all the data can be seen. Check that it is fit for purpose.

The student office wants to use a chart to show how the cost of the trip is made up.

a) Use the spreadsheet to create a bar or column chart to show the costs of each item. This should be the total cost of each item on the spreadsheet (the travel costs, the entrance costs for students etc...)

b) Make sure your name, school and class are in the footer of the graph sheet

c) Save and print your chart. Check that it is fit for purpose.