Complete scheme of work for J277 OCR Computer Science 2.3 Producing Robust Programs, including PowerPoint for each lesson, homework sheets, worksheets, 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:
2.3.1a Defensive Design (plus Python files)
2.3.1b Input Validation (plus Python files)
2.3.1c Maintainability (plus Python files)
2.3.2a Testing
2.3.2b Test Data
2.3.2c Refining Algorithms (plus Python files)
2 x Homework worksheets plus answers
End-of-module test paper plus answers
Save yourself hours of planning by downloading now.
A complete KS3 scheme of work, including how computers process and store binary, conversion to denary, binary addition, bitmaps, vector graphics, and sound.
Full of activities, discussions, and games especially written for years 7 to 9, and with all answers provided, this is an ideal introduction to key concepts to prepare and inspire your students for Key Stage 4.
Lesson 1: Binary to denary conversion + worksheet
Lesson 2: Denary to binary conversion + worksheet
Lesson 3: Binary addition and terminology + worksheet
Lesson 4: Character sets + worksheet
Lesson 5: Bits and pixels (bitmap and vector graphics) + worksheet
Lesson 6: Bits and sounds + worksheet
A fun scheme of work for students, easy-to-deliver for teachers. My students thoroughly enjoyed it, Iâm sure yours will too.
Download today.
Use SQL to return results of queries on the supplied James Bond movie database (e.g. What is the average IMDB rating of movies directed by John Glen?)
The worksheet includes instructions for creating a new database, uploading the SQL file to it, then using SQL to obtain the answers to questions. Students can copy and paste their queries and results into the worksheet, then save or print for marking.
SQL commands used: describe, select, count, from, where, group by, like, and, or; and wildcards.
The database is a single-table flat database.
This is an intermediate-level task, suitable for students who are already familiar with SQL commands and structure. It also assumes that users will be using phpMyAdmin and they have sufficient privileges to create and edit databases.
My Year 12 and 13 Computer Science A-Level students enjoyed the lesson, which took around 1 hour for most to complete.
Included: SQL file, student worksheet, teacherâs answer sheet.
Complete scheme of work for J277 OCR Computer Science 1.3 Networks, Connections, and Protocols, 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.3.1a Types of Networks
1.3.1b Performance Factors
1.3.1c Client-Server and Peer-to-Peer Models
1.3.1d Networking Hardware
1.3.1e The Internet, plus printable diagram
1.3.1f Star and mesh network Topologies
1.3.2a Wired and Wireless Connections
1.3.2b Encryption
1.3.2c IP and MAC Addressing
1.3.2d Standards and Protocols
1.3.2e The Concept of 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!
Engage your students with this interactive Python Turtle activity that builds key computational thinking skills, including decomposition; algorithm design; pattern recognition; and iteration, in a fun and accessible way.
This hands-on coding lesson begins with a simple paper-based maze activity to introduce the concept of using algorithms, moving on to using loops to improve efficiency. Students then apply their understanding by editing a pre-written Python Turtle file to control a mouse navigating a series of mazes to get the cheese.
Ideal for KS3 or beginner Python learners
Perfect for introducing iteration and algorithms
Includes multiple mazes and opportunities for creative extension
Whatâs included in the download:
Full teacher guidance with clear setup instructions
Student maze PowerPoint (printable or digital)
Presentation slides explaining the task, how iteration helps, and code walkthroughs
Python Turtle file with graphics in a ready-to-use ZIP folder
Solution file for the first maze in a separate ZIP folder
Five engaging mazes + a blank template for students to design their own
Students love this activity! Itâs a fantastic way to introduce key programming concepts through visual problem-solving and game-like tasks.
Perfect for Computer Science teachers looking for a ready-made, high-quality Python lesson that promotes logic, creativity, and engagement.
Ten string manipulation programming challenges to help students practice their Python and problem-solving skills and prepare for their Computer Science GCSE.
Students use their existing programming knowledge to plan each challenge in the booklet before testing it on their computer. This âwriting-before-typingâ approach helps to develop the crucial skills needed to gain maximum marks in the algorithms section of their exam.
The booklet is supplied ready to be printed and stapled to make a 16-page booklet (uses four duplex-printed A4 sheets), and as single pages for individual printing or uploading to your VLE.
A full set of example code is provided for teachers, written in a way which is appropriate for the GCSE students to fully understand.
This is a great way for students to practice their coding skills. Download today.
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.
Complete unit of work for J277 OCR Computer Science 1.1 Systems Architecture, 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.1.1a - Purpose of the CPU (including unplugged activity)
1.1.1b - CPU Components
1.1.1c - Von Neumann Architecture
1.1.1d - Factors Affecting CPU Performance
1.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!
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.
7.2.1abc Tables, Text, Referencing, Contents, Indexes Lesson PLUS worksheet
7.2.1d Advanced Mail Merge Lesson PLUS worksheet and example files
7.2.1e Macros Lesson PLUS worksheet
7.2.1fghij More Word Features Lesson
7.2.2abcd Presentation Techniques Lesson PLUS WAGOLL for activity
7.2.2efg Presentation Techniques Lesson
7.2.3a Design Lesson
7.2.3b HTML (Double) Lesson PLUS worksheets and example files
7.2.3b HTML Cheat Sheet
7.2.3c CSS Lesson PLUS example files
7.2.3c WAGOLL Website
7.2.3d Responsive Design Lesson PLUS Responsive HTML and CSS example files
7.2.3e Security Measures 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
Update: a review stated that some tasks were missing. This omission has been fixed and all of the tasks are present.
All lessons are tried-and-tested. Save yourself hours of work by downloading now.
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.
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.
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. Aspects of this scheme of work are also suitable for KS3 Computer Science.
4.1.2 Malware Lesson
4.1.3 Social Engineering Lesson
4.1.4 Hacking Lesson
4.1.5 4.1.1 Botnets and DDoS Lesson
4.1.6 Pharming Lesson
4.2.1 Vulnerabilities â Environmental Lesson
4.2.1 Vulnerabilities â Physical Lesson
4.2.1 Vulnerabilities â System Lesson
4.3.1 Impacts of an Attack Lesson
4.3.2 Consequences of an Attack Lesson
4.4.1 - 4.4.3 Prevention Measures Lesson
4.5.1 Legal Protection Lesson PLUS questions worksheet and marking scheme
4.5.2 Ethics and Morals Lesson PLUS âclassroom courtroomâ activity
4.6 Validity, Reliability and Bias 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.
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.
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.
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.
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!
Introduce Python 3 to your students using Turtle and Edublocks 4 (a free online drag-and-drop Python editor). Students program Turtle to draw a Christmas card. Their code can be downloaded and opened using IDLE or any other Python IDE.
Includes:
PowerPoint to get students started
Printable worksheet with step-by-step instructions to complete the project and challenge activities
Completed file which can be imported into Edublocks
Python files which can be opened using IDLE
Teachersâ instruction sheet
This is an ideal end-of-term standalone lesson ready for Christmas. I hope you and your students enjoy it.
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.
I hope you and your students enjoy using Weggo!
Add links to other web pages using the <a> tag. Links can be added to headline, paragraph, and list item tags.
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.
I hope you and your students enjoy using Weggo!
Download the complete scheme of work for J836 Cambridge National in IT, R050 Unit 2: Human Computer Interface (HCI) in Everyday Life. Includes fully editable student workbooks, end of topic test, PowerPoints, and all answers.
This resource comprises of:
2.1 Purpose, Importance and use of HCI
2.2 Hardware considerations
2.3 Software considerations
2.4 User interaction methods
Revision and assessment lesson, with test paper and mark scheme
Printable student workbook (PDF and editable Word documents)
One activity includes accessing the command line interface. Two different versions of the student booklet have been included: one for Windows PowerShell and one for Unix/Linux systems. This activity can also be entirely removed from the Word versions of the workbook.
Engaging lessons and academic for your students, ease of planning and flexibility for you!