1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Hi Guest, welcome to the TES Community!

    Connect with like-minded professionals and have your say on the issues that matter to you.

    Don't forget to look at the how to guide.

    Dismiss Notice

Urgent advice or help needed please. Spreadsheets

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

  1. colwynexile

    colwynexile Occasional 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
     

Share This Page