spreadsheets - starter. spreadsheets “visicalc was the first spreadsheet program available for...
TRANSCRIPT
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