RT @Barnwell6thForm: Applications Open: Student Opportunity ...
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
|
Assignment C1 Task A – the user interface
|
C3 Impact of modern technologies; technologies to manage teams, impact of |
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 |
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 |
|
|