7 - DL Excel Introduction

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

This lesson contains 15 slides, with interactive quizzes and text slides.

time-iconLesson duration is: 50 min

Items in this lesson

Excel: Introduction to Basic Functions

Slide 1 - Slide

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

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

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

Slide 4 - Open question

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

Task 1
Workbook link here

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

Slide 6 - Slide

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

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

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

Slide 9 - Slide

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

Slide 10 - Slide

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

Slide 11 - Open question

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

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