Computer science

Computer Science

Back

Key Stage Three

Contact: Mr B Pritchard (Principal Teacher)

Term Year 7 Year 8 Year 9

Term One: Autumn Term

Using Computers safely, effectively and responsibly.

Control systems with Flowol

Introduction to Python

Term Two: Christmas Term

Spreadsheet modelling.

Games programming in scratch

Computational thinking and logic

Term Three: Winter Term

First steps in small Basic.

Network hardware and protocols

HTML and website development

Term Four: Easter Term

Computer crime and cyber security.

Database development

AI and machine learning

Term Five: Spring Term

Introduction to coding through Kodu

Understanding Computers

Python next steps

Term Six: Summer Term

Programming on the BBC Micro Bit

Graphical Manipulation and representation

Practical skills in SQL

 

Key Stage Four

Contact : Mr B Pritchard (Principal Teacher)

Term

Year 10

Year 11

Autumn Term

Boolean logic

Memory and storage

Algorithms
Practice Exam Questions

Christmas Term

Systems architecture

Computer networks, connections and protocols

Programing Fundamentals
Producing Robust Programs

Winter Term

Wired and wireless networks

Network topologies, protocols and layers

Boolean Logic
Practice Exam Questions

Easter Term

System software

Operating software

Utility software

Programming Languages and Integrated Development Environments

Spring Term

Ethical, legal, cultural and environmental issues

Data representation

Mock Papers and Revision
Practice Exam Questions
Ethical, Legal, Cultural and Environmental

Summer Term

Mock papers and revision

Practice programming project

 

 

Key Stage Five

Contact: Mr B Pritchard (Principal Teacher)

Term

Year 12

Year 13

Autumn Term

Unit 1: Information technology systems

A1: Functions and use of digital devices, and the notation used to represent the design of IT systems

A2: Peripheral devices and media

A3: Computer software in an IT system

A4: Choosing IT systems

A5: Emerging technologies

 

Christmas Term

Unit 1: Information technology systems

C1: Online systemsC2: Online communities

D1: Threats to data, information, and systems

D2: Protecting data

 

Winter Term

Unit 1: Information technology systems

E1: Online services

E2: Using and manipulating data

F1: Moral and ethical issues

F2: Legal issues

 

Easter Term

Unit 4: Relational database development

A1: Relational database management systems

A2: Manipulating data structures and data in relational databases

A3: Normalisation

A4: Planning a relational database solution in response to a client brief

 

Spring Term

Unit 4: Relational database development

B1: Relational database design techniques and processes

B2: Design documentation

B3: Reviewing and refining designs

 

Summer Term

Unit 4: Relational database development

C1: Producing a database solution

C2: Testing the database solution

C3: Reviewing the database solution

C4: Optimising the database solution