This lesson forms part of a series of lessons that I use with Year 7 students to introduce them to some of the powers (and secrets) that are available using spreadsheets!
I have found that students take 23 lessons to get through the learning activities (around 50 minutes per lesson)
The learning objectives are:
I have found that students take 23 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)
Stage 1  Multiplication Square
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 Explain: 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! 
Stage 2  Simple Calculator
Stage 3  Area and Perimeter Calculations
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!) 
I hope that these ideas are useful and the exemplar materials and powerpoint slides are below to download!
For other ideas for teaching aspects of Computer Science / ICT and Business, click here
For other ideas for teaching aspects of Computer Science / ICT and Business, click here

