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

Introduce your students to databases and SQL / SQLite and build their knowledge through to a mini-project which uses their existing knowledge of Python and Tkinter. 1.3.2a - Database Concepts Flat file databases Entity identifiers Indexing Primary, Secondary, and Foreign keys Relational databases 1.3.2b - Database Normalisation Relational DB design Relationships and ERD Referential integrity Linking DB tables / Link tables Normalisation - reasons and 1NF, 2NF, 3NF 1.3.2c Transaction Processing Capturing Information ACID Record locking Redundancy 1.3.2d SQL SELECT FROM WHERE Conditions Sorting Dot notation JOIN Data types ALTER / UPDATE / DELETE / DROP SQL Worksheets Customer database: Import provided flat-file database and query it James Bond movies: Import provided flat-file database and query it. Note: this resource is available separately from my TES store High Scores: Import provided relational database and query it Marvel Cinematic Universe: examine provided SQL to create a new database Mini-project: plan and create a relational database and use Python and Tkinter to build an interface. Note: this project expects students to have a basic knowledge of Tkinter and independently research how to implement SQLite 3 in Python. No support files are provided for this activity.

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

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

Transform your BTEC Level 3 Computer Science Unit 15 (Web Design) lessons with our expertly crafted resources! Designed to engage and empower students, these comprehensive teaching materials cover essential coursework topics (HTML, CSS, and JavaScript) to get your students engaged! Lesson 1: Web design An overview of the client-server relationship used by websites Basic design and layout principles Lesson 2: Introduction to HTML The structure of an HTML web page Commonly-used tags Self-paced worksheet for students Lesson 3: CSS CSS syntax External, internal, and in-line CSS Self-paced worksheet for students Lesson 4: Responsive design Explanation, reasons, and principles behind responsive design CSS media queries and examples Self-paced worksheet for students Lesson 5: Introduction to JavaScript Client-side vs server-side scripting Overview of the document object model (DOM) and how JavaScript interacts with it Self-paced worksheet for students Simple to deliver, with all answers to practical work, this is an ideal introduction to inspire and prepare your students for Unit 15. 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.

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 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) - Updated October 2022 to include Python Switch (match) Statements 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 file) 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.

A complete scheme of work for AQA 8132 Business Studies 3.6 Finance, featuring exam-style questions, financial statement spreadsheet examples, paired and group activities, printable worksheets, and discussion activities. Designed for a mixed-ability group, PowerPoints are clear and concise with chunked explanations and plenty of stretch activities for higher-attaining students. And, of course, all answers are supplied! 3.6.1 Sources of Finance + worksheet 3.6.2 Cashflow + worksheet + spreadsheet examples 3.6.3a Break-even + worksheet + spreadsheet example 3.6.3b Investment + worksheet 3.6.4 Financial statements + worksheets + spreadsheet examples Save yourself hours of planning with these tried and tested resources. Download now.

A complete scheme of work for AQA 8132 Business Studies 3.1: Business in the Real World, featuring exam-style questions, case studies, paired and group activities, printable worksheets, and discussion activities. Designed for a mixed-ability group, PowerPoints are clear and concise with chunked explanations and plenty of stretch activities for higher-attaining students. And, of course, all answers are supplied! The scheme of work includes the following: 3.1.1a The Purpose and Nature of Business + worksheet 3.1.1b The Purpose and Nature of Business + worksheet + support sheet 3.1.1c The Purpose and Nature of Business + exam question sheet + mark scheme 3.1.2 Business Ownership 3.1.3 Setting Business Aims and Objectives 3.1.4 Stakeholders + answer sheet 3.1.5 Business Location + worksheet 3.1.6 Business Planning + worksheet 3.1.7 Expanding a Business + worksheet + answer sheet Save yourself hours of planning with these tried and tested resources. Download now.

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.

A complete scheme of work for AQA 8132 Business Studies: 3.5 Marketing, featuring exam-style questions, case studies, paired and group activities, worksheets, and discussions. Designed for a mixed-ability group, PowerPoints are clear and concise with chunked explanations and plenty of stretch activities for higher-attaining students. And, of course, all answers are supplied! The scheme of work includes the following: 3.5.1 Identifying and Understanding Customers 3.5.2 Market Growth and Segmentation + worksheet 3.5.3 The Purpose and Methods of Market Research 3.5.4a Overview of the Marketing Mix + printable case study 3.5.4b The Marketing Mix - Product + printable activity sheet 3.5.4c The Marketing Mix - Price + printable worksheet 3.5.4d The Marketing Mix - Promotion + printable worksheet 3.5.4e The Marketing Mix - Place + printable worksheet Save yourself hours of planning. Download now.

Complete scheme of work for J277 OCR Computer Science 1.4 Network 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 + Overview of AO3 DDoS attack, questions, and mark scheme 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!

Complete scheme of work for AQA 8132 Business Stdies: 3.4 Human Resources, featuring exam-style questions, paired activities, worksheets, and group discussions. Designed for a mixed-ability group, and including large colourful diagrams and graphics; simple, chunked explanations; plenty of stretch activities for higher-ability students; and answers to all questions! This scheme of work includes the following: 3.4.1a Organisation Structures + worksheet 3.4.1b Organisation Structures 3.4.2 Recruitment and Selection of Employees (double lesson) + worksheet 3.4.3a Motivating Employees 3.4.3b Motivating Employees 3.4.4 Training A complete scheme of work which gives your students an interesting and informative lesson, and saves lots of planning for you! Download now.

Complete scheme of work for AQA 8132 Business Studies: 3.2 Influences on Business, featuring exam-style questions, paired activities, group work, and online research tasks. Designed for a mixed-ability group, and including large colourful diagrams; simple, chunked explanations; plenty of stretch activities for higher-ability students; and answers to all questions! This scheme of work includes the following PowerPoint lessons: 3.2.1 - Technology 3.2.2a - Ethical Considerations, plus printable class scenarios 3.2.2b - Environmental Considerations 3.2.3a - The Econcomic Climate 3.2.3b - Interest Rates 3.2.4 - Globalisation 3.2.5a - Legislation (a) 3.2.5b - Legislation (b) 3.2.6 - The Competitive Environment Download this complete unit of work to save hours of work.