Useful Links

Useful Links

GSO Test

Raising the achievement of All

Computing

Subject: Computing

Head of Subject: Mr I McIntosh

Overview

KS3

 

A high-quality computing education equips pupils to use computational thinking and creativity to understand and change the world. Computing has deep links with mathematics, science, and design and technology, and provides insights into both natural and artificial systems. The core of computing is computer science, in which pupils are taught the principles of information and computation, how digital systems work, and how to put this knowledge to use through programming. Building on this knowledge and understanding, pupils are equipped to use information technology to create programs, systems and a range of content. Computing also ensures that pupils become digitally literate – able to use, and express themselves and develop their ideas through, information and communication technology – at a level suitable for the future workplace and as active participants in a digital world.

 

KS4

 

OCR’s GCSE (9–1) in Computer Science will encourage learners to:

 

• understand and apply the fundamental principles and concepts of Computer Science, including abstraction, decomposition, logic, algorithms, and data representation

• analyse problems in computational terms through practical experience of solving such problems, including designing, writing and debugging programs

• think creatively, innovatively, analytically, logically and critically

• understand the components that make up digital systems, and how they communicate with one another and with other systems

• understand the impacts of digital technology to the individual and to wider society

• apply mathematical skills relevant to Computer Science

 

Key Stage 3 Overview

Year 7

 

Autumn 1

Autumn 2

Topic:

Introduction to Computing

  • File management.
  • Social networking.
  • Keeping your data safe.
  • Searching the web.

 

Revisit:

  • Introduction to Computing.
  • File management.
  • Social networking.

Topic:
Investigating Spreadsheets

  • Basic formulae.
  • Formatting spreadsheets.
  • Use a range of functions in a spreadsheet.
  • Sort and filter a Create a variety of graphs in a spreadsheet.
  • Use absolute and relative cell references, model data and create a spreadsheet.

 

Revisit:

  • File management.
  • Social networking.
  • Keeping your data safe.
  • Searching the web.

Spring 1

Spring 2

Topic:

Database management

  • What is a database?
  • A basic database and enter information.
  • Basic query and Data Capture.
  • Reports based on queries.


Revisit:

  • Use a range of functions in a spreadsheet.
  • Sort and filter a spreadsheet and use comparator operators in a formula.
  • Create a variety of graphs in a spreadsheet.
  • Use absolute and relative cell references, model data and create a spreadsheet.

Topic:

Binary

  • Introduction to the binary number system it’s important in computing.
  • Adding binary numbers
  • ASCII Character Codes and Code Breaking.
  • Bitmaps and Cryptic Pictures.

 

Revisit:

  • Basic query and Data Capture.
  • Reports based on queries.

Summer 1

 Summer 2

Topic:

Introduction to Flowcharts and Programming

  • Introduction to Logicator Controlling Outputs.
  • Using Decisions.
  • Introduction to Scratch.
  • Introduction to textural Programming.
  • Variables and IF Statements.

 

Revisit:

  • Binary number system it’s important in computing.
  • Adding binary number.
  • ASCII Character Codes and Code Breaking.

Topic:

Textural Programming

  • Develop basic code with the use of the correct syntax and variables.
  • Use basic knowledge of variables combined with user input.
  • Building functions and to use inputs and outputs.
  • Use of if statements to enable code to ask questions.
  • Program a turtle shape on the screen.

 

Revisit:

  • Introduction to Logicator.
  • Controlling Outputs.
  • Using Decisions.
  • Introduction to Scratch.
  • Introduction to Programming.
  • Variables and IF Statements.

 

Year 8

 

Autumn 1

Autumn 2

Topic:

Staying Safe using Digital technology

  • Email scams.
  • Hacking.
  • Protecting personal data.
  • Copyright.
  • Health and Safety.

 

Revisit:

Develop basic code

  • With the use of the correct syntax and variables.
  • Use basic knowledge of variables. combined with user input.
  • Building functions and to use inputs and outputs.
  • Use of if statements to enable code to ask questions.
  • Program a turtle shape on the screen.

Topic:

A Computer System

  • Elements of a Computer.
  • The CPU.
  • Understanding Binary.
  • Binary Addition.
  • Storage Devices.
  • Convergence and New Technologies.

 

Revisit:

  • Email scams.
  • Hacking.
  • Protecting personal data.
  • Copyright.
  • Health and Safety.

Spring 1

Spring 2

Topic:

Networking Computers

  • The Internet.
  • Connectivity.
  • Topologies.
  • Client-server networks.
  • Encryption.

 

Revisit:

  • Understanding Binary.
  • Binary Addition.
  • Storage Devices.
  • Convergence and New Technologies.

Topic:

Business Documents

  • Creating a Memo.
  • Creating a Letter.
  • Creating a Notice.
  • Creating a Poster.
  • Creating a Digital Poster.

 

Revisit:

  • The Internet.
  • Connectivity.
  • Topologies.
  • Client-server networks.
  • Encryption.

Summer 1

 Summer 2

Topic:

Programming with Python

  • Learn to program.
  • An Introduction to Python.
  • Variables Inputs and Outputs.
  • Input Storing - Variables and Outputs.
  • Data Types and Variables.
  • Sequence.
  • Investigating Selection the If statement Iteration.

 

Revisit:

  • Creating a Notice.
  • Creating a Poster.
  • Creating a Digital Poster.

Topic:

Creating Animations

  • Introduction and Investigating Online.
  • Animations.
  • Designing Animations using Storyboards.
  • Introduction to using Flash.
  • Developing Animation skills.
  • Creating an Animation.
  • Reviewing and Evidencing an Animation.
  • Evaluating an Animation.

 

Revisit:

Programming with Python

  • Learn to program.
  • An Introduction to Python.
  • Variables Inputs and Outputs.
  • Input Storing - Variables and Outputs.
  • Data Types and Variables.
  • Sequence.
  • Investigating Selection the If statement.
  • Iteration.

 

Useful websites/resources

https://www.bbc.com/bitesize/subjects/zvc9q6f

https://www.advanced-ict.info/theory/NC/index.html

Key Stage 4 Overview

Exam Board

OCR

Qualification type

GCSE

Assessment

Computer systems (01), 80 marks 1 hour and 30 minutes Written paper (no calculators allowed) – Paper 1

Computational thinking, algorithms and programming (02) 80 marks 1 hour and 30 minutes Written paper (no calculators allowed) – Paper 2

Programming Project, 20 timetabled hours, formal requirement to consolidates the learning across the specification through practical activity

Year 9

 

 

Autumn 1

Autumn 2

Topic:

1.1 System Architecture

  • What is meant by a computer system and an embedded system?
  • What the CPU do?
  • What the different components are within the CPU?
  • What is meant by the fetch–execute cycle.
  • What can affect the performance of the CPU?
  • System Architecture Purpose of the CPU Von. Neumann Architecture
  • MAR MDR Describe common CPU components and their function:
  • ALU Arithmetic Logic Unit),
  • CU (Control Unit), Cache.

Describe how common characteristics of CPUs affect their performance:

  • Clock speed,
  • Cache size,
  • Number of cores.
  • Explain the purpose and give examples of embedded systems.

 

Revisit:

  • Programming techniques.
  • Use of LMC and Logic problems.
  • System Architecture.

Topic:

1.1 System Architecture.

1.2 1.3 Memory and Storage.

 

Revisit:

1.1 System Architecture.

Spring 1

Spring 2

Topic:

1.4 Wired and Wireless networks - Types of Network Factors that affect network Performance.

  • Wired and Wireless networks
  • Types of Network Client Server and Peer to Peer
  • Hardware need to connect a Client to a Network, LAN.
  • The Internet as a WAN

 

1.5 Network Topology, Protocols and Layers

  • Star and Mesh Network Topologies. Wi-Fi Frequency and channels.
  • Ethernet
  • IP addressing
  • MAC addressing and protocols
  • Layers and Packet Switching.

 

Revisit:

1.2 & 1.3 Memory and Storage.

Topic:

1.6 System Security

  • Forms of Attack.
  • Threats posed to Networks.
  • Identifying and Preventing Vulnerabilities.

 

1.7 System Software

  • The Purpose and function of System Software.
  • The Operating System Utility Software.
  • Open Source and Proprietary Software
  • Legislation.

 

1.8 Ethical Legal Cultural and Environmental concerns

  • Overview
  • Stakeholders and Technology.
  • Environmental impact.
  • Cultural impact.

 

Revisit:
1.4 Wired and Wireless networks.

1.5 Network Topology, Protocols and Layers.

Summer 1

 Summer 2

Topic:

2.1 Computational Thinking

2.2 Programming Techniques

  • Constants.
  • Operators.
  • Variables.
  • Inputs Outputs Assignment

2.3 Algorithms

  • Searching Algorithms.
  • Sorting Algorithms.
  • Pseudocode and Flow Charts.

 

Revisit:

1.6 System Security.

1.7 System Software.

1.8 Ethical Legal Cultural and Environmental concerns.

 Topic:

2.1 Computational Thinking

2.2 Programming Techniques

  • Constants.
  • Operators.
  • Variables.
  • Inputs Outputs Assignment

2.3 Algorithms

  • Searching Algorithms.
  • Sorting Algorithms.
  • Pseudocode and Flow Charts.

 

Revisit:
2.1 Computational Thinking.

Year 10

 

 

 

Autumn 1

Autumn 2

Topic:

2.3 Producing Robust Programs

  • Defensive Design
  • Maintainability and Testing
  • Testing Syntax and Logic errors & selecting test data.
  • Robust Programming techniques.

 

2.4 Computational Logic

  • Binary and Computers Logic.
  • Logic Diagrams and Truth Tables.
  • Combining Boolean Logic to Two Levels.
  • Applying Computer Related Mathematics.

 

2.5 Translators and Facilities of Languages

  • Characteristics and Purpose of different Languages.
  • Common Tools in IDE's.

 

Revisit:
• 2.1 Algorithms.
• 2.2 Programming Techniques.

Topic:

2.6 Data Representation.

  • Units.
  • Numbers.
  • Characters.
  • Data Representation.
  • Images
  • Sound Compression.

 

3.1 Programming techniques.

 

3.2 Analysis.

 

3.3 Design.

 

3.4 Development.

 

3.5 Testing and evaluation and
Conclusions.

 

Revisit:
2.3 - Producing Robust Programs.

Spring 1

Spring 2

Topic:
1.1 Systems Architecture.
1.2 Memory.
1.3 Storage.

Revisit:
2.4 - Computational Logic.
2.5 - Translators and facilities of languages.
2.6 - Data representation.

Topic:
1.4 Wired and wireless networks.
1.5 Network topologies, protocols
and layers.
1.6 System security.
1.7 System software.
1.8 Ethical, legal, cultural and
environmental concerns.

 

Revisit:
1.1 - Systems Architecture
1.2 - Memory
1.3 - Storage

Summer 1

 Summer 2

Topic:

2.1 Algorithms.

2.2 Programming techniques.

 

Programming Project:

  • Opportunity to put theory into Practice students take part in 20 hour Programming Assignment.

 

Revisit:

1.4 - Wired and Wireless Networks. 

1.5 - Network Topologies Protocols and Layers.
1.6 - System Security.
1.7 - Systems Software.

Topic:
2.3 Producing robust programs.
2.4 Computational logic.
2.5 Translators and facilities of
Languages.
2.6 Data representation.

 

Programming Project:

  • Opportunity to put theory into Practice students take part in 20 hour Programming Assignment.

 

Revisit:
2.1 and 2.2 Computational Thinking Algorithms and Programming.


 

Year 11

 

 

 

Autumn 1

Autumn 2

Topic:

  • Systems Architecture.
  • Memory.
  • Storage.
  • Wired and wireless networks.
  • Network topologies, protocols and layers.
  • System security.
  • System software.
  • Ethical, legal, cultural and environmental concerns.
  • Students will review using Learning Grids.

 

Revisit:

  • Computational Logic, Translation and Editors.
  • Data Representation.

Topic:
2.1 Algorithms.
2.2 Programming techniques.
2.3 Producing robust programs.
2.4 Computational logic.
2.5 Translators and facilities of
Languages.
2.6 Data representation.
Students will review using Learning Grids.

 

Revisit:

  • Computer Architecture.
  • Memory and Storage.
  • Network Connectivity.
  • Network Topology Protocols and Layers.

Spring 1

Spring 2

Topic:

  • Review and expansion of Topics.
  • With a focus on the application of knowledge skills to demonstrate understanding.

 

Revisit:

  • Computational Thinking Algorithms and Programming.
  • Data Structures, Types and Searching using SQL
  • Robustness of Coding Design and Testing.

Topic:

  • Examination Technique
  • Review of Pseudocode other challenging topics.

 

Revisit:

1.8 Ethical Legal Cultural and Environmental concerns.

 

Unit 1 Revision

Summer 1

 Summer 2

Exams:

Exams:

 

Please click here to Download a copy of the Curriculum Map

 

Useful websites/resources

https://www.ocr.org.uk/qualifications/gcse/computer-science-j276-from-2016/