Curriculum - Core ICT

Key Stage 3
 
Year 7
 
Term 1 – ICT in the real world - students will learn how to stay safe when on the internet.
 
Term 2 – Presenting information – students will create a multimedia presentation and video using text, images and sound.
 
Term 3 - Modelling – students will create a simple spreadsheet for a scenario using a number of formulas and functions.
 
Term 4 – Data Handling – students will create and enter, edit and delete information in a database.
 
Term 5 – Selecting, refining and using information – students will find information from the internet and use it in the product they are going to design and advertise. 
 
Term 6 - Control – Students will learn about control and the steps needed to make a number of everyday things work. Students will also be introduced to a games making software, called Scratch.
  
Year 8
 
Term 1 - Wider aspects of ICT – students will learn about the social and economic factors relating to ICT. They will study Health and Safety factors related to using a computer i.e. RSI.
 
Term 2 – Selecting refining and restoring information – students will use video editing software to combine a number of different multimedia elements.
 
Term 3 – Modelling – students will recap knowledge of spreadsheets and design an advanced model.
 
Term 4 – Data handling – students will create, edit, delete records in a database along with designing and running queries to search for popular information.
 
Term 5 – Web design and creation - students will learn how to design and build an interactive web page.
 
Term 6 - Control - students will revisit control and design and develop a game in Scratch using a series of commands.
 
 
Key Stage 4
  
Year 9
 
OCR Nationals Unit 1 – Skills for Business
Unit 1 is a compulsory unit; students will learn how to create a number of different business documents such as spreadsheets, databases, presentations, flyers and many more. This unit uses and builds upon a number of different skills which students will have learnt in previous years at the school.
  
Year 10
 
OCR Nationals Unit 4 – Multimedia Presentation
In this unit we will plan, create and evaluate a multimedia presentation using techniques such as storyboarding. They will use their creativity to design and produce graphics and animations to include in their presentation. They can also plan and edit a film to link in to the PowerPoint.
  
Year 11
 
OCR nationals Unit 21
In this unit students will design and create elements for a website. They will analyse existing navigation bars, buttons and advertising banners and design and plan and make their own for a recycling website. After making their button in Serif Draw Plus, they will use Serif Web Plus to make a template for their website.