Computer Science Curriculum Plans

Year 7 Autumn

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

‘Think like a computer scientist’

Students will master the two main concepts of computer science; decomposition and algorithms.  Students will be introduced to the concept of decomposition and identification of problems.  Students will develop their knowledge of algorithms and pattern recognition.

Students will evaluate a decomposed problem and find an effective solution, by developing clear algorithms, that can be easily translate to code.  They will be able to apply computational thinking to evaluate and come to a conclusion. 

Class tasks relating to each segment of the decomposition and algorithm.

An end of unit exam to test the students' knowledge and understanding.

 

Year 7 Spring

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

Micro-Bit

In this unit students will be introduced to the first step of programming.   This unit will allow students to gather knowledge of a structure programming environment with micro bit machine.

Students will learn the different parts of the microbit.  To program a simple animated microbit and be able to upload the image.  Develop their knowledge the programming construct of; select, if, if else, functions and variable.

Students to create code that includes selection, looping, function and a trigger using the BBC micro bit platform.

To be able to create effective and efficient code without any support. To use a range of sensors, function and variables in their code. To be able to explain why function, selection, looping is used in code.

Students are assessed at the end of each unit and each topic within a unit.  Assessments are in the form of written and online tests using Yacapaca.

Year 7 Summer

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

Introduction to coding through KODU

Students will be introduced to the fundamentals of computer programming and games design via Kodu. Kodu is a highly intuitive graphical and textual coding environment.

Students will be introduced to the idea of computer programs, requiring a precise series of statements and, through using Kodu, will have a shared understanding of how to build a world and program characters and objects before moving on to enhance their games with more advance features.

Master the basic programming concepts and how to navigate the programming environment and add objects.

Create a fully functioning world and games, including features and characters controls by players.

Learn how to use effective angles and camera shots around built terrains.

An assessment using an online platform to access the gaming concepts, code and character.

 

Year 8 Autumn

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

Databases

Students will learn how to develop a database system from a given scenario. Students will identify a field name and primary key for a database table. They will query a database system using Boolean expressions and  explain the need for a Lookup function in a database system.

 

Students will be able to us DDL commands to manipulate a data in a DBMS and to assess and evaluate database against a given criteria. Students will create complex queries and analyse a data set for a report and explain the different between verification and validation.

Students will be assessed at the end of each unit.  Assessments are in the form of written and online using Yacapaca.

Year 8 Spring

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

Binary and Python

Students will be introduced to various number system.

Students to develop their knowledge and skills of converting from binary to decimal and decimal to binary.  To have a demonstrative knowledge of Binary addition, minus and overflow.

Students will be introduced to python programming. To have demonstrative knowledge script and interactive mode of python program.  To have knowledge of python key syntax and use of various internal functions; variables, data types, input, loops, if and elif statement. 

Students to know when use which data type, loop, variable, edit variable to see different outcomes and explain why.  To demonstrate knowledge of creating efficient program, importing modules, list and explain why functions are more useful. students to be able to explain choices of programming techniques, loops used in their programs. 

Students are assessed at the end of each unit.  Assessments are in the form of written and Online tests using Yacapaca.

Year 8 Summer

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

'Sorted'

Students will be introduced to the concept of an algorithm to sort data.  Students will master the concept of bogo sort, swap sort , bubble sort and be able to use pseudo code to efficiently code the bubble sort algorithm.

They will apply their understanding of each concept to a data set.

 

Compare both bogo and swap sort algorithm in terms of efficiency and speed.  Show clear understanding of a sorting algorithm and give a thorough explanation of how bubble sort is applied to a data set, evaluating the limitations of the concept.

Students will demonstrate excellent knowledge of all sorting algorithms by comparing each algorithm and to select the best sorting algorithm for a given set of data.

Students will use data sets to practise applying bubble sort, swap and selection sort algorithm.  The result of their application will be recorded in their self evaluation sheet.

During the end of unit assessment, students will be tested on the application and concepts of bubble, swap and selection sort methods.

 

 

Year 9 Autumn

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

Networking

This is a theoretical unit covering the basic principles and architecture of local and wide area networks. Students will learn that the World Wide Web is part of the Internet, and how web addresses are constructed and stored as IP addresses. Client-server, peer-to-peer networks and the concept of cloud computing are all described. Ways of keeping data secure and simple encryption techniques are also covered.

Students will design a network layout for the school, using icons to represent server, hub, switch, router, Internet, workstation, printers etc.

Students will be able to describe the concept of cloud computing and some of the benefits it brings to individuals and organisations.

They will be able to explain the meaning and significance of bandwidth and buffering.

Students will be assessed at the end of each unit.  Assessments are in the form of written and online using Yacapaca.

Year 9 Spring

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

HTML and Website Development

This unit is an introduction to HTML and Web Development.

Students will learn the basics of HTML and CSS, and how to create a responsive design which adapts to any size of screen for viewing on, say, a mobile phone or a PC. They will learn how to create text styles and add content, including text and graphics, in a specified position on a page, as well as navigation links to other pages on their website and to external websites.   The basics of good design are covered, students will develop their own templates in a text editor such as Notepad or using serif web design.  They will decide on a topic for their websites, document their designs and collect suitable text and images. They will then use their HTML templates to create their websites, including a web form. Students can view the data collected by the web form into a simulated database.  Students will also the importance of privacy and data.

Students to use range of HTML tags to create well laid out web pages. Students to write CSS code to define the styles of different parts of their web pages.  Students to create a user responsive design in creating their website so that the web pages will adapt to any size of screen.

To add enhancements or additional features to their original basic design. To construct a good-looking, well-formatted interactive website that is suitable for its intended audience.

Students are assessed at the end of each unit and each topic within a unit.  Assessments are in the form of written and online tests using Yacapaca.

Year 9 Summer

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

System Architecture, memory and storage

Students will gain knowledge of the various components of the CPU used in the Von Neumann architecture. student will gain knowledge of RAM, ROM, cache and virtual memory.  

Students will examine the need for secondary storage device and their practical advantages in given applications.

 

Students will demonstrate the purpose and function of the CPU. Students can clearly explain the role and operation of the CPU registers are used in Von Neumann architecture.

Explain the the relation between MAR AND MDR, PC and the accumulator.

Thoroughly explain the functions of the ALU, CU and cache. Show clear knowledge of how common characteristic of clock speed, cache size and number of core can affect its performance.

Students will be assessed on applying their knowledge to answer a range of questions.

Students will be assessed on computational thinking skills and their abilities to apply their knowledge of computers. 

 

 

Year 10 Autumn

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

Programming Project Guidance

 

OCR provides three Programming Project tasks each year from which a students must complete one: As a department we are are doing task 2.  

The following knowledge will be taught and demonstrated: Data types and arithmetic operations. Sequence, selection and iteration are covered. Students will cover arrays arrays, procedures, records and reading from and writing to a text file.

Students should produce a comprehensive report.  They will document their work on the Programming Project task from start to finish.

During their code/solution, they will develop the evidence to show that they have completed the following:

Analysis, Design, Development, Testing and Evaluation.

Teachers may not assist and give feedback to candidates during the Programming Project, but candidates must be the driving force behind their solution. Teachers must not restrict candidates to specific solutions or provide entire solutions.

Year 10 Spring

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

Programming Techniques and Unit 3 Programming Project.

In this unit covers the use of an IDE to develop/debug a program, and the fundamentals of programming.  This unit is run in parallel with practical programming sessions and Programming Project.

Students will learn to describe features of an IDE which are useful in developing and debugging a program.  Students will write a coded solution for a problem involving iteration and selection (branching), subroutines with parameters, two-dimensional arrays, local, global variables in subroutines and recursive algorithm.

Students will apply coded solutions to their respective programming project.

The Programming Project provides an opportunity for students to demonstrate their practical programming ability in their project.

Students will learn the following:

Analysis - how to analyse and identify the requirements for a solution to the problem.

Design - how to design suitable algorithms to represent the solution to a problem.   How to design suitable input and output formats and navigation methods for their system.

Development - how to develop a solution to the identified problem using a suitable programming language (Python).

Testing - how to produce a full report covering all aspects of the investigation.

Evaluation - how to critically appraise the evidence that they have presented. 

To write complex algorithms and codes involving data structures, subroutines and file-handling etc.  To interpret complex code and determine the output of their coded solutions. To         explain why using local variables makes a program easier to maintain.

Explain and distinguish between passing parameters by value and by reference. Explain and justify the use of object-oriented programming techniques to solve problems.

Students present clear and well structure report, showing details analysis of the problem domain. Clear design linked to the structure analysis, the coded solution in a suitable programming language (Python). The solution must be tested to ensure they solve the stated problem from the analysis. Students must create a suitable test plan with appropriate test data.

The code must be suitably annotated to describe the process. Test results should be annotated to show how these relate to the code, the test plan and the original problem. Learners will need to provide an evaluation of their solution.

Students are assessed at the end of each unit and each topic within a unit.  Assessments are in the form of written and online tests using past papers.

Year 10 Summer

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

Programming Theory and Algorithms

Students will gain knowledge of how to declare and use constants and variables and will understand and use arithmetic operators including MOD and DIV.

Students will gain further knowledge of inbuilt functions, be able to use random number generation and follow through pseudocode solutions to simple problems involving sequence, selection and iteration.

They will be able to explain why functions and procedures are used in creating solutions to problems in computer science.

Students will gain knowledge and skills of functions, procedure procedures that return values to the calling program and able to write and interpret simple SQL statements.

To independently write pseudocode solutions to simple problems involving sequence, selection and iteration.

To be able to give examples of data structures: arrays and records when answering exam questions. Use one/two-dimensional arrays in their design of solutions to computer science problems.

Be able to create functions and procedures using parameters as appropriate to a given problem. Write SQL statements which use the wildcard *, complex criteria and which specify a sort order.

Students are assessed at the end of each unit and each topic within a unit. Assessments are in the form of written and online tests using past papers.

 

 

Year 11 Autumn

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

Programming Project Guidance

 

OCR provides three Programming Project tasks each year from which a students must complete one: As a department we are are doing task 2.  

The following knowledge will be taught and demonstrated: Data types and arithmetic operations. Sequence, selection and iteration are covered. Students will cover arrays arrays, procedures, records and reading from and writing to a text file.

Students should produce a comprehensive report.  They will document their work on the Programming Project task from start to finish.

During their code/solution, they will develop the evidence to show that they have completed the following:

Analysis, Design, Development, Testing and Evaluation.

Teachers may not assist and give feedback to candidates during the Programming Project, but candidates must be the driving force behind their solution. Teachers must not restrict candidates to specific solutions or provide entire solutions.

Year 11 Spring

What are we learning?
What Knowledge, Understanding and Skills will we gain?
What will excellence look like?
How will these be assessed?

Programming Techniques and Programming Project

In this unit covers the use of an IDE to develop/debug a program, and the fundamentals of programming.  This unit is run in parallel with practical programming sessions and Programming Project.

Students will learn to describe features of an IDE which are useful in developing and debugging a program.  Students will write a coded solution for a problem involving iteration and selection (branching), subroutines with parameters, two-dimensional arrays, local, global variables in subroutines and recursive algorithm.

Students will apply coded solutions to their respective programming project.

The Programming Project provides an opportunity for students to demonstrate their practical programming ability in their project.

Students will learn the following:

Analysis - how to analyse and identify the requirements for a solution to the problem.

Design - how to design suitable algorithms to represent the solution to a problem.   How to design suitable input and output formats and navigation methods for their system.

Development - how to develop a solution to the identified problem using a suitable programming language (Python).

Testing - how to produce a full report covering all aspects of the investigation.

Evaluation - how to critically appraise the evidence that they have presented. 

Students will complete lesson tasks demonstrating their understanding variable types, integer, real, Boolean, character and string

They will clearly show knowledge of following through pseudocode solutions to simplify problems involving sequence, selection and iteration.

They will demonstrate good knowledge of variable naming, arithmetic operations, string manipulation functions, built in function and to give a clear explanation of  why functions and procedures are used in creating solutions to problems.

Students will be able to independently write and interpret simple SQL statements.

They will demonstrate thorough knowledge of data structures, use one-dimensional arrays in the design of solutions to simple problems and write simple functions and procedures using parameters, and be able to independently write codes to read from and write to a text file.

Students are assessed at the end of each unit and each topic within a unit.  Assessments are in the form of written and online tests using past papers.