If you finish this bit, then move on to complete the other slides (more details below)

By the end of this lesson you will:

By the end of the lesson

Know what a spreadsheet is

Understand some of the uses of spreadsheets

Be able to create a basic spreadsheet

Be able to state a benefits of spreadsheets

What is a spreadsheet?

I like to this of a spreadsheet, as a very large piece of paper, where we can make lots of calculations.

There appears to be lots of boxes. These boxes are known as cells.

Each cell has a cell reference.

The cell reference is the column letter followed by the row number. The cell reference for the green cell above is B3.

What does a spreadsheet look like? What can you see on this spreadsheet?

Benefits of Spreadsheets

A spreadsheet set up correctly saves time, saves effort, can be very accurate, works brilliantly for repetitive calculations, makes calculations much much faster than a human, can look at different scenarios i.e what happens if I apply VAT to the costs

What else?

Task

Continue with the rest of your presentation

Here are all the slides.

Practical Spreadsheet Task

The Shopping List – Extended Version

Open a new spreadsheet and create this shopping list as shown below

The yellow cells require a formula, which will be the Price multiplied by the Quatity

Use Borders and Shading and fill cells

Using borders

Using Shading

In cell E4, you need to put the formula to work out the Total Price of Crisps.

This will be Price multiplied by Quantity

See the suggeation below

Write a formula to work out the price of all of the other items.

Another Extension Task : Football table revisited

Create a Premier League football table like the one shown below. Add more teams and change some of the results.

## Leave a Reply