Dates for your Diary

IT Computing

Intent

Computer science and IT at Barnwell school represents a vision in which all students engage in the concept and practices of Information Technology.

We at Barnwell school envision a future in which students:· critically engage in discussion on computer science and IT topics · develop as learners, users, and creators of computer science knowledge · better understand the role of computer science and IT in the world around us · analyse, design, implement, test and evaluate solutions to problems that help shape our society and country,

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.

With a constantly evolving curriculum, we respond to the needs of learners and their interests by enhancing the learning experience and raising awareness from the local area to national and global arenas. Thus, we will develop outward looking pupils who are able to engage in learning about themselves, become increasingly independent and have an understanding of the wider world and its complex cultures.

Learning Journey

Click on the image to download.

Curriculum Map

KS3 Subject:	Y7 Content	Y7 Key Assessment	Y8 Content	Y8 Key Assessment	Y9 IT Content	Y9 Key IT Assessment
Autumn 1	Logon Systems E-safety & Cyberbullying File Management	E-safety and File Management End of Unit Test	E-safety & Cyberbullying File Management Searching Internet	Internet & File Management Test	File Management Decomposition and Abstraction Sort, Search Algorithms	Computation and Algorithm
Autumn 2	Programming - Scratch	Scratch Programming End of Unit Test	Python Programming -Turtle	Python Turtle End of Unit (EOU) Test	Programming: Python 1 Trith tables	Python and Truth table
Spring 1	Spreadsheet Part 1	Spreadsheet Part 2 End of Unit Test	Spreadsheet Part2 Intro to Database	Spreadsheet EOU Test	Data Representation	Data representation
Spring 2	Programming - Micro Bit	Micro Bit End of Unit Test	Input, Output and Storage Devices Introduction to Flowchart	Input and Output EOU Test	Programming: Python 2 Hardware and Software	Hardware and Software
Summer 1	Programming-Python1	Python Programming End of Unit Test	Binary and Data Representation	Data Representation EOU Test	Programming: python 3 Programming languages	Programming Languages
Summer 2	Webpage - HTML	Test on HTML End of Unit Test	Cybersecurity	Cybersecurity EOU Test	Data Storage & Compression	Data Storage & Compression

KS4 Course:	Y10 Content	Y10 Key Assessment	Y11 Content	Y11 Key Assessment
Autumn 1	1.1 Decomposition and Abstraction 1.2 Truth Tables 1.2.1 Flow Chart	End of Unit Test 1 - Compute	4.2 Network security Programming: Python 1	End of Unit Test 1- Compute
Autumn 2	2.1 Binary 1.2.2 Write Algorithm	End of Unit Test 2 - Binary	5.1 Environmental Programming: Python 2	End of Unit Test 1- Compute
Spring 1	2.2 Data Representation 1.2.3 Understand Algorithm	End of Unit Test3 – Data Rep	5.2 Ethical and Legal Programming: Python 3 5.5 Exam Revision	Mock Exam
Spring 2	2.3 Data Storage and Compression 1.2.4 Understand Trace Table	End of Unit Test4 – Trace Table	5.3 Cybersecurity 5.5 Exam Revision Programming: Python 4	End of Unit Test1-compute
Summer 1	3.1 Hardware 3.2 Software 1.2.5 understand types of errors	End of Unit Test4 - Errors and Hardware	5.6 Exam Revision GCSE Computer Science Exams
Summer 2	3.3 Programming languages 4.1 Networks 1.2.6 Standard Algorithms (bubble sort, merge sort, linear search, binary search)	End of Year 10 Mock Exam	GCSE Computer Science Exams

KS4 Course: BTEC Tech Award in Digital Information Technology	Y9 Content	Year 9 Assessment	Y10 Content	Y10 Key Assessment	Y11 Content	Y11 Key Assessment
Autumn 1	Topic 1: Mind’s Eye: Desk Top publishing skills to create a well formatted document spreadsheet skills- Create a Game	End of unit assessment	C3 Learning aim C & D	Assignment C1 Task A – the user interface End of each topic test – exam style questions	C2 preparation -Draw conclusions from data, understand how presentation affects data, make recommendation	Mock Exam coursework task
Autumn 2	Design/create a multi-media advent calendar. Project Management and interface design	Independent task to create interface and evidence of IT project management	Preparation for C1 coursework - Analysis of a user interface: audience needs, design principles, designing an efficient UI	Mock Coursework Task	C2 Coursework Assessment task	C2 coursework sent to exam board
Spring 1	Cyber security, viruses, threats, how to protect systems, data protection legislation	Test of Concepts	Preparation for C1 coursework Project planning techniques, create project plan, design techniques for User interface	Assignment C1 Task C Develop and review a user interface	C3 learning aim A and B C3 Wider implications of digital systems: responsible use, legal and ethical considerations	Exam style questions on responsible use, legal and ethical
Spring 2	Data science	Test of Concepts	C1 Coursework Task	Assessed and sample sent to exam board	C3 Complete Learning Aim B. Exam Revision	End of Topic test Exam style questions on notation Past papers
Summer 1	Spreadsheet- creating a Quiz Functions including MA, MIN, AVG and Pivot table	Create a dashboard & pivot chart	C2 preparation -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	C2 Assignment Task B – Create a dashboard using data manipulation tools Mock coursework task	Exam Revision	C3 Exam
Summer 2	User Interface Design principles	Independently create a user interface including design principles learnt	C2 preparation -Data processing skills using spreadsheet	Mock coursework task

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

AA Qualification BTEC National in IT (Extended Certificate) - 120 GLH	Y12 Content	Y12 Key Assessment	YR13 Content	Y13 Key Assessment
Autumn 1	Information Technology Systems: A: Explore the Concepts and Implications of the use of, and Relationships among Devices that form IT Systems B: Transmitting Data	Formative Topic Assessment: Topic A and B Internally Assessed	Unit 3: Website Development: A: Understand how the principles of Website Development are used to create Effective Websites	Pearson-Set Assignment Brief Task1: Conduct research to analyse how the principles of Website Development are used to meet a specific purpose and develop ideas and plans to meet a Client's Requirements
Autumn 2	Information Technology Systems C: Operating Online D: Protecting Data and Information	Formative Topic Assessment: Topic C and D Internally Assessed	B: Explore Website Design Skills and Techniques to meet Client Requirements	Pearson-Set Assignment Brief Task 2: Produce Designs and Assets for a Website to meet a Client's Requirements
Spring 1	E: Impact of using IT Systems F: Issues	Summative Assessment: An External Examination set and marked by Pearson	C: Develop a Website to meet Client Requirements	Pearson-Set Assignment Brief Task 3: Develop a website to meet a Client's Requirements
Spring 2	Cyber Security and Incident Management: A: Cyber Security Threats, System Vulnerabilities and Security Protection Methods	Formative Topic Assessment: Topic A Internally Assessed	Unit 4: Relational Database Development: A: Understand how the Principals of Relational Database Models, Data Storage and Normalisation are used to Create Effective Relational Database Solutions	Conduct research to Analyse how the Principles of Relational Database Management Systems, Data Storage and Normalisation are used to meet a Specific Purpose and Develop Planning Evidence to meet a Client's Requirements
Summer 1	Cyber Security and Incident Management: B: Use of Networking Architectures and Principles for Security C: Cyber Security Documentation	Formative Topic Assessment: Topic B and C Internally Assessed	B: Design a Relational Database Solution to meet Client Requirements	Produce, Review and Refine Designs in an Iterative Process to meet a Client's Brief
Summer 2	Cyber Security and Incident Management: D: Forensic Procedures	Summative Assessment: An External Examination Set and Marked by Pearson	C: Develop a Relational Database Solution to meet Client Requirements	Use Tools and Techniques to create a Relational Database Solution to meet a Client's Requirements

Further details from J.Maynard@barnwell.herts.sch.uk