# 16 - DL Excel Introduction

Excel: Introduction to Basic Functions
1 / 21
Slide 1: Tekstslide
ComputingLower Secondary (Key Stage 3)

In deze les zitten 21 slides, met interactieve quizzen en tekstslides.

Lesduur is: 50 min

## Onderdelen in deze les

Excel: Introduction to Basic Functions

#### Slide 1 -Tekstslide

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?

#### Slide 2 -Tekstslide

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?

#### Slide 3 -Tekstslide

Share:
The others dictate.
How is data stored in a spreadsheet useful?

#### Slide 4 -Open vraag

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.

#### Slide 5 -Tekstslide

Formatting
Draw a Monster Face in Excel using these tools:
Fill Colour
Borders
Merge
Resizing cells

#### Slide 6 -Tekstslide

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?
( =,+, -, *, / )

#### Slide 7 -Tekstslide

How much are 4 packs of Chewits?
A
£7.16
B
£3.96
C
£7.96
D
£9.16

#### Slide 8 -Quizvraag

How much are 4 Snickers?
A
£7.16
B
£3.96
C
£7.96
D
£9.16

#### Slide 9 -Quizvraag

How much are 4 Twix?
A
£7.16
B
£3.96
C
£7.96
D
£9.16

#### Slide 10 -Quizvraag

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.

#### Slide 11 -Tekstslide

How much are 2 twix, 1 chewits and 24 snickers
A
£143.23
B
£52.53
C
£49.72
D
£52.33

#### Slide 12 -Quizvraag

How much are 12 of eall four snacks?
A
£143.23
B
£84.72
C
£83.23
D
£92.12

#### Slide 13 -Quizvraag

=AVERAGE(??:??)
Find the average price of an item

#### Slide 14 -Tekstslide

What was the average price of an item?

#### Slide 15 -Open vraag

Think (Silent and Solo)
Where can you put these skills into action in real life?

#### Slide 16 -Tekstslide

Pair (or Threes)
Where can you put these skills into action in real life?

#### Slide 17 -Tekstslide

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

#### Slide 18 -Open vraag

What is a cell?
A
One line going along.
B
One line going down.
C
A calculation.
D
One box.

#### Slide 19 -Quizvraag

What is a column?
A
One line going along.
B
One line going down.
C
A calculation.
D
One box.

#### Slide 20 -Quizvraag

What is a row?
A
One line going along.
B
One line going down.
C
A calculation.
D
One box.