ICT

ICT

We aim to develop students’ skills in the use of ICT in an ever changing digital world. We want them to be, and feel, confident in the use of ICT and their ability to use of a wide range of software. We hope they will realise how ICT can be used over a wide range of the curriculum.

NW3C8128.JPG

ICT Teaching Facilities

The college has a large number of PCs and laptops. The ICT department has three dedicated rooms each well equipped with PCs and an electronic white board for teaching purposes.

 

Curriculum:ICT

ICT Year 7

Topic Overview
E-safety
  • Personal data & how to protect it
  • Online threats and how to avoid them
Scratch Programming
  • Design & create computer programmes
  • Use of loops, if statements and variables
  • Alter values of variables and use selection to achieve different outcomes
Spreadsheets
  • Design & create spreadsheet models
  • Learn to use formulae and functions
  • Present model solutions graphically

ICT Year 8

Topic Overview
Understanding Computers
  • Input & Output, storage devices
  • CPU and memory
  • Binary: convert denary and binary and reverse, binary addition, binary to hexadecimal
  • Logic gates and truth tables
  • Use Flowal to create and model algorithms
https://www.ocr.org.uk/qualifications/cambridge-nationals/information-technologies-level-1-2-j808

ICT Year 9 Autumn Term

Topic

Overview

L01: Understand the tools and techniques used to initiate and plan solutions
  • Introduction to the phases of the product life cycle
  • inputs and outputs of each phase
  • Initial product considerations
  • Identify & use planning tools to develop project plans
L02: Be able to initiate & plan a solution to meet an identified need
  • Learn to initiate a project by analysing the requirements in a given context
  • How to mitigate risks in the planning process
  • Create & use planning documentation
  • Undertake iterative testing
Skill Building
  • Use spreadsheet and database software to model project solutions

ICT Year 9 Spring Term

Topic Overview
L03: Understand how data & information can be collected, stored and used
  • Data information definitions
  • Methods used to collect/store data & information
  • Storage methods abd appropriateness of use
  • Benefits & drawbacks of data use
L04: Factors to be considered when collecting/storing/processing data & information
  • Types and threats
  • Vulnerabilities exploited in cyber security attacks
  • Impacts and consequences of cyber security attack
  • Current relevant IT: its implications and applications
Skill Building
  • Use spreadsheet and database software to model project solutions

ICT Year 9 Summer Term

Topic Overview
L06: Different methods of processing data and presenting information

Selection & justification of appropriate software tools and techniques to process data to meet defined objectives in a given context

Selection & justification of appropriate software tools and techniques to present information - purpose, suitability, advantages and disadvantages

Skill Building Use spreadsheet and database software to model project solutions

ICT Year 10 Autumn Term

Topic Overview
L01: Tools and Techniques used to initiate and plan solutions
  • Introduction to the phases of the product life cycle
  • inputs and outputs of each phase
  • Initial product considerations
  • Identify & use planning tools to develop project plans
L02: Be able to initiate & plan a solution to meet an identified need
  • Learn to initiate a project by analysing the requirements in a given context
  • How to mitigate risks in the planning process
  • Create & use planning documentation
  • Undertake iterative testing

ICT Year 10 Spring Term

Topic Overview
L03: Understand how data & information can be collected, stored and used
  • Data information definitions
  • Methods used to collect/store data & information
  • Storage methods abd appropriateness of use
  • Benefits & drawbacks of data use
L04: Factors to be considered when collecting/storing/processing data & information
  • Types and threats
  • Vulnerabilities exploited in cyber security attacks
  • Impacts and consequences of cyber security attack
  • Current relevant IT: its implications and applications
Skill Building
  • Use spreadsheet and database software to model project solutions

ICT Year 10 Summer Term

Topic

Overview

L06: Different methods of processing data and presenting information
  • Selection & justification of appropriate software tools and techniques to process data to meet defined objectives in a given context
  • Selection & justification of appropriate software tools and techniques to present information - purpose, suitability, advantages and disadvantages
Skill Building
  • Use spreadsheet and database software to model project solutions and outcomes

GCSE Computer Science

https://www.ocr.org.uk/Images/225975-specification-accredited-gcse-computer-science-j276.pdf

Computer Science Year 9 Autumn Term

Topic Overview
Programming
  • Programming concepts
  • Algorithims & Casting
  • String manipulation
  • Arithmetic operators
  • Sequence and selection
  • Iteration and arrays

Computer Science Year 9 Spring Term

Topic Overview
Wired & Wireless Networks
  • Local Area Networks, network components
  • Wireless networking
  • Client/Server and P2P
  • Protocols and layers
Data Representation
  • Storage units and binary numbers
  • Binary arithmetic, hexadecimal
  • Images and sound

Computer Science Year 9 Summer Term

Topic Overview
Data Representation
  • Compression
System Architecture
  • CPU and memory
  • Operating systems
  • Von Neuman architecture
  • Storage media & capacities
  • RAM and ROM

Computer Science Year 10 Autumn Term

Topic Overview
Algorithims
  • Computational thinking
  • Searching and sorting
  • Flow diagrams & pseudocode
Logic and Languages
  • Logic gates, truth tables, SQL

Computer Science Year 10 Spring Term

Topic Overview
Systems Software
  • Software types
  • Operating systems
  • Back ups and utilities

Ethical, Legal, Cultural and

Environmental Concerns

  • Computer systems in the modern world
  • Legislation and privacy
  • Ethical, cultural and environmental issues

Computer Science Year 10 Summer Term

Topic Overview
Programming
  • Procedures and functions
  • Records and files
Logic & Languages
  • Defensive design
  • Errors and testing
  • Facilities of a IDE

Computer Science Year 11 Autumn Term

Topic Overview
Algorithims
  • Computational thinking
  • Searching and sorting
  • Flow diagrams & pseudocode
Logic and Languages
  • Logic gates, truth tables, SQL

Computer Science Year 11 Spring Term

Topic Overview
Non exam Assessment (coursework)
  • Programming project
  • Revision

Computer Science Year 11 Summer Term

Topic Overview
Revision
  • Revision
Exam
  • Paper 1 May 13th
  • Paper 2 May 16th