Spreadsheets lesson 2

• Computing
• Lower Secondary (Key Stage 3)

Spreadsheets lesson 2

Do Now: Click here

Open the excel document, then click download

Complete the multiplication table

Lesson 2: Quick calculations

Conquer: Use basic formulas with cells

Aspire: Apply the autofill tool to replicate cell data

Spreadsheets: Calculations

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

Each cell reference is made up of...

In the cell, type:

= c3 * e3

Press Enter

What happened?

Complete the final 2 tables

Use your new autofill skills

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.

Extension tasks

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

Code combat

Toxicode

Nitrotype

Semantris