Digital Technology


Digital Technology

At the start of Yr 7 students are introduced to the Music Festival Project; this is the running theme through all the topics. For example, in Spreadsheet Modelling the students are creating a spreadsheet about the finances of the Festival; in Databases the students are creating and interrogating a database about the customers to the Festival.

 

KS4. We study OCR Nationals in Information Technologies (J808) https://ocr.org.uk/qualifications/cambridge-nationals/information-technologies-level-1-2-j808/

 

 

Term 1

Term 2

Term 3

Term 4

Term 5

Term 6

Yr 9

Spreadsheets

  • Simple Formulae
  • Graphs / Charts
  • Conditional Formatting
  • Simple Functions
  • Validation
  • Macros

Databases

  • Tables
  • Queries
  • Reports
  • Forms
  • Relational Databases
  • Importing data

 

Project Planning

  • Project Life Cycle
  • Aims & Objectives
  • Planning Documentation
  • SWOT analysis
  • Test Plans

 

Mitigating Risks

  • Laws
  • GDPR
  • Security
  • Social Engineering

 

Practise Task: Snowboarders

  • Project Life Cycle
  • Create spreadsheet
  • Evaluate project

 

Controlled Assessment – Planning & Initiation

Yr 10

Controlled Assessment – Execution

Controlled Assessment – Evaluation

Security

  • Malware
  • Hacking
  • Cyber Security
  • Validity & Bias

Collecting Data

  • Big Data
  • Methods of Collecting Data
  • Methods of Storing Data

 

Exam Preparation

Controlled Assessment – Planning & Initiation

Yr 11

Controlled Assessment – Execution

Controlled Assessment – Evaluation

 

 

Exam Preparation