Suki’s Skate Shop Spreadsheet

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

What is a spreadsheet?

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)

Add the following items to your spreadsheet

You can also add some extra items of your own

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

Add 2 more columns

Notice that you have to use the dollar sign on the cells to work out the discounted price

Using borders

Using Shading