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.
Key Stage 3
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.
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.
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
AQA GCSE ICT (4520)
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
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)
Term 1 Topics & Content:
Theory Topics: Algorithms, Iteration
Term 2 Topics & Content:
Theory Topics: Boolean Logic, Data Types and Structures
Term 3 Topics & Content:
Theory Topics: Searching and Sorting Algorithms, Data Input and Output, Problem Solving
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)
Term 1: Word Processing
Term 2: Word Processing, Spreadsheets
Term 3: Spreadsheets
Term 1: Presentations
Term 2: Presentations, Improving Productivity
Term 3: Improving Productivity
Key Stage 5
- 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
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
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
- 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
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
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)
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.
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.
- Mrs J. Holmes - Head of Department
- Miss K. Lindop
- Mr P. Evans
- Mrs L. Cavanagh
- Mr L. Atkinson
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