Department Vision:

As we move forward into the new Millennium the industrial age is being superseded by the information age. Literacy is no longer defined just as the ability to read and write, but also the ability to access, create, and send information and data. The ICT department aims to provide our pupils with the necessary skills to allow them to engage themselves fully in today’s society.

We aim to enhance and develop our student’s ICT skills encouraging them to become independent learners who are e-confident and capable of researching, processing, storing, analysing, exchanging and presenting information. The department aims to motivate and inspire pupils thus raising standards within the subject.

The department aims to enhance the curriculum offered to pupils allowing for a number of pathways to be available at KS5 with a wide and differing range of courses. The courses we currently offer, and will offer in the future, will allow pupils to create and move along a personalised pathway suited to their own individual aptitude and interest.

In response to recent changes to the curriculum in all key stages, the Computing and Information Technology department at SFX aims to provide pupils with the necessary skills to allow them to engage themselves fully in today’s society.  There is now a greater emphasis on ‘computational thinking’ and independent learning to ensure that our pupils develop their skills to solve problems and to be empowered from the earliest stage in their educational journey to university and beyond.

Curriculum Information

Key Stage 3

Year 7


Unit 1 : Using Computers Safely, Effectively and Responsibly

Learn how to manage files and folders in File Explorer, save files properly with naming conventions, and look at the school computer use policy.

Dangers of Social Networks and how to respond to threats on the internet.  Keeping identity secure online.

Creating secure, memorable passwords, phishing and e-mail scams.

How to respond to and send emails, search for emails, managing contacts and sending attachments.

Knowing that a search engine is and using search engines effectively.  Looking at bias and inaccurate information.


Unit 2 : Office Software Introduction (Word, Powerpoint and Excel)

Powerpoint – About Me.  Introduce PowerPoint.  Learn how to create Master Slide, Hyperlinks and Home Button.

Powerpoint – About Me.  Learn how to change design and use transitions, entry / exit animations.  Discuss consistency.

Powerpoint – About Me.  Complete presentation and submit for assessment.

Word – Mr Stink.  Introduce Word.  Learn how to insert Cover Page, Contents Page and Headings, Header and Footer including Page Numbers.

Word – Mr Stink.  Learn how to change font colour, size and type.  Learn how to change alignment, and use bold, Italic and underline.

Word – Mr Stink.  Finish making changes to Mr Stink.  Create a learning log to submit showing how all changes have been made.

Excel – Gangsta Zoo Spreadsheets

Unit 3 :Creating a Video

Looking at audience, filming techniques and camera angles.  Deciding what makes a good advertisement.

Storyboard and script creation, concept, purpose and audience for advertisement.

Create a TV Advert.  Allocate members of the team according to strengths.

Final Shoot – Import clips to video editing software.  Remove unwanted parts and add text or relevant information where necessary.  Review.

Editing and reviewing Advertisement.

Review own Advertisement and peer assess another group’s work.  Submit advertisement for overall assessment.

Unit 4 : Games Programming in Scratch

Introduction to sequencing and algorithms.  Creating sprites and building basic movement code blocks.

Introduction to variables.  Using comments in a program and annotation.  Introduction to looping and selection.  Adding scoring to game.

Using and understanding repeat loops and procedures (broadcasts).

Using Operators and randomisation.  Introduction of coordinates as screen location.

Using Programming Techniques to learn how to shoot at a target.  How to adjust x and y coordinates to control sprite position.  Jumping.

Add relevant sounds in to the game.

Introduction to testing and test plans.  Testing project and correcting any bugs.

Extension – Using lists as a temporary data store, and introduction to lists as a data structure.


Unit 5 : First Steps in Small Basic

Introduction to Small Basic – simple programs and saving.  Introducing the Turtle.

Iteration and using For loops.

Displaying and entering text in the text window.  Using variables within a program.  Concatenating text.

Using variables to draw polygons.

If, then, else – Introduction to conditions and branching.

Using Random Number generator to create a program.  While loops.


Unit 6 : Graphics

Introduction to Vector Graphics – characteristics and how they are stored.  Looking at colour schemes.

Introduction to Bitmap Graphics – Pixels, bits per pixel and colour depth.  Bitmap vs Vector.

How fonts, colours and images convey meaning.  Explanation of resolution and layers.  Creating a movie poster using layers.

Changing saturation, brightness and contrast.  Use of white space.

Using text.  Importance of consistency.

Review poster.  Peer assess.  Create a sequel poster.



Year 8


Unit 1 : Understanding Computers

What is a Computer?  Distinguish between hardware and software. Input, Output and Storage devices.

ROM and RAM.  Main memory and permanent storage devices.  Three stages of the fetch decode execute cycle.  Hz / MHz / Ghz.

Why data represented in binary. Bit / Byte / Kb / Mb / Gb.  Binary to Decimal, Decimal to Binary.  Introduction to ASCII.

Odd / Even binary numbers.  Adding two eight bit binary numbers together.

Storage devices and optical storage.  How data is stored on CD’s.

History and development of communication.  Future uses of technology and the pace of change.

Unit 2  : Control Systems with Flowol

Creating flow charts for simple problems.

Understanding how systems fail.  Creating flow charts for more complicated problems.

Introduction to sensors.  Using decision symbols in a flow chart and developing a control solution that uses multiple sensors.

Developing control solutions that include subroutines.  Making programs more efficient.

Introduction to actuators and how they are used in control systems.  How variables are used within control systems.

Developing a control system that uses variables.  Understand how a seven segment display works.


Unit 3 : Modelling in Small Basic

Explore / recap of Small Basic Environment.  Create simple programs involving input, output and variables.

Understand the term computer modelling.  Perform mathematical calculations and functions (methods) in a program.  Learn how to generate random numbers.

Comparison operators, Logical operators.  Selection statements and what is meant by the term modelling.  How and why is it used.  Limitations of a model.

Using while and for loops and the differences between them.  Modelling a dice rolling experiment.

Introduction to modular programming.  Using subroutines within models.

Understanding of using subroutines to build up long and complex programs.  Evaluation of reliability of model.  Suggest improvements for model.


Unit 4 : Introduction to Python

Introduction to python.  Use script mode and interactive mode.  Understand the use of comments.  The use of input and print commands.  Understand what a syntax error indicates.

Understand the importance of different data types (string, integer, float).  Use the round function.  Write a program involving input, output and a calculation.

Use selection in a program.  Learn how to use different comparison operators.  Learn how to properly indent code.

Learn how to write algorithms in pseudocode.  Recognise different types of errors (syntax, run-time and logic) and have an idea of how to fix them.

Use a While loop in a program.  Use an IF statement within a While loop.  Use a function to generate a random number.

Compare alternative search algorithms for a given problem.  Use a linear search to find a number.  Write code to execute a binary search.


Unit 5: Sound Manipulation in Audacity

Identify different sound file types.  Record and delete sounds in Audacity.

Understand job roles in sound editing, the use of sound effects and be able to edit a sound file.  Understand stereo effects.

Identify different elements used in a radio advert, explaining how an advert is suitable for audience and purpose.  Plan an advert and produce a storyboard.

Edit a sound envelope, assemble sound files into a radio advert.  Apply effects to enhance the work ensuring it is suitable for audience and purpose.

Be aware of different sound file types be able to choose an appropriate one.  Explain the difference between lossy and lossless.



Year 9

Unit 1: Database Development

Introduction to Databases.  Key terms introduced.  Enter data using a form.  Query data using multiple criteria and different operators.

Design a database table using suitable field types with validation and validation text.  Enter records to the table and text the validation.

Use complex criteria to select records using a parameter query.  Sort data on one or more fields.  Choose data to display and add calculated field.

Create a new form from a table or query making it user friendly using form controls.  Sort and navigate the data using a form.  Enter and modify data.

Create a report based on a query, edit the layout and create a consistent design.

Create a front end for your database.  Test each form, query and report.  Give and receive peer feedback and make amendments.


Unit 2: Computer and Cyber Crime

Identify common types of computer crime, look at examples.  Learn about different types of email scam.  Recognise the signs of a fraudulent emails.

Learn about the Computer Misuse Act.  Look at examples of Computer Misuse.  What is hacking / malware.  How to protect yourself.

Be aware of who could hold personal data.  Discuss the need to store this data.  Awareness of identity theft, know how to minimise risk.

Learn about Copyright Law, look at examples of infringement.  Understand the implication of copyright infringement.  Compare with plagiarism.

Learn about common health and safety problems associated with computer use, and how to avoid them.  Health and safety law, and equipment disposal.


Unit 3: Spreadsheet Modelling

Understand the term computer model and compare different types of model.  Revise spreadsheet basics.  Relative and absolute referencing.

Create a Financial model to predict profit, making the model as realistic as possible.  Look at ways to increase profit.

Use a spreadsheet to model outcomes.  Use MAX, MIN and IF.  Name cells, sort data and use What IF scenarios.

Create a seat booking system using validation techniques and conditional formatting.  Use CountIf function.

Create a macro to reset all seats to unbooked, assign the macro to a button and create a pie chart to show number of seats remaining.


Unit 4: HTML and Website Development

Introduction to the WWW.  Learn what HTML is and what it is used for.  Use basic HTML tags to create a HTML page.  Edit the code and observe.

Learn how CSS is used to set the styles in web pages and websites.  Write CSS code.  Learn what is meant by responsive design.  Learn good website design.

Complete website designs and gather content.  Use a HTML template to create consistent web pages.  Use FLOAT to position elements on a page.

Learn how to create a consistent look and feel throughout a website.  Add well formatted text and images.  Create internal and external links and test them.

Learn how to create a web form, and what happens to the input data once it has been submitted.

Test the website.


Unit 5: Python Next Steps

Learn what the internet and WWW are.  Learn how web addresses are constructed.  Learn about protocols and why they are needed.  Look at packet switching and DNS.

Learn the meaning and significance of bandwidth.  Compare different types of cable and speeds of transmission.  Calculate download times and look at buffering.

Understand the difference between LAN’s and WAN’s with examples.  Identify Bus, Ring and Star.  Know what hardware is required to create a LAN.

Understand what constitutes a client server network, and contrast with peer to peer.  List advantages and disadvantages of each.  Understand the term cloud computing.

Identify types of data that need to be kept secure.  Learn how data is kept secure.  Learn how ciphers can be broken and look at classical encryption techniques.

Unit 6: Python More Steps

Read and understand an existing program.  Recall different data types.  Use INT(), FLOAT() and STR() to convert data types.  Write an IF-ELSE statement.

Use a While loop and a For loop separately to repeat a section of code.  Make a choice about which loop to use and why.

Be able to store and update values in a list, append data and use a for loop to step through the list.  Understand why a list is more efficient than using single variables.

Understand what a procedure is.  Be able to call and define a procedure.  Understand why procedures are useful and be able to use parameters in a procedure.

Define a function that calculates a value and returns it to the calling module.  Call a function which calculates a value.  Assign the returned value to a variable.

Describe the purpose of a given program.  Complete a dry run.  Write a pseudocode algorithm.

Key Stage 4


Year 10

Term 1 Topics & Content: Controlled Assessment: Introduction to Boardset assignment.  Analysis Problem 1 and 2, Design Problem 1, Implementation Problem 1, Testing Problem 1

Term 2 Topics & Content: Controlled Assessment: Completion of Problem 1.  Problem 2 Design, Implementation, Testing

Term 3 Topics & Content: Controlled Assessment: Completion of Problem 2, Evaluation, Report, Evaluation of Other’s Use of IT

Year 11

Term 1 Topics & Content: Controlled Assessment: Project Milestones, Risk, Progress, Managing Storage.  Theory Topics Unit 1 – 10

Term 2 Topics & Content: Controlled Assessment: Project: Collecting, Selecting, Formatting and Developing Information.  Modelling with Data. Documentation.  Theory Topics Unit 11-15

Term 3 Topics & Content: Theory Units 16-22.  Revision.

OCR GCSE Computer Science (J276)

Year 10


Term 1 Topics & Content:

Practical: Programming

Theory Topics: Algorithms, Iteration


Term 2 Topics & Content:

Practical: Programming

Theory Topics: Boolean Logic, Data Types and Structures


Term 3 Topics & Content:

Practical: Programming

Theory Topics: Searching and Sorting Algorithms, Data Input and Output, Problem Solving



Year 11

Term 1 Topics & Content: Programming Project using programming techniques and analysis (controlled assessment).  Theory continues

Term 2 Topics & Content: Programming Project using programming techniques and analysis (controlled assessment). Theory continues

Term 3 Topics & Content: Revision


ECDL Level 2 for Schools (European Computer Driving Licence)

Year 10

Term 1: Word Processing

Term 2: Word Processing, Spreadsheets

Term 3: Spreadsheets

Year 11

Term 1: Presentations

Term 2: Presentations, Improving Productivity

Term 3: Improving Productivity


Key Stage 5


Year  12

  • BTEC Level 3 National Extended Certificate in Information TechnologyTerm 1:Information Technology Systems: Demonstrate knowledge of information technology terms, standards, concepts and processes

    Creating Systems to Manage Information: Database development terminology, concepts and processes

    Using Social Media in Business: Explore the impact of social media on the ways businesses promote their products and services

    Term 2:

    Information Technology Systems: Apply knowledge of information technology terms, standards, concepts and processes

    Creating Systems to Manage Information: Analyse and evaluate information about database problems

    Using Social Media in Business:  Develop a plan to use social media in a business to meet requirements

    Term 3:

    Information Technology Systems: Select and Use information and technologies and procedures to find solutions to problems in context

    Creating Systems to Manage Information: Develop a database solution

    Using Social Media in Business:  Implement the use of social media in a business

Year 13

  • Term 1 Topics: Database systems
  • Term 2 Topics: Information systems
  • Term 3 Topics: Impact of ICT on Business Systems


Edexcel Level 3 BTEC National in Information Technology

Year 12

Term 1, 2 and 3 concurrently:

Topics & Content: Unit 1:  Employability and Communication Skills for IT: The aim of this unit is to ensure that learners understand both the personal attributes valued by employers and the principles of communicating effectively whist developing effective communication skills and addressing their own personal development needs

Topics & Content: Unit 2: Computer Systems: The aim of this unit is to enable learners to understand the components of computer systems and develop the skills needed to recommend appropriate systems for business purposes and set up and maintain computer systems

Topics & Content: Unit 8: E-Commerce: The aim of this unit is to ensure that learners know the technologies involved in e-commerce, understand the impact of e-commerce on organisations and on society, and that they are able to plan e-commerce strategies

Year 13

Term 1, 2 and 3 concurrently:

Topics & Content: Unit 3: Information Systems: The aim of this unit is to ensure learners understand how organisations use information and the surrounding use of information, know about information systems and develop the skills necessary to produce management information.

Topics & Content: Unit 4: Impact of the Use of IT on Business Systems: The aim of this unit is to ensure learners understand the effects developments in IT have on organisations and how organisations respond to these developments, and enable learners to propose IT-enabled improvements to business systems

Topics & Content: Unit 18: Database Design: The aim of this unit is to enable learners to understand the features of relational databases and to develop the skills necessary to design, create, populate and test a relational database incorporating advanced features

AQA Information and Communication Technology A Level (2520)

Year 12

Term 1 Topics & Content: Input, Output, Storage / Analysis, Design, Use of Various Software Packages, Software[DM1] .

Term 2 Topics & Content: Completion of Sample Work , Implementation, Testing, Maintenance, Evaluation, ICT Systems.

Term 3 Topics & Content: Data and Security,  Backup and Recovery, Factors and Consequences of the use of ICT.

Year 13

Term 1 Topics & Content: Completion of INFO 4 coursework

Term 2 Topics & Content: Completion of INFO 4 Coursework Cont., Managing ICT Policy, Strategy and Law

Term 3 Topics & Content: Future Developments, Information Systems, Developing ICT Solutions, Use of ICT in Employment and Large Organisations.


Department Staff:

  • Mrs J. Holmes - Head of Department
  • Miss K. Lindop
  • Mr P. Evans
  • Mrs L. Cavanagh
  • Mr L. Atkinson

Department Courses:

Key Stage 3:

Schemes of work in line with the National Curriculum

Key Stage 4:

GCSE ICT (AQA) & Computing

Key Stage 5:

A Level ICT (AQA) & BTEC ICT (Edexcel) & Computing

Out of Hours Activities:


As per NightOwl Timetable

Revision Sessions:

School Holidays

Lunctime Sessions:


Department Links: