Computer Science

Key Stage 3 Computer Science Scheme of Work 2019 - 2020:

YEAR 7

  • Logging on to the school network
  • Health and safety
  • Creating and managing files and folders
  • Using Outlook
  • Searching the Internet
  • Staying safe online
  • Programming with Kodu
  • Programming with MS Logo
  • Computer graphics
  • Programming with Scratch
  • Create your own Scratch game
  • Introduction to databases
  • Introduction to spreadsheets
  • Robotics and Artificial Intelligence


Year 8
 

  • Creating and managing files and folders

  • Programming with Flowol

  • Programming with Python

  • Copyright

  • The Computer Misuse Act

  • Data protection Laws

  • eSafety, social media and digital footprints

  • How the Internet works

  • Digital Graphics for Websites

  • HyperText Markup Language

  • Creating websites with Dreamweaver

  • Sound recording and editing with Audacity

Year 9

  • Housekeeping files and folders
  • Hardware and Software
  • Data representation in Binary and Hexadecimal
  • Logic Gates
  • Cryptography
  • Emerging Technologies
  • Social and Ethical Considerations
  • Visual BASIC for Applications Programming
  • Creating a Database
  • Databases Queries
  • The Structured Query Language
  • Careers and ICT
  • Digital Photography
  • Editing Images with Photoshop

 

GCSE OCR Computer Science:

 01 Computer Systems – 80 marks (1 hour 30 minutes. Written paper no calculators allowed 50%)

1.1 Systems architecture

1.2 Memory

1.3 Storage

1.4 Wired and wireless networks

1.5 Network topologies, protocols and layers

1.6 System security

1.7 Systems software

1.8 Ethical, legal, cultural and environmental concerns

 02 Computational Thinking Algorithms and Programming – 80 marks (1 hour 30 minutes. Written paper no calculators allowed 50%)

2.1 Algorithms (not exclusive to this component and can be assessed in either 01 or 02)

2.2 Programming techniques

2.3 Producing robust programs

2.4 Computational logic

2.5 Translators and facilities of languages

2.6 Data representation

Programing project – 20 timetabled hours formally required consolidates learning across specification through practical activity

  • Programming Techniques
  • Analysis
  • Design
  • Development
  • Testing evaluation and conclusions