Computing

Key Stage 3

Year 7 Computing Curriculum

Main topics covered:

  • E-Safety
  • Adventure Story (Interactive Presentation)
  • Spreadsheets
  • Data representation (Binary)
  • Computer programming

Main knowledge, understanding and skills to develop:

All pupils will have an understanding of what personal information is and where and it is appropriate to share it. They will know the agencies to go to if need arises.  Pupils will demonstrate their skills and knowledge of presenting data in a multimedia presentation aimed at a specific audience.  Pupils will be introduced to Spreadsheet terminology such as a cell, row and column.  They will learn how to enter data, formulas and functions in and use these to create simple models. They will be able to use these models to answer “what-if” questions.  Pupils will understand the basics of computer hardware. They will gain further understanding of how computer transfer information through the use of binary. Pupils will know how the binary system works and how it can be translated into a form that we can understand.  Pupils will gain an understanding of computer programmes and will be able to plan a set of instructions to solve a given problem. They will be introduced, through the programme Scratch, how to manipulate an object on the screen and plan, design and build a simple computer game.

Homework is planned to be set once every 2 weeks depending on the progress made during the lesson. During the programming unit of work, pupils will have the opportunity of continuing with their programme on Scratch if they have an online account.

Assessment of pupils’ understanding and progress could take different forms depending on the topic. In the main topics, pupils build up a product during the topic and complete an evaluation at the end of the topic. Both these will be used to assess pupil’s progress.

 

Year 8 Computing Curriculum

Main topics covered:

  • My Digital World
  • Hardware
  • Databases
  • Micro:bit
  • Webpage Design
  • Introduction to Pseudocode
  • Computer Programming

Main knowledge, understanding and skills to develop:

Pupils will learn about what to look for in websites when deciding if they are trustworthy or not and practice evaluating a range of websites for trustworthiness and reliability. Also they will learn about how search engines work and techniques for searching smarter that reduce search results and increasing their relevance. Also learn about the Copyright Law and understand how to use other peoples’ ideas/work without breaking copyright law. Pupils will be made aware of many dangers that are online and learn how to stay clear of these dangers. Finally, pupils will learn about cyber abuse and what they can do to combat cyber abuse.

Pupils will learn about the basic structure of a computer system, from the main components, input and output devices, to the individual components inside a computer and their functions. Finally they will learn how data is transferred through the introduction of binary.

Pupils will learn about creating and using relational databases. They will learn how to create a table, form, query, report and a main menu. They need to solve a problem using basic and advanced queries.

Pupils will learn about the basic coding concepts using a BBC micro:bit, such as variables, types, procedures, iteration, and conditionals. Solving problems with the BBC micro:bit will expose pupils to computational thinking skills, such as abstraction, decomposition, pattern matching, algorithm design, and data representation.

Pupils learn how to use Serif WebPlus to create a website. The will learn about what makes a good and not-so-good website. They will learn about how to insert text, images, roll over images, hyperlinks, buttons and image hot spots on a website.

Pupils will learn some programming techniques using Python. Pupils will learn about variables, console programmes, IF statements and While loops.

Homework is planned to be set once every 2 weeks depending on the progress made during the lesson. During the programming unit of work, pupils will have the opportunity of continuing with their programme on Scratch if they have an online account.

Assessment of pupils’ understanding and progress could take different forms depending on the topic. In the main topics, pupils build up a product during the topic and complete an evaluation at the end of the topic. Both these will be used to assess pupil’s progress

 

Year 9 Computing Curriculum

Main topics covered:

  • E-Safety
  • Computer Crime and Cyber Security
  • Programming with Python
  • Data Representation
  • Photoshop
  • Creating a model using a Spreadsheet

Main knowledge, understanding and skills to develop:

All pupils will have an understanding of the potential risks of using emails and the internet and how to protect themselves from potential threats such as viruses, trojan horses and computer worms.

With this understanding, pupils plan and create a poster and leaflet about the impact of these threats and give advice on how to avoid them.

Pupils will learn about legal safeguards regarding computer use, including overviews of the Computer Misuse Act, Data Protection Act and Copyright Law and their implications for computer use. Phishing scams and other email frauds, hacking, “data harvesting” and identity theft are discussed together with ways of protecting online identity and privacy. Health and Safety Law and environmental issues such as the safe disposal of old computers are also discussed.

Pupils revisit computer programming from Year 8, but learn how to create variables, functions, understand different data types, how to design a windows form and how to assign code to various components.

The pupils will gain further understanding of how computer transfer information through the use of binary, denary, hexadecimal, bitmaps and sound files.

Pupils will learn how to edit images using simple Photoshop techniques and understand the uses of Photoshop and why it is used in the industry.

Pupils will gain knowledge and understanding of how to create a model using a spreadsheet. They will be able to use a variety of different formulas and built-in functions, including formula that link different sheets. They will know how to validate data that is entered and use various formatting techniques including conditional formatting.

Homework is planned to be set once every 2 weeks depending on the progress made during the lesson. During the programming unit of work, pupils will have the opportunity of continuing with their programme on Scratch if they have an online account.

Assessment of pupils’ understanding and progress could take different forms depending on the topic. In the main topics, pupils build up a product during the topic and complete an evaluation at the end of the topic. Both these will be used to assess pupil’s progress.