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:

  • Sound Editing
  • Hardware
  • Databases
  • Micro:bit
  • Webpage Design
  • Computer Programming

Main knowledge, understanding and skills to develop:

Pupils will be given the opportunity of creating a story using a variety of sound effects. They will learn how to record, input, edit and export their sound effect story.

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
  • Information Reliability
  • 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.

Students research information from different sources and ensure they understand that the sources are reliable.

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.