16 - DL Excel Introduction

• Computing
• Lower Secondary (Key Stage 3)

Excel: Introduction to Basic Functions

Think (silent and solo)

How is data stored in a spreadsheet useful?

Thinking points:

What can we do to the data?

How does the data look?

Pair (Or Threes)

Discuss, how is data stored in a spreadsheet useful?

 

Thinking points:

What can we do to the data?

How does the data look?

Share:
One group member; write down your answers.
The others dictate.
How is data stored in a spreadsheet useful?

Key Objective: To be able to use Microsoft Excel and it's basic functionality.

All: Be able to create a spreadsheet, use the formatting tools and basic calculations.

Most: Apply this knowledge to create an effective spreadsheet with calculations

Some: Understand sum and average functions in Excel and why to use each.

Formatting

Draw a Monster Face in Excel using these tools:

Fill Colour

Borders

Merge

Resizing cells

Write an order form

1: Copy Mr. Motley's Wholesale order form and try to match the formatting.

2: Which operation would we use to work out the subtotal?

( =,+, -, *, / )

How much are 4 packs of Chewits?

1. £7.16
2. £3.96
3. £7.96
4. £9.16

How much are 4 Snickers?

1. £7.16
2. £3.96
3. £7.96
4. £9.16

How much are 4 Twix?

1. £7.16
2. £3.96
3. £7.96
4. £9.16

Write an order form 2

1: Use Sum to work out the "Number of Items" and "Total Price" cells.

2: Find out how to calculate mean average in Excel.

How much are 2 twix, 1 chewits and 24 snickers

1. £143.23
2. £52.53
3. £49.72
4. £52.33

How much are 12 of eall four snacks?

1. £143.23
2. £84.72
3. £83.23
4. £92.12

=AVERAGE(??:??)

Find the average price of an item

What was the average price of an item?

Think (Silent and Solo)

Where can you put these skills into action in real life?

Pair (or Threes)

Where can you put these skills into action in real life?

One writer, one dictator.
Where can you put these skills into action in real life?

What is a cell?

1. One line going along.
2. One line going down.
3. A calculation.
4. One box.

What is a column?

1. One line going along.
2. One line going down.
3. A calculation.
4. One box.

What is a row?

1. One line going along.
2. One line going down.
3. A calculation.
4. One box.