ICT Computing - Barnwell School

Curriculum Map

In the IT and Computer Science faculty we are passionate about technology. Students learn to decompose and model real life situations and as a result are able to design, build and create IT solutions to solve problems.

At KS3 students study IT, computer science and digital literacy to give them a solid base for future life and study skills.

At KS4 our students study the design and development of software used to solve problems in a variety of business, scientific and social contexts. Because computers solve problems to serve people, there is a significant human side to IT as well.

The most important aspect of computer science is developing knowledge and understanding of algorithms and computational thinking skills to solve problems as well as understanding how technology can be used to proactively help current issues that impact on modern society.

What is the difference between Information Technology and Computer Science? IT focuses on data handling, spreadsheets and databases and computer science is focused on programming and algorithms. Both IT and computer science include hardware, software, cybersecurity and legislation.

KS3 Subject:	Y7 Content	Y7 Key Assessment	Y8 Content	Y8 Key Assessment	Y9 IT Content	Y9 Key IT Assessment	Y9 CS Content	Y9 Key CS Assessment
Autumn 1	Introduction to network and esafety	E safety topic test	Fake news using Desktop publishing	DTP skills task	Desktop Top Publishing skills to create a well formatted document	DTP skills	Topic 2 Programming	Programming Tasks Topic Tests
Autumn 2	micro:bit	Programming test	Spreadsheets	Spreadsheet test	Spreadsheet skills – formulae, formatting and functions	Independent Spreadsheet skills task	Topic 2 Programming	Programming Tasks Topic Tests
Spring 1	Spreadsheets	Skills test	Python 2	Programming test	Designing and creating a game using a variety of formatting features and functions in a spreadsheet	Independent task to create a multi sheet game which checks if correct answer has been given	Topic 2 Programming	Programming Tasks Topic Tests
Spring 2	Spreadsheets	Spreadsheet creation test	Inside a PC including binary	Components, networking and binary test	Cyber security, viruses, threats, how to protect systems, data protection legislation	Test of concepts	Topic 2 Programming	Programming Tasks Topic Tests
Summer 1	Python 1	Programming test	Relational databases	Database concepts test	Project management and spreadsheets creating pivot tables and charts	Create a dashboard of appropriate information using spreadsheet software	Topic 1 Problem solving	NEA Styled Practice Tasks
Summer 2	Databases	Database skills test	Cybersecurity	Cybersecurity test	Interface design principles	Independently create a user interface including design principles learnt	Topic 1 Problem solving	NEA Styled Practice Tasks

KS4 Course: Computing Science	Y10 Content	Y10 Key Assessment	Y11 Content	Y11 Key Assessment
Autumn 1	Topic 2 Programming	Programming Tasks Topic Tests	NEA
Autumn 2	Topic 2 Programming	Programming Tasks Topic Tests	NEA	Mock Paper 2 – Computational Thinking
Spring 1	Topic 2 Programming Topic 1 Problem Solving	End of Topic Assessments NEA Styled Practice Tasks	Revision Topics 3-6	Exam papers / questions
Spring 2	Topic 3 Data Representation	End of Topic Assessments	Combined Revision Topics 1-6	Exam papers / questions Mock Paper 1 – Principle of Computer Science
Summer 1	Topic 4 Computers Topic 5 Networks & Internet	End of Topic Assessments	External exams – early May.
Summer 2	Topic 6 Big Picture	Mock Combined Paper 1 (Principles of Computer Science) and Paper 2 (Computational Thinking)

KS4 KS4 Course: BTEC Tech Award in Digital Information Technology	Y10 Content	Y10 Key Assessment	Y11 Content	Y11 Key Assessment
Autumn 1	Analysis of a user interface: audience needs, design principles, designing an efficient UI	Assignment C1 Task A – the user interface	C3 Impact of modern technologies; technologies to manage teams, impact of technologies on organisations and individuals	Exam style questions on Impact of modern technologies
Autumn 2	Project planning techniques, create project plan, design techniques for User interface	Assignment C1 task B – use project planning techniques to plan and design a user interface	C3 Cyber security: Threats to data, internal and external, why systems are attacked, impacts of security breach, preventions of threats, disaster recovery, actions after an attack	Exam style questions on Cyber security & Threats to data
Spring 1	Create, refine and review a user interface student has created	Assignment C1 Task C Develop and review a user interface	C3 Wider implications of digital systems: responsible use, legal and ethical considerations	Exam style questions on responsible use, legal and ethical
Spring 2	Characteristics of data, representing information, ensuring data is suitable for processing, data collection, quality of information and its impact on decision making, big data, threats to individual’s data	Assignment C2 Task A – Investigate the role and impact of using data on individuals and organisations	C3 planning digital systems, forms of notation. Revision	Exam style questions on notation Past papers
Summer 1	Data processing skills using spreadsheet software, create a dashboard including a wide variety of functions and advanced features	C2 Assignment Task B – Create a dashboard using data manipulation tools	Revision	Exam
Summer 2	Draw conclusions from data, understand how presentation affects data, make recommendations	C2 task C – Draw conclusions and review data presentation methods

KS5 Course: BTEC Extended Certificate in IT	Y12 Content	Y12 Key Assessment	Y13 Content	Y13 Key Assessment
Autumn 1	Unit 1 A - Digital Devices Unit 1 B -Transmitting Data Unit 3 – A investigating social media	End of Learning Aim Tests Written report – section A	Unit 6 Part B – Design of Website and Programming Skills Unit 6 Part C – Website Development Unit 2 – creating systems to manage information (Databases)	Unit 6 – Part A Past exam papers
Autumn 2	Unit 1 C – Operating Online Unit 1 D – Protecting Data Unit 3 – A investigating social media	End of Learning Aim Tests Written report – section A	Unit 6 Part B & C Assignment Unit 2 – creating systems to manage information (Databases)	Unit 6 – Part B & C Past exam papers
Spring 1	Unit 1 E – Impacts Unit 1 F – Issues Unit 3 B – planning social media for business	Mock Paper End of Learning Aim Test Written report and plan – Unit 3 B	Unit 6 Part B & C Assignment Unit 2 – creating systems to manage information (Databases)	Unit 6 – Part B & C Past exam papers
Spring 2	Unit 3 B_ C– planning and creating social media for business Revision A - F	Unit 3 B_ C report Exam papers / questions	Unit 6 Part B & C Assignment Unit 2 – creating systems to manage information (Databases)	Unit 6 – Part B & C Exam – creating a database to meet business objectives.
Summer 1	Revision A – F Unit 3 B_ C– planning and creating social media for business	Mock Paper Exam papers / questions Unit 3 B_ C report
Summer 2	Revision A – F Unit 6 – Part A Web Site Design Principles Assignment Unit 2 – creating systems to manage information (Databases)	External exam – Unit 1 Skills test and SAM papers