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

Task 1

Workbook link here

Draw a Monster Face in Excel using these tools:

Fill Colour

Borders

Resizing cells

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

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

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?

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.

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.