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
|
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
|
Computing Stage 8 Pages 14-18 |
|
Topic Three (1.3): Binary Number System and Converting Decimal to Binary
|
Computing Stage 8 Pages 18-23 |
|
Topic Four (1.4): Binary Calculations and Hexadecimal Number System
|
Computing Stage 8 Pages 24-30 |
|
Topic Five (1.5): Sound and Arithmetic Shifts
|
Computing Stage 8 Pages 31-35 |
|
Topic Six (1.6): Final Project
|
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
|
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
|
Computing Stage 8 Pages 46-50 |
|
Topic Three (2.3): How Does It All Happen? Checking It Out Online
|
Computing Stage 8 Pages 50-55 |
|
Topic Four (2.4): Web Browsers and Using Technology Safely
|
Computing Stage 8 Pages 55-59 |
|
Topic Five (2.5): Cyber Security and Digital Data
|
Computing Stage 8 Pages 59-64 |
|
Topic Six (2.6): Final Project
|
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
|
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
|
Computing Stage 8 Pages 72-76 |
|
Topic Three (3.3): HTML and CSS Style Tags, DIVs and Styles
|
Computing Stage 8 Pages 76-82 |
|
Topic Four (3.4): CSS Classes and Styles
|
Computing Stage 8 Pages 83-86 |
|
Topic Five (3.5): CSS Extended Stylesheets
|
Computing Stage 8 Pages 87-92 |
|
Topic Six (3.6): Final Project
|
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
|
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
|
Computing Stage 8 Pages 102-107 |
|
Topic Three (4.3): Adventure Choices
|
Computing Stage 8 Pages 108-116 |
|
Topic Four (4.4): Adventures with Lots of Choices: Going Upstairs in the House
|
Computing Stage 8 Pages 117-120 |
|
Topic Five (4.5): Answering the Robot’s Question and Validating User Input
|
Computing Stage 8 Pages 121-124 |
|
Topic Six (4.6): Final Project
|
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
|
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
|
Computing Stage 8 Pages 134-140 |
|
Topic Three (5.3): Testing Conditions Using the IF function
|
Computing Stage 8 Pages 141-145 |
|
Topic Four (5.4): Filtering and Sorting the Contents of a Spreadsheet
|
Computing Stage 8 Pages 145-148 |
|
Topic Five (5.5): Using Lookup Tables and Complex Formulas
|
Computing Stage 8 Pages 149-156 |
|
Topic Six (5.6): Final Project and Evaluation
|
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
|
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
|
MySQL - The Basics
Pages 10-11 |
|
Topic Three (6.3): Changing Data in a Table
|
MySQL - The Basics
Pages 11-15 |
|
Topic Four (6.4): Deleting Data from a Table
|
MySQL - The Basics
Pages 16-17 |
|
Topic Five (6.5): Creating a Table
|
MySQL - The Basics
Pages 18-21 |
|
Topic Six (6.6): Selecting Data from Multiple Tables
|
MySQL - The Basics
Pages 22-23 |
|
ASSIGNMENT SIX |
|
|