Introduction to Spreadsheets

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

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 MineDownload

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