spreadsheets - starter. spreadsheets “visicalc was the first spreadsheet program available for...

Spreadsheets - Starter

Spreadsheets

“VisiCalc was the first spreadsheet program available for PC.”

“…application that turned the microcomputer from a hobby for computer enthusiasts into a serious business tool.”

“VisiCalc sold over 700,000 copies in six years.”

VisiCalc

Spreadsheets

This weeks topic is ‘Spreadsheets’

We will be using this to calculate information about different dinosaurs

Learning Objectives:

Learning Outcome:• Recognise and use cell references• Use the fill handle• Create and use simple formulae• Apply formatting to a spreadsheet

• Be able to state an example formula

Objectives and Outcomes

A spreadsheet is 'software' which consists of a grid which can contain 'text', 'numbers' and 'formulae'.

Spreadsheets can be used for making models, predicting and producing graphs. In school we use 'Excel'

What is a Spreadsheet?

A page made up of

Colu

mn

s

ROWS

Cells

Worksheet

Each cell has a name from the COLUMN and the ROW it is in.

A1

Cell Reference

AnimalCost per week to

feed each animal

Number of animals

Total cost per week for animals

Lion £10 0 £0

Tiger £10 0  

Zebra £5 0  

Elephant £10 0  

Snake £2 0  

Penguin £1 0  

Total cost     £0

Each cell can contain text, numbers

(or a formula - which you don’t see)

Adding Data

Today’s Task

Open the Spreadsheet from the ICT SoW

Complete Tasks 1 and 2 ONLY

Hands on head when finished

Click and drag to transfer a formula into other cells.

What about patterns though?!

Fill Handle

Sometimes you will have to show Excel the pattern by highlighting 2 or 3 first

Fill Handle

Go back to the spreadsheet

Now complete sheets/tasks 3 ONLY

Hands on head when finished

Today’s Task

Format border

Fill cell colour

Text colour

Change font style

Formatting

Undo/Redo Sort

Merge/Unmerge cells

Charts

Changing cell values

Formatting

Format text Alignment

Change font size

More Buttons

Go back to the spreadsheet

Now complete sheet/task 4

Hands on head when finished

Today’s Tasks

All formula must start with =

To add something, use +

To subtract something, use -

To multiply something, use *

To divide something, use /

Formulas

Go back to the spreadsheet

Now complete sheet/task 5

Once you have completed task 5 SAVE the SPREADSHEET in your year 7 ICT folder

Call it – Zoo Spreadsheet

Today’s Tasks

You now need to link your spreadsheet to your powerpoint

Follow along with the video tutorial on the ICT SoW

Today’s Tasks Continued

What do the following keywords mean? Worksheet Cell Row Column Fill Handle

Plenary

• Level 5 - Pupils will be able to identify features of a spreadsheet such as cell reference, value and variable. They will be able to edit the formula and change the look of the spreadsheet.

• Level 4 - Pupils will be able to identify features of a spreadsheet such as cell, data, column, data, formula, label. They will be able to complete the spreadsheet using the formula.

• Level 3 - Pupils will need support with using formulae and using the fill handle. They may be able to name some of the features of the spreadsheet.

Levels