**Do Now!**

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

**Click here to play Monkeytype**

**Let’s start spreadsheets**

**Lesson Objective : **Understand that a spreadsheet is made up of cells with cell references

Use formula to add cell references together. Also subtract, multiply and divide

Use the correct operators, +, -, * and /

Extra, create your own spreadsheet and make a shopping list

**Learning Outcome :** Download and open a spreadsheet files. Enter cell references

Create a simple shopping list spreadsheet

**The Big Picture**

**What have we done?** This is our first spreadsheet lesson

**What are we doing? **We are going to use a spreadsheet and enter cell references and formula

**What are we going?** We will use spreadsheets to make lots of calculations

A **spreadsheet **program is made up of a large table, called a sheet.

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 below is B3.

**Task 1 : The Wizard’s Challenge**

**Note : You may need to select Enable Editing**

Enter the correct **cell references** into the appropriate cells in the table.

You can simply **click on any cell** to start typing into it.

You can also use the **arrow keys** on the **keyboard** to move from cell to cell.

Press the **ENTER** key once finished.

If the cell reference is **correct**, the cell will turn **green**.

**Task 2 : The Formula Challenge**

**This week’s task**

MS Excel Version : **2. The Gold Mine**Download

**Note : You may need to select Enable Editing**

**Instructions**

Work out the answers to various calculations and if they are right, the cells will automatically turn gold.

You can enter formulae into cells to help work out the answers.

All formulae must begin with an = (equals) sign

See example in D7;

**=B7+C7 **will add the numbers of the 2 cells together

**If you finish, you can go to level 2**

**Task 3 : The Shopping List**

**Task : Create a shopping list like the one shown below. **

Open a blank Google Sheet or MS Excel file.

You can create your own shopping list, it could be clothes items, sports gear, electronics or anything else

Use 3 columns, shop, item and price

Use borders and shading to format your spreadsheet

Write a SUM formula so that adds up all of the shopping

Extension : Add 2 more columns to the spreadsheet, Quantity and Total Price.

Use a formula to work out the **total price** of each item.

For example : Total Price = Price * Quantity

### Like this:

Like Loading...

*Related*

## Leave a Reply