Computing & ICT

KS3 KS4 Computing KS4 ICT KS5 Computing KS5 ICT

Contact: Mr D. Hewitt

National Curriculum

 

The Ecclesbourne School follows the 3 Year National Curriculum

 The national curriculum for computing aims to ensure that all pupils:

can understand and apply the fundamental principles and concepts of computer science, including abstraction, logic, algorithms and data representation. can analyse problems in computational terms, and have repeated practical experience of writing computer programs in order to solve such problems can evaluate and apply information technology, including new or unfamiliar technologies, analytically to solve problems are responsible, competent, confident and creative users of information and communication technology

  •  Design, use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems
  • Understand several key algorithms that reflect computational thinking [for example, ones for sorting and searching]; use logical reasoning to compare the utility of alternative algorithms for the same problem
  • Use 2 or more programming languages, at least one of which is textual, to solve a variety of computational problems; make appropriate use of data structures [for example, lists, tables or arrays
  • Design and develop modular programs that use procedures or functions
  • Understand simple Boolean logic [for example, AND, OR and NOT] and some of its uses in circuits and programming
  • Understand how numbers can be represented in binary, and be able to carry out simple operations on binary numbers [for example, binary addition, and conversion between binary and decimal]
  • Understand the hardware and software components that make up computer systems, and how they communicate with one another and with other systems
  • Understand how instructions are stored and executed within a computer system; understand how data of various types (including text, sounds and pictures) can be represented and manipulated digitally, in the form of binary digits
  • Undertake creative projects that involve selecting, using, and combining multiple applications, preferably across a range of devices, to achieve challenging goals, including collecting and analysing data and meeting the needs of known users
  • Create, reuse, revise and repurpose digital artefacts for a given audience, with attention to trustworthiness, design and usability
  • Understand a range of ways to use technology safely, respectfully, responsibly and securely, including protecting their online identity and privacy; recognise inappropriate content, contact and conduct, and know how to report

 

 

Curriculum Intent

 We have mapped our curriculum content against the national curriculum and have chosen a variety of units which ensure full coverage in line with national requirements.  We also strongly believe that we should develop student’s ICT skills as well as programming ability and therefore have included a range of topics which allow students to become competent in core computer usage.  We have looked at GCSE ICT and GCSE Computing and have ensured that we have pulled content down from both disciplines in order to prepare our students for either route.  We have chosen to use Scratch as our first programming language as students coming up from Primary are familiar with this package before then moving on to Small Basic which is a text based language similar to VB which is used at GCSE.

 By the end of key stage 3, students should be able to:

  • Design, use and evaluate computer systems
  • Understand several key algorithms that reflect computational thinking
  • Use 2 or more programming languages (currently, Scratch, HTML, Small Basic)
  • Understand simple Boolean logic
  • Understand how numbers can be represented in binary, and be able to carry out simple operations on binary numbers as well as being able to understand how data can be represented and manipulated digitally.
  • Understand the hardware and software components that make up computer systems and how instructions are stored and executed within a computer system

 Throughout the programme of study, students will undertake creative projects that involve selecting, using, and combining multiple applications to achieve challenging goals.   They will also have visited issues surrounding E-safety and will understand a range of ways to use technology safely, respectfully, responsibly and securely.

 The KS3 programme is devised to ensure students use the knowledge, skills, techniques, processes to respond to the world around them. It will ensure students are equipped and ready to extend their studies across the curriculum and be able to use ICT competently in their wider lives beyond KS3.

 

Curriculum Implementation

 

 

Term

Content

Year 7

Autumn Term

1

Inside a computer and binary

You will learn about the key components in a computer system and will also learn about the way computers think using 0’s and 1’s, a system which is called binary.

 

Outline:

  •  Log on and orientation
  • Computer components
  • Binary
  • File size and ASCII
  • Hardware and binary test

 

2

House Play project

In this project, you will learn how to use a variety of software packages with the theme of the school house plays. You will learn how to write a letter in Microsoft Word and carry out a mail merge, you will design a logo and will also build a seating model using Microsoft Excel.

 

Outline:

  • Desk top publishing / graphic manipulation: Logo creation
  • Word: Writing a letter
  • Word: Mail merging
  • Excel: seating plan
  • Excel: costing sheet

 

Spring Term

3

Programming Shapes

In this unit, you will learn how to draw shapes and produce art work using Scratch. This unit will also introduce you to the world of programming

 Outline:

  • Draw a square and other simple shapes
  • More complex shapes and Spirograph patterns
  • Mondrian style artwork
  • Scratch artwork test

 

4

Web Authoring

In this unit, you will learn how to use HTML to make a website. This unit will develop your programming skills further using a second language.

Outline:

  • Basic HTML
  • Planning a website
  • Collecting images
  • Building webpages
  • Main menu and hyperlinks

 

Summer Term

5

Bitmaps and Sound

In this unit, you will learn how computers store images and sound using binary. You will also get to be creative and produce Pixel art.

 

Outline:

  • Recap on binary
  • Representing sound digitally
  • Representing images
  • Pixel art
  • Using Excel to represent a bitmap

 

6

E-Safety

In this unit, you will think about staying safe online and will also design a Poster using Microsoft Publisher to help you develop your ICT skills.

 

Outline:

  • E-safety
  • Cyber bullying
  • Social media
  • Grooming
  • Digital footprint
  • Plagiarism and referencing

 

 

Term

Content

Year 8

Autumn Term

1

Networking

In this unit, you will learn about network hardware and software, key network topologies and protocols and you will write up your findings using a report.

Outline:

  • Network hardware and software
  • Network topology
  • Network protocols
  • Report on implementing a Computer network

 

2

Small Basic Programming

In this project, you will learn some of the key programming structures such as declaration, selection, iteration and will use these to produce a text based adventure.

 

Outline:

  • Introduction to Small Basic
  • Variables
  • Selection (if then else)
  • Iteration (loops)
  •  Branching and subroutines
  • Programming a text based adventure

Spring Term

3

Operating Systems and Ethics

In this unit, you will find out what tasks an operating system is expected to perform and will also find out about the ethical issues surrounding autonomous vehicles.

 

Outline:

  • Operating systems
  • Autonomous vehicles theory
  • The moral machine
  • Autonomous vehicles extended answer

4

Sub routines in Scratch and /Small Basic

In this unit, you will build on the programming shapes work done in year 7 and will move on to use subroutines to help draw your shapes more efficiently and will also apply these concepts to produce a graphical interface for a shop

 

Outline:

  • Procedures/functions in Scratch
  • Small Basic Graphics window
  • Graphical User Interface for a shop using Small Basic

Summer Term

5

Sorting

In this unit, you will learn about key sorting algorithms and find out about how these are programmed.

 

Outline:

  • Bubble Sort
  • Alternative sort algorithms

6

E-Safety

In this unit, you will think about staying safe online and will also design a professional leaflet using Microsoft Publisher to help you develop your ICT skills.

 

Outline:

  • Can you trust everything you see online?
  •  E safety Hot Topics
  • Staying safe online

 

 

Term

Content

Year 9

Autumn Term

1

Solving problems using small basic

In this unit, you will learn more about programming and will use declaration, iteration and selection as well as mathematical operations to help you solve problems.

 

Outline:

  • Variables
  • Selection.
  • Pseudocode
  • Operators
  • Systems flowcharts
  • Iteration
  • Integrated tasks

2

Logic gates and the fetch decode execute cycle

In this topic, you will learn some interesting Computing theory about the way in which a Computer processor functions.

  Outline:

  • The fetch decode and execute cycle, and logic gates
  • Logic Circuits
  • Binary Calculations

Spring Term

3

Spreadsheets and Databases

In this project unit, you will build a database and a spreadsheet and use them to collect and analyse school data.

 

Outline:

  • Introduction to Databases: tables and querying
  • Spreadsheets: formulas
  • Spreadsheets: Analysing data
  • Spreadsheets: Graphing data
  • Integrated report

4

Search algorithms and binary

In this unit, you will learn more about key sorting algorithms and the way that these are programmed, you will also learn more about calculations using binary.

 

Outline:

  • Linear search
  • Other search algorithms
  • Binary multiplication
  • Negative numbers and decimals in binary
  • Binary test

 

Summer Term

5

Ethics and E-safety

In this unit, you will learn more about E-safety and also think about whether it is ethical to profile people. You will learn about ways in which we can use social media safely and will consider your digital footprint.

 

Outline:

  • Computing ethics. Social media and e-safety
  • Using social media safely

 

6

Encryption, Enigma and Bletchley Park

In this unit, you will learn about the origins of modern Computers and how the work of Alan Turing and his team at Bletchley Park were fundamental in helping us to win the war.

 

Outline:

  • Film – the Imitation Game
  • Producing a fact sheet on the role of Bletchley park in the war
  •  Caesar Cipher
  • Programming a Caesar Cipher

 

Extra Curricular Activities

 

ICT Rooms open every lunch time for additional support from staff.  F8 is available to KS3 students and is also open from 8.40 -9.00 for catch up sessions.  Staff are available to provide help and support on request.  If you have a particular interest in an area of Computing, we can organise peer support from students with similar interests

STEM Robotics Lego programming club is run every year in collaboration with Science and allows KS3 students to build and program Lego robots which can be used to solve a number of different problems.  This culminates in a national competition at Rolls Royce every year.  The club is mixed ability and students greatly enjoy the opportunity to collaborate with their peers.

GCHQ Cyber Discovery Challenge is run every year for interested students and again, they can compete in a national competition.  This is a very stretching problem solving competition which students greatly enjoy.  This can be done in a team and students enjoy the opportunity to collaborate.

 

Resources

 

Small Basic and Scratch online tutorials:

https://smallbasic-publicwebsite.azurewebsites.net/tutorials

https://scratch.mit.edu/help/videos/

Bitesize -https://www.bbc.co.uk/bitesize/subjects/zvc9q6f

 W3Schools web tutorials- https://www.w3schools.com/

 Code academy -https://www.codecademy.com/

 Work from home and Office 365 give free access to most common software packages

Additional resources to support studies available on request

 

Course Assessment

Grade Assessment Detail
9 Students can independently identify and analyse a complex problem and innovatively plan it with no help; can write an innovative and highly efficient solution to a multifaceted problem and can comprehensively annotate work in a way which not only shows understanding but would also allow a third party to fully understand what has been done; can fully judge, critique, question, appraise, interpret, discuss and explain high level computing concepts and can investigate and formulate; present work in a professional, comprehensive and thorough manner.
8 Students can analyse, decompose and innovatively plan a complex problem with no help; can write innovative and efficient programa or solutions to problems with a wide scope and can clearly annotate work showing a high level of understanding; can extend the scope of the problem with their own ideas; can judge, critique, question, appraise, interpret, discuss and explain theoretical aspects of Computing; can also investigate and formulate; present work in a detailed and professional manner, fully documenting all design stages.
7 Students can analyse, decompose and plan a complex problem with little or no help; can write efficient programs or solutions to a problem with a wide scope and can clearly annotate work showing clear understanding; can investigate, judge, critique, question, appraise, interpret, discuss and explain theoretical aspects of Computing; present work is professional and detailed manner; can document all design stages.
6 Students can analyse and partially plan a complex problem with little or no help; can write a program or solution to a problem with a wider scope and can refine the solution to improve efficiency; can annotate work clearly and annotation shows understanding; can question, appraise, interpret discuss and explain theoretical aspects of Computing; presentat work is professional and detailed manner; can document most design stages.
5 Students can analyse and partially plan more complex problems with some help; can write a program or solution to a problem with a wider scope with little help and can refine the solution to improve efficiency; can annotate work clearly; can understand discuss and explain theoretical aspects of Computing; present work visually and clearly with detail.
4 Students can analyse a simple problem without any help; can write a simple program or solutions to problems with little, or no help; are able to refine solutions to improve efficiency, whilst providing some annotation; can discuss and explain theoretical aspects of Computing; present work clearly and containing a good level of detail.
3 Students can analyse a simple problem with little or no help; can write a simple program or solution to a problem with little help, whilst providing limited annotation; have basic knowledge of, and can discuss, theoretical aspects of Computing; present work in a reasonable way, containing a satisfactory level of detail.
2 Students can break down simple problems with some help; can write a basic programs or solutions to problems with some help; know some facts about Computing and can provide a context; present work reasonably and containing some detail.
1 Students need help to break down problems; create basic programs or solutions to problems which use simple instructions with help; know some facts about Computing; present work but only briefly.
 
Where I can find help or revision resources:

If you have any questions or queries relating to the ICT or Computing curriculum please email headofict@ecclesbourne.derbyshire.sch.uk for more information.