Unit 2 · Information and Communication Technology
Spreadsheet
Science & Technology · Grade 7
Learning Objectives
📊Name rows, columns, and cell addresses
🟰Explain why every formula starts with an equal sign
➕Use autosum and write a percentage formula
🔄Explain why a spreadsheet updates itself
Building Blocks of a Spreadsheet
1Row, numbered
2Column, lettered
3Cell, where they meet
4Address, like B4
Column letter first, row number second. B4 always means the same square.
Presenter notes: Start with a calculator in your hand and a long list of marks on the board. Add them up out loud, slowly, in front of the class. Then rub out one mark, write a different one, and start adding again from the top. Someone will complain before you finish. That complaint is the lesson, so stop there and say: by the end of today you will never have to do that twice.