Hero image

MrLangford's Shop

Average Rating4.17
(based on 10 reviews)

High quality innovative resources for KS3 and KS4 Computer Science and IT

32Uploads

5k+Views

42k+Downloads

High quality innovative resources for KS3 and KS4 Computer Science and IT
KS3 Operating Systems, Interfaces, Accessibility
MrLangfordMrLangford

KS3 Operating Systems, Interfaces, Accessibility

(0)
A comprehensive unit of work covering operating systems, interfaces, accessibility, and an introduction to utility software. Ideally suited to Year 8, but with enough stretch and challenge activities for Year 9. I have also taught this module to Year 7 with some work removed. The focus on operating systems feeds into J277 GCSE Computer Science; the interface aspects feed into BTEC Level 1/Level 2 Tech Award in Digital Information Technology. This unit of work comprises: Lesson 1: OS Functions PowerPoint: Introduction to different operating systems and their primary functions Worksheet and answer sheet Lesson 2: OS Types PowerPoint: More in-depth look at operating system functions and the difference between different operating systems. Worksheet and answer sheet Lesson 3: User Interfaces PowerPoint: Command Line Interfaces, Graphical User Interfaces (WIMP and Touch-based) Worksheet and answer sheet Lesson 4: Accessibility and Design PowerPoint: How users with different abilities can use computers and the evolution of the interface Worksheet and answer sheet Lesson 5: Utility Software PowerPoint: Introduction to utility software; introduction to compression and defragmentation Worksheet and answer sheet Online defragmentation activity Lesson 6: Recap and Quiz PowerPoint: Recap of unit and link to Quizizz activity This unit has been professionally designed (I’m an ex-graphic designer) and is suitable for delivery by subject and non-subject specialist teachers. Download the complete unit today for less than 60p per lesson!
J808 Cambridge National SoW LO1 - LO7 Bundle
MrLangfordMrLangford

J808 Cambridge National SoW LO1 - LO7 Bundle

8 Resources
Save countless hours of planning (and £10) with these complete schemes of work for LO1 - LO7 in Cambridge National Level 1/2 Information Technologies. Each of the seven Learning Objectives includes complete lessons, worksheets, examples, homework, answer sheets, learning checklist, end of module test and mark scheme. In total, there are 76 complete lessons and 21 homework sheets Save by buying in bulk and get your weekends back!
J808 LO5 Data Manipulation - Complete SoW Cambridge National Level 1/2 Information Technologies
MrLangfordMrLangford

J808 LO5 Data Manipulation - Complete SoW Cambridge National Level 1/2 Information Technologies

(1)
Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. Database lessons use Microsoft Access. 5.1.1a Spreadsheet Functions Lesson PLUS worksheet and example files 5.1.1b VLOOKUP Lesson PLUS worksheet and example files 5.1.2 Cell Referencing and Importing Lesson PLUS example and solution files 5.1.3 Charts and Tables Lesson PLUS worksheet 5.1.4 What-If Analysis Lesson PLUS worksheet, answer and example files 5.1.5 Macros Lesson PLUS worksheet 5.2.1 Relational database Lesson 5.2.2 Import data from other sources Lesson PLUS worksheet, sample and example files 5.2.3 Data validation Lesson PLUS worksheet, sample and example files 5.2.4 Input Forms Lesson PLUS worksheet, sample and example files 5.2.5 Queries Lesson PLUS worksheet, sample and example files 5.2.6-8 Reports, Security, Exporting Data Lesson plus database file 5.2.x Bringing It All Together – recap lesson incorporating all database learning 5.2.x Mini-project – Mini project Lesson to consolidate learning. WAGOLL included. 2 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.
KS3 Edublocks Python Turtle Unit
MrLangfordMrLangford

KS3 Edublocks Python Turtle Unit

(2)
Full unit of work for Edublocks, moving KS3 from Scratch to Python Turtle programming, with an emphasis on Computational Thinking, ready for moving to IDLE. Everything is fully resourced for simple delivery: answers, example files, and an end-of-unit assessment using Quizizz Lesson 1: Introduction to Python Overview of Computational Thinking; overview of the Python language; drawing equilateral shapes using Edublocks and Python Turtle. Edublocks XML files included. Lesson 2: Iteration Count-controlled and condition-controlled loops; Python’s for and while statements; using iteration to simplify drawing shapes using Edublocks and Python Turtle. Edublocks XML files included. Lesson 3: Variables Fun unplugged activity to explain the need and purpose of variables; using variables to store data. Edublocks XML files included. Lesson 4: Selection A comparison between how humans and computers make decisions; introduction to if, elif, and else statements. Edublocks XML files included. Lesson 5: Bringing it all Together A step-by-step guide to creating a program which asks the user to enter a shape name, and Turtle drawing it. Edublocks XML files included. Lesson 6: Revision and Assessment Q&A Revision; link to a Quizizz assessment on the unit of work; and a chance for students to reflect on their progress during the topic. Edublocks is a drag-and-drop programming language, visually similar to Scratch. My own students have enjoyed this topic and it has provided a good starting point for moving-on to IDLE. Lessons and examples use Edublocks 4 (due for release in Summer 2021) making this unit of work future-ready and a time-saving way to prepare students for IDLE.
J277 OCR 2.2 Programming Fundamentals
MrLangfordMrLangford

J277 OCR 2.2 Programming Fundamentals

(0)
Complete scheme of work for J277 OCR Computer Science 2.1 Computational Thinking, including PowerPoint for each lesson, homework sheets, worksheets, unplugged activities, Python example files, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following lesson PowerPoints and resources: Scheme of Work document 2.2.1a Variables, Constants, Operators, Inputs, Outputs, Assignments 2.2.1b Sequence, Selection, Iteration (inc Python files) 2.2.1c Arithmetic and Arithmetic Operators 2.2.2 Data Types (inc worksheet and Python solutions) 2.2.3a String Manipulation (inc Python solutions) 2.2.3b File Handling (inc Python solutions) 2.2.3c Databases and SQL (inc worksheet, answers, and Python SQLite 3 database) 2.2.3d Arrays 2.2.3e Subprograms 3 x Homework worksheets and answers 1 x End-of-topic test Includes dozens of Python demonstration files and a Python-based SQLite 3 database for students to test their SQL commands. Save yourself hours of planning. Download now.
J277 OCR 1.6 Ethical, Legal, Cultural and Environmental Impacts
MrLangfordMrLangford

J277 OCR 1.6 Ethical, Legal, Cultural and Environmental Impacts

(0)
Complete scheme of work for J277 OCR Computer Science 1.6 Ethical, Legal, Cultural and Environmental Impacts, including PowerPoint for each lesson, two homework sheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following: 1.6a - Introduction to topic and Stakeholders 1.6b - Ethical issues 1.6c - Society 1.6d - Cultural issues 1.6e - Environmental issues 1.6f - Privacy Issues 1.6g - Legislation (includes courtroom class activity) 1.6h - Software Licenses 2 x Homework sheets (10 marks, plus answer sheet) End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet) All lessons are tried-and-tested. Save yourself hours of work by downloading now. Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!
J808 LO3 Data and Storage - Complete SoW Cambridge National Level 1/2 Information Technologies
MrLangfordMrLangford

J808 LO3 Data and Storage - Complete SoW Cambridge National Level 1/2 Information Technologies

(0)
Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. 3.1.1 What is data? Lesson 3.1.2 Data types? Lesson 3.2.1 What is information? Lesson 3.2.2 How data and information are related Lesson 3.3.1-1 Data collection and storage Lesson 3.3.1-2 Data collection and storage Lesson 3.3.2 IT in data collection Lesson 3.4.1 Cloud Storage Lesson 3.4.2 Physical Storage Devices Lesson 3.5.1 Big Data Lesson 3.5.2 Data stores Lesson 3.5.3 Data benefits and drawbacks Lesson 3 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.
J277 OCR 1.1 - 1.6 SoW Bundle - Save 24%
MrLangfordMrLangford

J277 OCR 1.1 - 1.6 SoW Bundle - Save 24%

7 Resources
Save countless hours of planning (and nearly a quarter compared with buying units individually) with these complete units of work for Component 1 of J277 Computer Science. Each of the seven Learning Objectives includes complete lessons, worksheets, examples, homework, answer sheets, learning checklist, end of module test and mark scheme. In total, there are 47 complete lessons and 12 homework sheets Save by buying in bulk and get your weekends back!
J808 LO2 Planning - Complete SoW Cambridge National Level 1/2 Information Technologies
MrLangfordMrLangford

J808 LO2 Planning - Complete SoW Cambridge National Level 1/2 Information Technologies

(1)
Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. 2.1 Analysing Project Requirements Lesson and Sample Design Brief 2.2 Mitigating Risks Lesson 2.3.1a Gantt and PERT Charts Lesson PLUS ProjectLibre example file and activities 2.3.1b Spreadsheets Lesson PLUS worksheet and solution files 2.3.2 Critical Path Lesson PLUS Worksheet and solution files 2.3.3 Project Documentation Lesson 2.4.1 Testing (Functionality) Lesson 2.4.2 Testing (Useability) Lesson 2.4.3 Testing (Accessibility) Lesson 2.4.4 Testing (Test Plans) Lesson 4 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.
J808 LO1 Project Planning - Complete SoW Cambridge National Level 1/2 Information Technologies
MrLangfordMrLangford

J808 LO1 Project Planning - Complete SoW Cambridge National Level 1/2 Information Technologies

(0)
Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. 1.1 Project Life Cycle Lesson 1.2 Iterative Reviews Lesson 1.3 Inputs and Outputs Lesson and Worksheet 1.4 Initial Project Considerations Lesson 1.5.1-2 Planning Tools Lesson 1.5.2-3 Planning Tools and software Lesson 2 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.
J277 OCR 1.1 Architecture of the CPU
MrLangfordMrLangford

J277 OCR 1.1 Architecture of the CPU

(0)
Complete unit of work for J277 OCR Computer Science 1.1 Architecture of the CPU, including PowerPoint for each lesson, two homework sheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following: 1.1a - Purpose of the CPU (including unplugged activity) 1.1b - CPU Components 1.1c - Von Neumann Architecture 1.1d - Factors Affecting CPU Performance 1.1e - Embedded Systems 2 x Homework sheets (10 marks each, plus answer sheet) End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet) All lessons are tried-and-tested. Save yourself hours of work by downloading now. Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!
J808 LO6 Spreadsheets and Databases - Complete SoW Cambridge National Level 1/2 IT
MrLangfordMrLangford

J808 LO6 Spreadsheets and Databases - Complete SoW Cambridge National Level 1/2 IT

(0)
Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. 6.1.1 Spreadsheets Lesson PLUS supporting files 6.1.2 Databases Lesson 6.2.1 Presentation Software Lesson 6.2.2 Presentation Software Suitability Lesson 6.2.3 Presentation Pros and Cons Lesson 6.3.1 Hardware Requirements Lesson 6.3.2 Software Requirements Lesson 6.3.3 Connectivity Requirements Lesson 3 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.
Mouse Maze - KS3 Algorithm Starter
MrLangfordMrLangford

Mouse Maze - KS3 Algorithm Starter

(0)
Mouse Maze is a fun introduction to decomposition, algorithms and iteration (loops). It works well as an extended starter. Print out the simple maze, or distribute the PowerPoint file to students (the mouse icon can be dragged and rotated). They must list the steps required for Mousey to reach the cheese. Decomposition: breaking the problem into smaller steps (i.e. solving the maze) Algorithms: listing the steps to guide Mousey through the maze Iteration: making the algorithm more efficient by repeating parts of it (challenge / extension activity) The download includes: A full set of teacher’s instructions PowerPoint maze for students which can be used electronically or printed out PowerPoint 6 slides showing the task, solution, sections which are repeated, and a more efficient solution. The final slide has definitions of ‘algorithm’ and ‘decomposition’, plus a note to tell students that they have already achieved both during the lesson. Pupils enjoy the activity and it is a great way to introduce the concepts for the first time. I hope you and your pupils enjoy it :)
J277 OCR 1.4 System Security SoW
MrLangfordMrLangford

J277 OCR 1.4 System Security SoW

(0)
Complete scheme of work for J277 OCR Computer Science 1.4 System Security, including PowerPoint for each lesson, homework sheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following: 1.4.1a Forms of Attack Lesson 1.4.1b Social Engineering Lesson 1.4.1c Brute-force Attacks Lesson + Brute-force demo (Python) 1.4.1d Denial of Service Attack Lesson 1.4.1e Data Interception and Theft Lesson 1.4.1f SQL Injection Lesson + Worksheet + Demo database to hack (Python) 1.4.2a Software Prevention Methods 1.4.2b Prevention Against Hacking 2 x Homework sheets (10 marks each, plus mark sheets) 1 x End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet) Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!
Year 7 Digital Treasure Hunt
MrLangfordMrLangford

Year 7 Digital Treasure Hunt

(0)
When starting Secondary School, Year 7 students suddenly find they have to navigate the school’s vast network. Where are their files? What is a network location? How do they print? How do they open a document? This resource is designed to teach students to navigate the network and print using a fun Digital Treasure Hunt. The provided web page directs them to a file which contains a challenge – solve the challenge, enter the code into the web page, and move on to the next challenge. When all five challenges are completed, they can print a certificate. This resource includes: Digital Treasure Hunt Map (HTML, will run locally on your network) Treasure Hunt Lesson PowerPoint Activity 1: Web research task Activity 2: ASCII table lookup Activity 3: Logic puzzles Activity 4: Binary image encoding Activity 5: Opening a Python file Printable certificate Answer sheet Set up instructions You will need to edit a JavaScript file to personalise the locations of the activity files, but this is a straightforward task and full instructions are provided.
J277 OCR 1.2 Memory and Storage SoW
MrLangfordMrLangford

J277 OCR 1.2 Memory and Storage SoW

(0)
Complete scheme of work for J277 OCR Computer Science 1.1 Memory & Storage, including PowerPoint for each lesson, homework sheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following: 1.2.1 Primary Storage Lesson 1.2.2 Secondary Storage Lesson + Worksheet 1.2.3 Units of Data Lesson 1.2.4a Binary Conversion Lesson + Links to Binary Bingo & Denary Bingo games 1.2.4a Binary Addition Lesson + Worksheet + Answers 1.2.4a Hexadecimal Lesson 1.2.4b Character Sets Lesson 1.2.4c Image Representation Lesson + Worksheet + Answers + Python task 1.2.4d Audio Representation Lesson + Worksheet + Answers + Python task 1.2.5 Compression Lesson 3 x Homework sheets (10 marks each, plus mark sheets) 1 x End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet). Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!
J277 OCR 1.3 Networks SoW
MrLangfordMrLangford

J277 OCR 1.3 Networks SoW

(0)
Complete scheme of work for J277 OCR Computer Science 1.3 Networks, including PowerPoint for each lesson, homework sheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following lesson PowerPoints: 1.3a Types of Networks 1.3b Performance Factors 1.3c Client-Server and Peer-to-Peer Models 1.3d Networking Hardware 1.3e The Internet, plus printable diagram 1.3f Network Topologies 1.3g Wired and Wireless Connections 1.3h Encryption 1.3i IP and MAC Addressing 1.3j Standards 1.3k Layers 2 x Homework sheets (10 marks each, plus mark sheets) 1 x End of topic test (designed to look like an exam paper, 25 marks, plus mark sheet) Save yourself weeks of planning by buying the Component 1 bundle at a reduced price!
Weggo! Drag and drop HTML Editor: Tutorial 1
MrLangfordMrLangford

Weggo! Drag and drop HTML Editor: Tutorial 1

(0)
Introduce your students to HTML using a drag and drop interface. Designed to be intuitive and colourful, students drag Lego-like 'tag' blocks onto the board to build up their page. Works on both mouse-based computers and touch-screen tablets. This resource includes "Tutorial 1" and "Teacher's Notes", both as printable PDFs. Tutorial 1 is an introduction to the Weggo! interface and a quick "Hello world" lesson. The Teacher's Notes provide an overview of Weggo's usage, system compatibility, limitations and pointers for each of the five tutorials. Please be aware that Weggo! is 'beta' software, and some bugs will be present. Weggo! is a free-to-use website with no adverts or logins. Go to www.weggo.net I hope you and your students enjoy using Weggo!
4-Bit Binary Bingo
MrLangfordMrLangford

4-Bit Binary Bingo

(1)
Download the binary bingo card, then use the free bingo-caller website* to randomly generate numbers to call out. How to use: each student choses four numbers between 0 and 15 and writes them onto the bingo card. The teacher loads the website onto a screen or SMART Board. A random binary number is chosen and displayed. Students convert the binary number into denary. The first student to get all four numbers shouts "BINGO!" and wins. Called numbers are listed at the bottom of the screen, and can be clicked for conversion to denary. A great plenary activity for KS3 and KS4 students which reinforces binary to denary conversion. Have fun :) * The website URL is stated at the bottom of the downloadable PDF.
Weggo! Tutorial 2: Adding text to your web page
MrLangfordMrLangford

Weggo! Tutorial 2: Adding text to your web page

(0)
The second tutorial for the Weggo! HTML Editor introduces more text tags such as headlines and paragraphs, which students use to begin adding more content to their web page. Please be aware that Weggo! is 'beta' software, and some bugs will be present. Weggo! is a free-to-use website with no adverts or logins. Go to www.weggo.net I hope you and your students enjoy using Weggo!