| 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 T. Jones – PGCE Secondary Education |
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
|
- 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 |
