Spreadsheets lesson 2

1 / 10

Slide 1: Slide

ComputingLower Secondary (Key Stage 3)

This lesson contains 10 slides, with text slides.

Lesson duration is: 50 min

Items in this lesson

Spreadsheets lesson 2

Slide 1 - Slide

Do Now: Excel task

Slide 2 - Slide

Lesson 2: Quick calculations

Conquer: Use basic formulas with cells

Aspire: Apply the autofill tool to replicate cell data

Slide 3 - Slide

Spreadsheets: Calculations

Spreadsheets can do mass calculations very quickly, we use spreadsheets to store mass amounts of data and calculations using formulas.

Slide 4 - Slide

Each cell reference is made up of...

In the cell, type:

= c3 * e3

Press Enter

What happened?

Slide 5 - Slide

Slide 6 - Slide

Slide 7 - Slide

Complete the final 2 tables

Use your new autofill skills

Slide 8 - Slide

ISL shopping list

The shopping list is designed to cater to different quantities of people

The first list with costings has been done for you with 8 people

Complete the table to find out the other costings for the party.

Slide 9 - Slide

Extension tasks

If you complete all tasks, use 1 of these 4 extension tasks to develop your skills.

Slide 10 - Slide

Spreadsheets lesson 2

Items in this lesson

Slide 1 - Slide

Slide 2 - Slide

Slide 3 - Slide

Slide 4 - Slide

Slide 5 - Slide

Slide 6 - Slide

Slide 7 - Slide

Slide 8 - Slide

Slide 9 - Slide

Slide 10 - Slide

More lessons like this

Computing On Spreadsheets 1-2 Lesson Help

Computing On Spreadsheets 1-2 Lesson Help

Session 1

ICT 8/11/24 Excel

Mastering Productivity in Spreadsheets

Mastering Spreadsheets: Entering and Editing Data

Mastering Validation and Redundancy in Spreadsheets

Spreadsheets lesson 1