Curriculum Intent Summary

Delivering the core knowledge of Computer Science, giving students a full experience of industry practice, enabling them to be successful at KS3, KS4 and beyond. We will develop students’ practical and creative skills ensuring they become well-rounded computer scientists whilst discovering their talents as programmers. 

 

Year 

Group  

 Term 1  Term 1 + 2  Term 3 + Term 4  Term 5 + Term 6 
7  E-Safety 

 

 

 Interactive Multimedia 

 

 Problem Solving and Maths 

 

 

 Python Programming 
  • Understanding how cyberbullying can occur, how it can affect people and what to do if being cyberbullied. 
  • What personal data is and how to keep it safe. 
  • Identify threats to computer systems and measures that can be taken to keep computer systems safe. 

 
  • Understand what makes a good interactive multimedia product. 
  • Design an interactive multimedia product for a target audience and client brief. 
  • Develop an interactive multimedia product using the features of PowerPoint. 
  • Review an interactive multimedia product that you have created. 

 

 

 

 
  • Convert binary and hexadecimal numbers into denary. 
  • Complete truth tables using logic gates and circuits. 
  • Identify the purpose of different hardware and software. 
  • Introduction to Flowol a program that allows users to solve problems by creating flowcharts. 
  • Identify and understand how to use a range of flowchart symbols including the decision and sub routine symbols. 

 
  • Introduction in Python Programming such as data types and inputting data. 
  • Learn programming concepts such as If statements and Loops. 
  • Solve problems by creating simple python programs that combine a range of programming concepts. 
  • Learn how to use inbuilt libraries such as random number generation and Python Turtle. 

 
8  Web Development  Problem Solving and Maths  Python Programming 

 
  • Understand what makes a good website. 
  • Identify the features of a website such as a navigation bar, search bar and advertising banners. 
  • Design a multipage website for a target audience and client brief. 
  • Develop a multipage website using the features of Dreamweaver, such as CSS and templates. 
  • Use other programs such as Photoshop and Illustrator to edit images or create graphics. 
  • Review a website that you have created. 

 

 

 

 

 

 
  • Builds on skills learnt in Year 7 with binary addition and binary shifting. 
  • Solve logic problems by completing truth tables and drawing complex logic circuits. 
  • Learn how images, sound and text are stored digitally and be able to calculate file sizes. 
  • Learn how to perform a bubble and merge sort algorithms. 
  • Learn how to perform a linear and binary search algorithms. 
  • Develop algorithm skills through the use of more complex flowcharts to solve problems and basic pseudocode. 
  • Understand how algorithms work by completing trace tables. 

 

 

 
  • Build on skills learnt in Y7 by creating programs to solve more complex problems. 
  • Learn how to add, edit and delete data in lists. 
  • Develop a structured approach to programming by using functions and parameters to create efficient programs. 
  • Learn how to store data in external files. 

 

 
9  Animation  Spreadsheets  Databases  Photoshop  Scratch 

 
  • Review animations to understand what makes a good animation. 
  • Design a multipage website for a target audience and client brief, through the use of storyboarding. 
  • Develop an animation using the features of animate such as tweening, layers and drawing tools. 
  • Use other programs such as Photoshop and Illustrator to edit images or create graphics to be used in your animation 
  • Review an animation that you have created. 

 

 
  • Learn how to use basic formulas and cell referencing. 
  • Learn to use more complex functions such as If and CountIf. 
  • Analyse data in a spreadsheet to create a range of graphs and charts such as a line graph, column chart and pie chart. 
  • Use a range of features in excel such as autofill, drop down menus and macros to create a functional spreadsheet.  
  • Know that data in databases is structured in tables and records. 
  • Be able to select specific data by creating queries and displaying these in reports. 
  • Develop a user interface through the use of forms. 
  • Use data validation rules to make sure data is entered correctly. 
  • Understand the concept of a relational database and identify the relationships between tables. 
  • Learn how to use a range of features in Photoshop. 
  • Learn how to use removal tools to edit parts of images. 
  • Use a range of selection tools to combine images. 
  • Add additional layers to edit the colour balance, saturation and hue of images. 
  • Apply different filters and effects to images.   
  • Learn how to use a range of features in Scratch to create your own game. 
  • Learn a variety of ways to control sprites. 
  • Use variables to develop a scoring system.  
  • Use broadcasts to allow sprites interact with each other. 
  • Test your game to make sure it works as intended. 
  • Review the game that you made.