ICT for Key Stage 3: Year 8

Themes:

Lessons

Lesson Topic/Lesson Resources
1 Spreadsheets Inpics
2 Spreadsheets VLOOKUP  IF
3 Spreadsheets Projects in Fronter
4 Spreadsheets  
5 Spreadsheets  
6 Spreadsheets  
7 Database Inpics
8 Database  
9 Database  
10 Database Catalogue Merge  Top Trumps
11 Database Top Trumps
12 eot Puzzle Games   Logic Games   HoodaMath   Tantrix   Maths is Fun
13 Binary (spreadsheet) Modular arithmetic: Tables for bases 12 and 20, 16, 14, 20 Binary  Modular Arithmetic Binary numbers in 60 seconds Binary Add Multiply
14 Binary (spreadsheet) Binary & Hexadecimal  
15 Hexadecimal (spreadsheet) Binary & Hexadecimal  
16 Hexadecimal (spreadsheet) Binary & Hexadecimal  
17 SmallBasic or Scratch Small Basic 1 Small Basic 2
18 SmallBasic or Scratch Scratch Basics  Pong   Scratch Broadcast Maze Game Maze Movement
19 SmallBasic or Scratch Samuel Morse  Morse Code Class 1941   Army Morse Code
20 SmallBasic or Scratch Louis Braille Story   Louis Braille   Visual Impairment
21 SmallBasic or Scratch BBC Drum History  Drumbeats  Twitter  Talking Drums  
22 SmallBasic or Scratch Master of Talking Drum  Bobo Ceremony  Oldest footage
23 SmallBasic or Scratch ASCII in HTML
24 SmallBasic or Scratch Password Crackers   Strong Passwords   Rainbow Tables  
25 Cryptography: Caesar shift Overview of Cryptography
26 Cryptography: Subsitution How Does Encryption Work?
27 Cryptography: Vignère Codebreakers
28 Cryptography: Public key Need for Cyber-Security
  Computer Safety Network Security 1.1   Firewall  Firewall  Computer Security  Firewall  
  Computer Safety Norton Anti-Cybercrime video  Identity Theft Phishing  Google Privacy  Avoid Phishing 
    Ayan Bisi Adeleke 
    CSUnplugged