I have found that students take 2-3 lessons to get through the learning activities (around 50 minutes per lesson)
The learning objectives are:
- Understand how excel can do calculations based on cell values
- Know how to use basic formula (add / subtract / multiply / divide)
The first stage of this lesson are to set up a Multiplication Square that is 10 X 10 (shown on the right here).
It is vital that formula are used to make the calculations and students do not simply just type in the answers to all the caluclations
In spreadsheets the times symbol is *
So 2 x 2 = 4 looks like . . .2 * 2 = 4
So the FORMULA to work out the answer here is:
=A2*B1 for the first number
The next stage is to make it look nice with Borders / Fill Colours / Fonts etc.
Students can now expland the multiplication square to go up to 15 X 15.
Colour all the numbers where the same two numbers are multiplied and also showing prime numbers are some extension tasks.
Teachers could show relative / absolute cells but this will be covered in a future lesson!
Now we get to very final stage of the lesson, to make the maths calculator look as good as possible!
Teachers could also now show how to lock cells and protect worksheets so that only certain cells can then be modified (the input cells) so that other people cannot mess around with the formulas used (this will be covered in a future lesson as well!)
For other ideas for teaching aspects of Computer Science / ICT and Business, click here