Discussion in 'Computing and ICT' started by colwynexile, May 3, 2011.

1. ### colwynexileOccasional commenter

I would start from scratch with them, this way you can be sure that they all have at least the same basic knowledge that you're giving them.
Start off with rows and columns, battleships is a good way to start with getting them to understand it, or if they are more 'arty' picture painting using a 'paint-by-cell numbers' technique.
Follow up with basic arithmetic formulae. A catchy phrase helps the pupils to remember to put the = in front (amazing how many forget to do this), I use "we're telling the pc we're doing maths work", if they grasp this you can quickly move onto creating a party budget sheet which will allow you to utilise functions and introduce modelling, graphs, spinners, absolute cell referencing, IF statements and even conditional formatting
You can then pair this up with the formatting work you've done and introduce lines to produce 'professional' tables and not tables where the pupil thinks it is cool / professional / clever to have each line in a different colour.
Finally you can introduce a scenario where they have to make decisions based on information you provide that they then manipulate to find the answers, whilst producing a professional report explaining their choices with tables and graphs.
That should be a unit of work for you