What does the course cover? The programme of study and National Curriculum links

The Wolsey Hall Part 2 Computing course follows the National Curriculum for England at Key Stage 3. 

We have ensured that all of the National Curriculum outcomes are covered in the course and the table below provides an overview of how the Wolsey Hall course can be mapped to the course textbooks and to the National Curriculum for England.

You may want to print out this overview of the course Download this overview of the course and refer to it as you progress through the course. Do also bear in mind that:

  • Before Module One, there is a Welcome call with your tutor.
  • At the end of Module Three, there is a mid-course review.
  • At the end of Module Six, there is an end-of-course review.

 

  Course introduction

Read the Course Guide and call with your tutor

 

Module One: Computer Systems: The Inside Track

National Curriculum Link

Coursebook Pages

Topic One (1.1): Robotics & AI, Collecting Input and Processing Voice Input

  • Describe robotics and artificial intelligence
  • Describe a system in terms of input, processing and output

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.

 

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 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.

Computing Stage 8

Pages 8-13

Topic Two (1.2): Storing Data Inside the Computer, Storing Text and Numbers as Binary

  • Describe the storage units in a computer
  • Describe how binary is used to store text
  • Describe how binary is used to store numbers

Computing Stage 8

Pages 14-18

Topic Three (1.3): Binary Number System and Converting Decimal to Binary

  • Describe the binary number system
  • Convert from decimal to binary

Computing Stage 8

Pages 18-23

Topic Four (1.4): Binary Calculations and Hexadecimal Number System

  • Perform binary addition
  • Describe the hexadecimal number system

Computing Stage 8

Pages 24-30

Topic Five (1.5): Sound and Arithmetic Shifts

  • Describe how computers sample and store sound

Computing Stage 8

Pages 31-35

Topic Six (1.6): Final Project

  • Plan the inputs and outputs of a robot-host
  • Apply decomposition and abstraction to a problem

Computing Stage 8

Pages 35-37

ASSIGNMENT ONE

 

 

Module Two: Networks and Communication: Across the World in an Instant

National Curriculum Link

Coursebook Pages

Topic One (2.1): E-communications, Emails, Emojis and Messaging Applications

  • Define a number of e-communications terms
  • Describe the functionality of an e-mail system
  • Describe an interactive messaging system

Understand the hardware and software components that make up computer systems, and how they communicate with one another and with other systems.

 

Understand a range of ways to use technology safely, respectfully, responsibly and securely, including protecting your online identity and privacy; recognise inappropriate content, contact and conduct and know how to report concerns.

 

Computing Stage 8

Pages 38-46

Topic Two (2.2): VC, VOIP and Keeping It Social

  • Describe the use of video conferencing
  • Describe the use of Voice over Internet Protocol
  • Describe the use of social media in business

Computing Stage 8

Pages 46-50

Topic Three (2.3): How Does It All Happen? Checking It Out Online

  • Describe networks in terms of LANs and WANs
  • Describe the technology needed to connect to the internet

Computing Stage 8

Pages 50-55

Topic Four (2.4): Web Browsers and Using Technology Safely

  • Describe the use of a web browser
  • Identify ways that you can use technology safely.

Computing Stage 8

Pages 55-59

Topic Five (2.5): Cyber Security and Digital Data

  • Describe a range of cyber security threats
  • Describe ways to improve data security

Computing Stage 8

Pages 59-64

Topic Six (2.6): Final Project

  • Provide advice about the use of communication tools within a company

Computing Stage 8

Pages 65-66

ASSIGNMENT TWO

 

 

Module Three: HTML and CSS: Getting your Head Straight

National Curriculum Link

Coursebook Pages

Topic One (3.1): About HTML & CSS and Planning Websites

  • Describe HTML and CSS
  • Describe structure diagrams and storyboards

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.

 

Computing Stage 8

Pages 67-71

Topic Two (3.2): HTML Paragraphs, Lists, Tables and Comments

  • Create paragraphs in HTML
  • Create ordered and unordered lists in HTML
  • Create simple tables in HTML
  • Create HTML comments

Computing Stage 8

Pages 72-76

Topic Three (3.3): HTML and CSS Style Tags, DIVs and Styles

  • Use CSS style tags
  • Use CSS DIVs with styles

Computing Stage 8

Pages 76-82

Topic Four (3.4): CSS Classes and Styles

  • Understand the use of classes in CSS

Computing Stage 8

Pages 83-86

Topic Five (3.5): CSS Extended Stylesheets

  • Be able to create and use external stylesheets

Computing Stage 8

Pages 87-92

Topic Six (3.6): Final Project

  • Produce different websites for different audiences

Computing Stage 8

Pages 93-94

ASSIGNMENT THREE

 

 

Module Four: High Level Programming Language: Expert Story Telling

National Curriculum Link

Coursebook Pages

Topic One (4.1): Using Python and IDLE in Script Mode

  • Create a Python program in shell mode
  • Create a Python program in script mode

Design, use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems.

 

Use two 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.

 

Create, re-use, revise and repurpose digital artefacts for a given audience, with attention to trustworthiness, design and usability.

 

Computing Stage 8

Pages 95-101

Topic Two (4.2): Capturing User Input

  • Capture user input as strings
  • Convert user input to integers

Computing Stage 8

Pages 102-107

Topic Three (4.3): Adventure Choices

  • Construct an IF... statement
  • Construct an IF... else statement

Computing Stage 8

Pages 108-116

Topic Four (4.4): Adventures with Lots of Choices: Going Upstairs in the House

  • Construct an elif statement

Computing Stage 8

Pages 117-120

Topic Five (4.5): Answering the Robot’s Question and Validating User Input

  • Validate user input within a while loop

Computing Stage 8

Pages 121-124

Topic Six (4.6): Final Project

  • Decompose and program a full solution to a problem

Computing Stage 8

Page 125

ASSIGNMENT FOUR

 

 

 

Module Five: Spreadsheet modelling: Model my merch

National Curriculum Link

Coursebook Pages

Topic One (5.1): Spreadsheets, Using Conditional Formatting and Data Validation

  • Create conditional formatting rules
  • Create range-based validation rules

Design, use and evaluate computational abstractions that model the state and behaviour of real-world problems and physical systems.

 

Computing Stage 8

Pages 126-133

Topic Two (5.2): Using Absolute Cell References, Named Cell Ranges and Built-In Functions

  • Use a named range and an absolute cell reference
  • Use some built-in formulas

Computing Stage 8

Pages 134-140

Topic Three (5.3): Testing Conditions Using the IF function

  • Construct an IF statement

Computing Stage 8

Pages 141-145

Topic Four (5.4): Filtering and Sorting the Contents of a Spreadsheet

  • Filter data in a spreadsheet
  • Sort data in a spreadsheet

Computing Stage 8

Pages 145-148

Topic Five (5.5): Using Lookup Tables and Complex Formulas

  • Create a VLookup in a spreadsheet
  • Use complex formulas

Computing Stage 8

Pages 149-156

Topic Six (5.6): Final Project and Evaluation

  • Complete a full spreadsheet solution to a problem

Computing Stage 8

Pages 156-157

ASSIGNMENT FIVE

 

 

Module Six: Relational Databases

National Curriculum Link

Coursebook Pages

Topic One (6.1): Exploring a Database and Selecting Data from a Table

  • Explore a database using SHOW and DESCRIBE
  • Extract data from a database using SELECT

Use two 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.

 

MySQL - The Basics

 

Pages 2-9

Topic Two (6.2): Inserting Data into a Table

  • Insert data into a table using INSERT

MySQL - The Basics

 

Pages 10-11

Topic Three (6.3): Changing Data in a Table

  • Update data using an UPDATE query

MySQL - The Basics

 

Pages 11-15

Topic Four (6.4): Deleting Data from a Table

  • Delete data from a table using a DELETE query

MySQL - The Basics

 

Pages 16-17

Topic Five (6.5): Creating a Table

  • Create a table using a CREATE query
  • Insert data into one table from another

MySQL - The Basics

 

Pages 18-21

Topic Six (6.6): Selecting Data from Multiple Tables

  • Select data from multiple tables at once

MySQL - The Basics

 

Pages 22-23

ASSIGNMENT SIX