Do Now!

Before we start the lesson, typing practice is a nice way to settle ourselves down. Have a 10 minute practice.

In this lesson, you will be creating s spreadsheet model for Suki’s Skate Shop

I like to this of a spreadsheet, as a very large piece of paper, where we can make lots of calculations.

There appears to be lots of boxes. These boxes are known as cells.

Each cell has a cell reference.

The cell reference is the column letter followed by the row number. The cell reference for the green cell above is B3.

Knowledge Intention / Learning Objective : Create a spreadsheet based on a Skate Shop

Use borders and shading to format the table

Use formula to work out the price of Skating Equipment

Apply a 20 % Discount

Open a blank spreadsheet (MS Excel or Google Sheets) and create a spreadsheet table based on the one below

Task : Create the spreadsheet as shown below (the teacher may give you a template)

Formula

You need formula to calculate the total price.

This will be Unit Sales – Price Per Unit

The Discount per item, which is the Price Per Unit * 20%

The actual Price per Unit, which is the Price per Unit – Discount

The Revenue, which is the Discounted Price Per Unit * Unit Sales

Extension : Working out a discount