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

Level 2 Spreadsheets

Discussion in 'Computing and ICT' started by Geordie_Pride, Mar 5, 2012.

  1. Hi, I wonder if any one has any ideas for a 10 minute spreadsheet lesson at level 2, I have an interview for a job and that is the time scale. Any ideas please ????
     
  2. 10 minutes is no more than a starter......
    Teach a use of a specific function -
    • IF to make a 3 question self marking quiz
    • simple VLOOKUP
    • use of labels or named ranges in formula/function (give spreadsheet & formula, set up named areas & modify formula)
    All can be done as a paper exercise if necessary. Give an example, a scenario(s), ask them to write formula/function to fit scenario based on example.
     

Share This Page