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