TRINITY 2 

Fundamentals Of Data Representation, Computer Systems & Networks 

Within this unit pupils will revisit computer networks including network topologies, layers, protocols and the importance of  

network security.  

Pupils will embed their knowledge of computer systems including computer architecture, memory,  

operating systems and high and low level programming.   

 

MICHAELMAS 1 

Databases & SQL 

In this unit of work pupils will work the topic of relational databases and structured query language.   

Pupil will already have knowledge of programming concepts.  

Pupils will be able to: 

  • Explain the concept of a database and a relational database. 

  • Use SQL functions to retrieve, insert, update and delete data in a databases. 

 

MICHAELMAS 2 

Revision & Further Programming Practice  

During this unit pupils will use key programming techniques to decompose a problem and create a solution or algorithm.  

Pupils will be able to test and debug code to create an efficient and robust solution.   

 

LENT 1 

Cybersecurity & ethical, legal and environmental responsibilities  

Pupils will develop an understanding of the following topics, applying knowledge and understanding of:  

  • Malicious code  

  • Hacking  

  • Malware  

  • Wearable tech  

  • Access rights  

  • Unpatched & outdated software 

  • Passwords  

  • Social engineering  

  • Copyright  

  • Networking  

  • Cyber security  

  • Government privacy infringements  

  • Penetration testing 

 

LENT 2 

Paper 1 and Paper 2 Revision