# 7 - DL Excel Introduction - Improved

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

In deze les zitten 15 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

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

#### Slide 6 -Tekstslide

What do these mean?
+ - / *
Complete the maths problems in task 2 using Excel formula
You can change to the task 2 sheet at the bottom left of the window

#### Slide 7 -Tekstslide

Use SUM, AVERAGE and formulas we've looked at to
complete the blanks in the spreadsheet
Remember task 3's sheet is at the bottom left of your window

#### Slide 8 -Tekstslide

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

#### Slide 9 -Tekstslide

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

#### Slide 10 -Tekstslide

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

#### Slide 11 -Open vraag

Create a spreadsheet for tracking the value of a collection you have or would like to start.

Some columns and labels have been provided to get you started.

#### Slide 12 -Tekstslide

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

#### Slide 13 -Quizvraag

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

#### Slide 14 -Quizvraag

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