7 - DL Excel Introduction - Improved

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

Cette leçon contient 15 diapositives, avec quiz interactifs et diapositives de texte.

time-iconLa durée de la leçon est: 50 min

Éléments de cette leçon

Excel: Introduction to Basic Functions

Slide 1 - Diapositive

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 - Diapositive

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 - Diapositive

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

Slide 4 - Question ouverte

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 - Diapositive

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

Slide 6 - Diapositive

Task 2 
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 - Diapositive

Task 3
A real spreadsheet!
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 - Diapositive

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

Slide 9 - Diapositive

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

Slide 10 - Diapositive

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

Slide 11 - Question ouverte

Task 4 Your spreadsheet

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 - Diapositive

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

Slide 13 - Quiz

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

Slide 14 - Quiz

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

Slide 15 - Quiz