ICT And Computer Science

Head of ICT and Computer Science Mr B. Iqbal BSc (Hons) Business Information Systems
Teacher of ICT Mr S. Rizvi – PGCE – Computer Science and IT
Teacher of ICT Mr N. Cohen BSc (Hons) Chemistry and Chemical Technology

Per Term Topic Information

Year 7

Autumn 1 Autumn 2 Spring 1 Spring 2 Summer 1 Summer 2
E Safety Healthy Relationships Computers –

The Basics

Database My Finance Scratch & Python

Introduction

The unit of work allows students to develop skills and techniques in video design and editing whilst learning of online dangers and how to counter these issues if and when they arise. This unit of work develops the students’ presentational skills and teaches them how to use a number of techniques and skills to improve their presentation of their work whilst developing confidence. The unit of work teaches students the main components of a computer system and allows them to develop a clearer understanding of computers and their origin. The unit of work teaches students the main concepts of databases and its use. Students are instructed to search and store records and look at how a basic database is constructed. The unit of work introduces students to spreadsheets and the methods used to add simple formula and create graphs and charts to manage basic finances.  This unit of work creates a transition between primary school’s development of sequence control. Students are shown basic python code constructs and instructed to add and develop basic lines of code.
Evidence
  • Photostory Peer Evaluation
  • Photostory Self Evaluation
  • Project Assessment Grid
  • Evaluation sheet
  • Healthy Relationships Presentation/Assessment
Computer development assessment
  • Database questions
  • Year 7 Database assessment grid
  • Assessment
  • Year 7 Spreadsheet
Scratch & Python Assessment questions and fill in the blanks template

Year 8

Autumn 1 Autumn 2 Spring 1 Spring 2 Summer 1 Summer 2
Computer Crime and Cyber Security Understanding Computers Database Basic Python My Finance (Extended) Web Design
The unit of work is developed to allow students to understand the dangers of using computers to store and transmit data electronically. Allowing students to understand how to measure, control and manage electronic data. This unit of work focuses on the main elements of a computer system. Introducing the concepts of binary, storage and the convergence of new technologies. Students are instructed and taught to demonstrate the methods required to create a fully functional database using all of the following concepts; field names, data types, field sizes, validation rules and validation text. During this unit of work students will be taught to include While and For loops to create functional codes. Students will be able to develop codes that will carry out simple functional tasks and showcase evidence of using key techniques used in coding. Students will embark on a spreadsheet project allowing them to explore techniques and skills that will allow them to manage and record financial data for a given purpose. This unit of work will introduce students to HTML coding and allow them to explore web content, whilst developing a basic web-site using hyperlinks and page properties.
 Evidence
Computer Crime Final Assessment Test UCom Assessment Test Database Assessment Evidence Guess The Number Game – Python Modelling & Presenting numeric data Publishing on the web assessment

Year 9

Autumn 1 Autumn 2 Spring 1 Spring 2 Summer 1 Summer 2
Lake Garda Publications Spreadsheet Project Python Coding Networks HTML Code Flash Animation
This project permits students to develop a key concept of house styles, whilst creating various publications for a given scenario. This project explores higher level spreadsheet skills to allow students to develop a key understanding of advanced formula and functions to develop invoices and lookup concepts. This unit of work allows students to embark on 2 small coding projects that allow them to independently create and restore lines of code for a given outcome. This unit of work introduces students to the key components that establish a network. Students will be taught the basis of a client server, connection types and network topologies. During this unit of work students will be taught to write HTML code and create CSS files and templates. Students will be fully immersed in professional industry led web development strategies and techniques. During this unit of work students will to develop frame by frame animation and add motion tweenings to animations, whilst developing effective planning and publication skills.
Evidence
Evaluations and mark sheet Developing a Business Solution Assessment Python Next Steps Assessment Portfolio Networks Assessment Test HTML Mark Sheet Flash Assessment Portfolio

Year 10

  Autumn 1 Autumn 2 Spring 1 Spring 2 Summer 1 Summer 2
 
OCR J461 GCSE ICT Controlled Assessment 1
Investigate and Planning Designs Solution Development Testing Present your Findings Refine Controlled Assessment
Theory
ICT Systems

Assessment

Exchanging Information

Assessment

2.1.3 Storage

Assessment

2.1.4 Manipulating Data

Assessment

2.1.5 Keeping Data Safe & Secure Legal, Social, Ethical & Environmental Issues
 
BCS Level 2 ECDL Certificate in IT Application Skills Word Processing Presentation
    Online Test     Online Test
 
AQA 4512 Computer Science Introduction Functions Controlled Assessment 1
Python Procedures Controlled Assessment 1 -Scenario Intro

Design of The Solution

Pseudocode

Flowcharts

Development of The Code Development of The Code

Code Evidence

Code Evidence

Test

Evaluate

Theory
Constants, Variables and Data Types Structures Program Flow Control Procedures And Functions Scope Of Variables, Constants, Functions And Procedures Error Handling & Handling External Data

Year 11

 

  Autumn 1 Autumn 2 Spring 1 Spring 2 Summer 1 Summer 2
 OCR J461 GCSE ICT Controlled Assessment 2 Refine Controlled Assessments for Moderation
Investigate, Planning and Designs Development of Elements Solution Development Testing Evaluation
Theory
Using ICT Systems Disabilities Monitoring, Measurement & Control ICT & Modern Living ICT in Context & Networks Legal, Social, Ethical & Environmental Issues
Past Papers Exams
 
BCS Level 2 ECDL Certificate in IT Application Skills Spreadsheet Improving Productivity Outstanding Online Test
    Online Test   Online Test
 
AQA 4512 Computer Science Controlled Assessment 2 Refine Controlled Assessments for Moderation
Scenario intro

Design of the solution

Pseudocode

Flowcharts

Development of the code Development of the code (cont.)

Code Evidence

Code Evidence (cont.)

Test & Evaluate

Theory
Computer structure &  Database concepts Algorithms &  Use of external code sources Data representation &  The use of computer technology in society Software development life cycle Application testing &  Networking Exam

Curriculum Information

 

Year 7

No. of lessons per fortnight Frequency and length of homework Additional learning opportunities e.g. clubs, speakers, visits, residential … Additional guidance for parents e.g.  exam board info, websites to support revision, books to read, useful places to visit …
2 Twice every Half Term

  • Cyberbullying Poster
  • Internet Safety methods
  • ICT keywords homework
  • Input-Output activity
  • Agony Aunt software
  • Lucky dip questions
  • Database-diff questions
  • Databases Using Microsoft Access
  • Spreadsheet Keywords
  • Excel checklist
  • Programming Club
  • Kodu Game maker
  • 3D Printing
  • Lunch time homework club
KS 3 ICT BBC Bite Size

http://www.bbc.co.uk/education/subjects

Year 8

No. of lessons per fortnight Frequency and length of homework Additional learning opportunities e.g. clubs, speakers, visits, residential … Additional guidance for parents e.g.  exam board info, websites to support revision, books to read, useful places to visit …
2 Twice every Half Term

  • Computer Misuse Act
  • Health & Safety
  • Input & Output devices
  • Binary Addition
  • Database questions
  • Database Vocabulary Sheet
  • Homework Using a Spreadsheet
  • Know your Data Types task sheet
  • Web Page Designs
  • Programming Club
  • Kodu Game maker
  • 3D Printing
  • Lunch time homework club
KS 3 ICT BBC Bite Size

http://www.bbc.co.uk/education/subjects

 

Year 9

No. of lessons per fortnight Frequency and length of homework Additional learning opportunities e.g. clubs, speakers, visits, residential … Additional guidance for parents e.g.  exam board info, websites to support revision, books to read, useful places to visit …
2 Twice every Half Term

  • Planning document
  • Research Document
  • Handling data using spreadsheets
  • Domain names
  • IP Addresses
  • What is HTML Code
  • Web Page Designs
  • Where is Flash Animation used
  • Programming Club
  • Kodu Game maker
  • 3D Printing
  • Lunch time homework club
KS 3 ICT BBC Bite Size

http://www.bbc.co.uk/education/subjects

Year 10

  No. of lessons per fortnight Frequency and length of homework Additional learning opportunities e.g. clubs, speakers, visits, residential … Department support e.g. intervention classes, revision classes … Additional guidance for parents e.g.  exam board info, websites to support revision, books to read, useful places to visit …
GCSE 5 Twice every Half Term

Theory Tasks

Lunch time homework club Support Classes

Lunch Time

(12:30 to 1:15)

After School

Mon-Thurs

(3:30 to 4:15)

GCSE ICT BBC Bite Size

http://www.bbc.co.uk/education/subjects/zqmtsbk

ECDL 2    
Computer Science 5 Twice every Half Term

Theory Tasks

Computer Science BBC Bite Size

http://www.bbc.co.uk/education/subjects/z34k7ty

Year 11

No. of lessons per fortnight Frequency and length of homework Additional learning opportunities e.g. clubs, speakers, visits, residential … Department support e.g. intervention classes, revision classes … Additional guidance for parents e.g.  exam board info, websites to support revision, books to read, useful places to visit …
GCSE 5 Twice every Half Term

Theory Tasks

Lunch time homework club Support Classes

Lunch Time

(12:30 to 1:15)

After School

Mon-Thurs

(3:30 to 4:15)

GCSE ICT BBC Bite Size

http://www.bbc.co.uk/education/subjects/zqmtsbk

ECDL 2    
Computer Science 5 Twice every Half Term

Theory Tasks

Computer Science BBC Bite Size

http://www.bbc.co.uk/education/subjects/z34k7ty